# 'nan' error? **URL:** \ **Category:** Classic Servoy\ **Created:** [February 8, 2005, 7:11pm UTC](https://forum.servoy.com/t/nan-error/3641 "2005-02-08T19:11:52Z")\ **Posts on this page:** 13\ **Page:** 1
**Author:** ![RobertMeyer](https://avatars.discourse-cdn.com/v4/letter/r/db5fbb/32.png) [@RobertMeyer](https://forum.servoy.com/u/RobertMeyer)\ **Post date:** [February 8, 2005, 7:11pm UTC](https://forum.servoy.com/t/nan-error/3641/1 "2005-02-08T19:11:52Z")
my client has just started getting errors in the servoy log that we haven’t seen before. here’s the text from the log: ```auto java.sql.SQLException: Column not found: Unknown column 'NaN' in 'where clause' at org.gjt.mm.mysql.MysqlIO.sendCommand(MysqlIO.java) at org.gjt.mm.mysql.MysqlIO.sqlQueryDirect(MysqlIO.java) at org.gjt.mm.mysql.Connection.execSQL(Connection.java) at org.gjt.mm.mysql.PreparedStatement.executeQuery(PreparedStatement.java) at sun.reflect.GeneratedMethodAccessor21.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:324) at com.servoy.j2db.persistence.datasource.p.invoke(Unknown Source) at $Proxy1.executeQuery(Unknown Source) at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:179) at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:179) at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:179) at com.servoy.j2db.dataprocessing.SQLEngine.a(Unknown Source) at com.servoy.j2db.dataprocessing.SQLEngine.performCustomQuery(Unknown Source) at sun.reflect.GeneratedMethodAccessor93.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:324) at sun.rmi.server.UnicastServerRef.dispatch(UnicastServerRef.java:261) at sun.rmi.transport.Transport$1.run(Transport.java:148) at java.security.AccessController.doPrivileged(Native Method) at sun.rmi.transport.Transport.serviceCall(Transport.java:144) at sun.rmi.transport.tcp.TCPTransport.handleMessages(TCPTransport.java:460) at sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run(TCPTransport.java:701) at java.lang.Thread.run(Thread.java:552) ``` strangely enough, we can’t find any users having problems. i have no idea where to start looking for this problem; any advice would be greatly appreciated. thanks in advance. rm. ---
**Author:** ![patrick](https://avatars.discourse-cdn.com/v4/letter/p/b2d939/32.png) [@patrick](https://forum.servoy.com/u/patrick)\ **Post date:** [February 8, 2005, 7:14pm UTC](https://forum.servoy.com/t/nan-error/3641/2 "2005-02-08T19:14:10Z")
NaN means Not-A-Number. This error is thrown to tell you that a value is not a legal number. I can’t tell you though, why or where you get it… ---
**Author:** ![patrick](https://avatars.discourse-cdn.com/v4/letter/p/b2d939/32.png) [@patrick](https://forum.servoy.com/u/patrick)\ **Post date:** [February 8, 2005, 7:15pm UTC](https://forum.servoy.com/t/nan-error/3641/3 "2005-02-08T19:15:45Z")
Why don’t you use a stack trace and find the SQL statement that generates this error? It looks like at least one of the queries is offending and it sure won’t return any results. ---
**Author:** ![RobertMeyer](https://avatars.discourse-cdn.com/v4/letter/r/db5fbb/32.png) [@RobertMeyer](https://forum.servoy.com/u/RobertMeyer)\ **Post date:** [February 8, 2005, 7:17pm UTC](https://forum.servoy.com/t/nan-error/3641/4 "2005-02-08T19:17:57Z")
i was considering that, but this is a production system, and i would guess that the large amount of info that would be output by the stacktrace would degrade system performance… ---
**Author:** ![patrick](https://avatars.discourse-cdn.com/v4/letter/p/b2d939/32.png) [@patrick](https://forum.servoy.com/u/patrick)\ **Post date:** [February 8, 2005, 7:19pm UTC](https://forum.servoy.com/t/nan-error/3641/5 "2005-02-08T19:19:59Z")
And if you use that on a test system with mySQL you don’t get this error? ---
**Author:** ![RobertMeyer](https://avatars.discourse-cdn.com/v4/letter/r/db5fbb/32.png) [@RobertMeyer](https://forum.servoy.com/u/RobertMeyer)\ **Post date:** [February 8, 2005, 7:24pm UTC](https://forum.servoy.com/t/nan-error/3641/6 "2005-02-08T19:24:54Z")
right; we’ve never seen this error in testing. ---
**Author:** ![patrick](https://avatars.discourse-cdn.com/v4/letter/p/b2d939/32.png) [@patrick](https://forum.servoy.com/u/patrick)\ **Post date:** [February 8, 2005, 7:37pm UTC](https://forum.servoy.com/t/nan-error/3641/7 "2005-02-08T19:37:41Z")
it looks like a query like this ```auto WHERE column = ? and NaN = ? ``` is generated. I guess you better wait for answer from the guys who should know… ---
**Author:** ![RobertMeyer](https://avatars.discourse-cdn.com/v4/letter/r/db5fbb/32.png) [@RobertMeyer](https://forum.servoy.com/u/RobertMeyer)\ **Post date:** [February 8, 2005, 7:40pm UTC](https://forum.servoy.com/t/nan-error/3641/8 "2005-02-08T19:40:20Z")
i appreciate you’re help; thanks for responding! ---
**Author:** ![RobertMeyer](https://avatars.discourse-cdn.com/v4/letter/r/db5fbb/32.png) [@RobertMeyer](https://forum.servoy.com/u/RobertMeyer)\ **Post date:** [February 11, 2005, 3:57pm UTC](https://forum.servoy.com/t/nan-error/3641/9 "2005-02-11T15:57:44Z")
still waiting to hear from someone at servoy on this… any help would be appreciated. thans. rm. ---
**Author:** ![RobertMeyer](https://avatars.discourse-cdn.com/v4/letter/r/db5fbb/32.png) [@RobertMeyer](https://forum.servoy.com/u/RobertMeyer)\ **Post date:** [February 18, 2005, 3:41pm UTC](https://forum.servoy.com/t/nan-error/3641/10 "2005-02-18T15:41:56Z")
sorry to be a pest, but i’m still waiting to hear from someone at servoy on this one… thanks. ---
**Author:** ![RobertMeyer](https://avatars.discourse-cdn.com/v4/letter/r/db5fbb/32.png) [@RobertMeyer](https://forum.servoy.com/u/RobertMeyer)\ **Post date:** [February 28, 2005, 10:03pm UTC](https://forum.servoy.com/t/nan-error/3641/11 "2005-02-28T22:03:32Z")
again, I don’t mean to be annoying, but I’ve been waiting for a few weeks to get some help on this issue. my client is having this problem still, and they’re asking me to look into it. thanks in advance. rm. ---
**Author:** ![Jan\_Aleman](https://avatars.discourse-cdn.com/v4/letter/j/4af34b/32.png) [@Jan\_Aleman](https://forum.servoy.com/u/Jan_Aleman)\ **Post date:** [February 28, 2005, 11:54pm UTC](https://forum.servoy.com/t/nan-error/3641/12 "2005-02-28T23:54:19Z")
Did you email it to servoy support? The forum is great place to file non mision critical and generic questions to. if you have mission critical questions Servoy famous support (with free quick support and realtime paid for support) is there to help you. Looking at your initial query it looks like it slowly moved from interesting feedback to a critical problem? We also don’t see any replies to patrick’s excellents suggestions from you. Based on what we read our first thought is programming error but again we can only guess with the limited amount of information you post. If you need a quick solution email Servoy support ([support@servoy.com](mailto:support@servoy.com)) a reproduceable case and they will get back to you very soon. ---
**Author:** ![RobertMeyer](https://avatars.discourse-cdn.com/v4/letter/r/db5fbb/32.png) [@RobertMeyer](https://forum.servoy.com/u/RobertMeyer)\ **Post date:** [March 1, 2005, 4:42pm UTC](https://forum.servoy.com/t/nan-error/3641/13 "2005-03-01T16:42:59Z")
Thanks Jan; I’ll send an e-mail to servoy support as you suggest. rm.