Update Calculations Intermittently Crashes Servoy

Classic Servoy
1

Hi,

I have a number of workflow calculations based on fields within my solution and other linked databases. I have been using the updatecalculations script in a batch script for a few months to update these.

However recently I have been finding that i wake up in the morning to find my server is running at 273% of CPU with the memory being taken up by Java, and servoy very unresponsive. On restarting servoy the server calms down and java runs at the usual 5-6% of CPU rate.

The increase in CPU usage is in line with the update calculations part of my script running, and i have also seen this happen once when doing it using it in developer on the server. The weird thing is that when i forced quit developer (which also hang and was using over 250% of CPU) and ran it again it worked fine.

I do not fully understand the debugger Java information, but the other weird thing is that the errors it was trapping when using the batch script appeared in some of the messages unrelated fields to those which are calculation fields as set in my servoy batch solutions.

This appears intermittent and I am finding it hard to trap the data or even the rows in the database which might be causing this. Anecdotally, i thought that when i swtiched to the found set in developer and ran through to the end of all the records, loading more than the 200, (there are about 3500 records at the moment, that that is when it worked after the crash, but this could have been a pure coincidence.

I attach the log, to see if anyone can give me any pointers. The other thing is the field mlr_appointment_conf that is referred to many times is not a timestamp field, but an integer and the calculation which looks at another database through a relation is simply looking at another integer field.

2009-08-25 01:06	TaskExecuter[0]	ERROR	com.servoy.j2db.util.Debug	Throwable
java.sql.SQLException: Cannot convert value '0000-00-00' from column 30 to TIMESTAMP. 
    	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1055) 
    	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956) 
    	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:926) 
    	at com.mysql.jdbc.ResultSetRow.getTimestampFast(ResultSetRow.java:1321) 
    	at com.mysql.jdbc.BufferRow.getTimestampFast(BufferRow.java:573) 
    	at com.mysql.jdbc.ResultSetImpl.getTimestampInternal(ResultSetImpl.java:6617) 
    	at com.mysql.jdbc.ResultSetImpl.getTimestamp(ResultSetImpl.java:5943) 
    	at org.apache.commons.dbcp.DelegatingResultSet.getTimestamp(DelegatingResultSet.java:150) 
    	at org.apache.commons.dbcp.DelegatingResultSet.getTimestamp(DelegatingResultSet.java:150) 
    	at org.apache.commons.dbcp.DelegatingResultSet.getTimestamp(DelegatingResultSet.java:150) 
    	at com.servoy.j2db.dataprocessing.BufferedDataSet.<init>(Unknown Source) 
    	at com.servoy.j2db.dataprocessing.SQLEngine.a(Unknown Source) 
    	at com.servoy.j2db.dataprocessing.SQLEngine.a(Unknown Source) 
    	at com.servoy.j2db.dataprocessing.SQLEngine.performQuery(Unknown Source) 
    	at com.servoy.j2db.dataprocessing.RowManager.a(Unknown Source) 
    	at com.servoy.j2db.dataprocessing.FoundSet.int(Unknown Source) 
    	at com.servoy.j2db.dataprocessing.FoundSet.for(Unknown Source) 
    	at com.servoy.j2db.dataprocessing.FoundSet.getRecord(Unknown Source) 
    	at com.servoy.j2db.dataprocessing.JSDatabaseManager.js_recalculate(Unknown Source) 
    	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) 
    	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) 
    	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) 
    	at java.lang.reflect.Method.invoke(Method.java:585) 
    	at org.mozilla.javascript.NativeJavaMethod.call(NativeJavaMethod.java:334) 
    	at org.mozilla.javascript.ScriptRuntime.call(ScriptRuntime.java:1254) 
    	at org.mozilla.javascript.gen.c2683.call(update_calculations:4) 
    	at org.mozilla.javascript.ScriptRuntime.call(ScriptRuntime.java:1254) 
    	at org.mozilla.javascript.gen.c4.call(batch1:11) 
    	at com.servoy.j2db.scripting.f.executeFunction(Unknown Source) 
    	at com.servoy.j2db.plugins.ClientPluginAccessProvider$a.run(Unknown Source) 
    	at com.servoy.j2db.server.headlessclient.h.invokeLater(Unknown Source) 
    	at com.servoy.j2db.plugins.ClientPluginAccessProvider$1.run(Unknown Source) 
    	at com.servoy.j2db.util.as.run(Unknown Source) 
    	at java.lang.Thread.run(Thread.java:613) 
    Caused by: java.sql.SQLException: Value '[B@48b28f' can not be represented as java.sql.Timestamp 
    	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1055) 
    	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956) 
    	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:926) 
    	at com.mysql.jdbc.ResultSetRow.getTimestampFast(ResultSetRow.java:1027) 
    	... 30 more
2009-08-25 01:06	TaskExecuter[0]	ERROR	com.servoy.j2db.util.Debug	Throwable
java.sql.SQLException: Cannot convert value '0000-00-00' from column 12 to TIMESTAMP. 
    	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1055) 
    	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956) 
    	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:926) 
    	at com.mysql.jdbc.ResultSetRow.getTimestampFast(ResultSetRow.java:1321) 
    	at com.mysql.jdbc.BufferRow.getTimestampFast(BufferRow.java:573) 
    	at com.mysql.jdbc.ResultSetImpl.getTimestampInternal(ResultSetImpl.java:6617) 
    	at com.mysql.jdbc.ResultSetImpl.getTimestamp(ResultSetImpl.java:5943) 
    	at org.apache.commons.dbcp.DelegatingResultSet.getTimestamp(DelegatingResultSet.java:150) 
    	at org.apache.commons.dbcp.DelegatingResultSet.getTimestamp(DelegatingResultSet.java:150) 
    	at org.apache.commons.dbcp.DelegatingResultSet.getTimestamp(DelegatingResultSet.java:150) 
    	at com.servoy.j2db.dataprocessing.BufferedDataSet.<init>(Unknown Source) 
    	at com.servoy.j2db.dataprocessing.SQLEngine.a(Unknown Source) 
    	at com.servoy.j2db.dataprocessing.SQLEngine.a(Unknown Source) 
    	at com.servoy.j2db.dataprocessing.SQLEngine.performQuery(Unknown Source) 
    	at com.servoy.j2db.dataprocessing.RowManager.a(Unknown Source) 
    	at com.servoy.j2db.dataprocessing.FoundSet.int(Unknown Source) 
    	at com.servoy.j2db.dataprocessing.FoundSet.for(Unknown Source) 
    	at com.servoy.j2db.dataprocessing.FoundSet.getRecord(Unknown Source) 
    	at com.servoy.j2db.dataprocessing.JSDatabaseManager.js_recalculate(Unknown Source) 
    	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) 
    	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) 
    	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) 
    	at java.lang.reflect.Method.invoke(Method.java:585) 
    	at org.mozilla.javascript.NativeJavaMethod.call(NativeJavaMethod.java:334) 
    	at org.mozilla.javascript.ScriptRuntime.call(ScriptRuntime.java:1254) 
    	at org.mozilla.javascript.gen.c2683.call(update_calculations:4) 
    	at org.mozilla.javascript.ScriptRuntime.call(ScriptRuntime.java:1254) 
    	at org.mozilla.javascript.gen.c4.call(batch1:11) 
    	at com.servoy.j2db.scripting.f.executeFunction(Unknown Source) 
    	at com.servoy.j2db.plugins.ClientPluginAccessProvider$a.run(Unknown Source) 
    	at com.servoy.j2db.server.headlessclient.h.invokeLater(Unknown Source) 
    	at com.servoy.j2db.plugins.ClientPluginAccessProvider$1.run(Unknown Source) 
    	at com.servoy.j2db.util.as.run(Unknown Source) 
    	at java.lang.Thread.run(Thread.java:613) 
    Caused by: java.sql.SQLException: Value '[B@48b28f' can not be represented as java.sql.Timestamp 
    	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1055) 
    	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956) 
    	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:926) 
    	at com.mysql.jdbc.ResultSetRow.getTimestampFast(ResultSetRow.java:1027) 
    	... 30 more

2009-08-25 01:06	TaskExecuter[0]	ERROR	com.servoy.j2db.util.Debug	Throwable
java.sql.SQLException: Cannot convert value '0000-00-00 00:00:00' from column 151 to TIMESTAMP. 
    	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1055) 
    	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956) 
    	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:926) 
    	at com.mysql.jdbc.ResultSetRow.getTimestampFast(ResultSetRow.java:1321) 
    	at com.mysql.jdbc.BufferRow.getTimestampFast(BufferRow.java:573) 
    	at com.mysql.jdbc.ResultSetImpl.getTimestampInternal(ResultSetImpl.java:6617) 
    	at com.mysql.jdbc.ResultSetImpl.getTimestamp(ResultSetImpl.java:5943) 
    	at org.apache.commons.dbcp.DelegatingResultSet.getTimestamp(DelegatingResultSet.java:150) 
    	at org.apache.commons.dbcp.DelegatingResultSet.getTimestamp(DelegatingResultSet.java:150) 
    	at org.apache.commons.dbcp.DelegatingResultSet.getTimestamp(DelegatingResultSet.java:150) 
    	at com.servoy.j2db.dataprocessing.BufferedDataSet.<init>(Unknown Source) 
    	at com.servoy.j2db.dataprocessing.SQLEngine.a(Unknown Source) 
    	at com.servoy.j2db.dataprocessing.SQLEngine.a(Unknown Source) 
    	at com.servoy.j2db.dataprocessing.SQLEngine.performQuery(Unknown Source) 
    	at com.servoy.j2db.dataprocessing.SQLEngine.performQuery(Unknown Source) 
    	at com.servoy.j2db.dataprocessing.RelatedFoundSet.createRelatedFoundSets(Unknown Source) 
    	at com.servoy.j2db.dataprocessing.FoundSetManager.a(Unknown Source) 
    	at com.servoy.j2db.dataprocessing.FoundSet.getRelatedFoundSet(Unknown Source) 
    	at com.servoy.j2db.dataprocessing.Record.getRelatedFoundSet(Unknown Source) 
    	at com.servoy.j2db.dataprocessing.Record.getValue(Unknown Source) 
    	at com.servoy.j2db.dataprocessing.Record.get(Unknown Source) 
    	at org.mozilla.javascript.ScriptRuntime.name(ScriptRuntime.java:1107) 
    	at org.mozilla.javascript.gen.c2681.call(mlr_appointment_conf:4) 
    	at com.servoy.j2db.scripting.f.executeFunction(Unknown Source) 
    	at com.servoy.j2db.scripting.k.get(Unknown Source) 
    	at com.servoy.j2db.dataprocessing.FoundSet.getCalculationValue(Unknown Source) 
    	at com.servoy.j2db.dataprocessing.Record.getValue(Unknown Source) 
    	at com.servoy.j2db.dataprocessing.Record.a(Unknown Source) 
    	at com.servoy.j2db.dataprocessing.JSDatabaseManager.a(Unknown Source) 
    	at com.servoy.j2db.dataprocessing.JSDatabaseManager.js_recalculate(Unknown Source) 
    	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) 
    	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) 
    	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) 
    	at java.lang.reflect.Method.invoke(Method.java:585) 
    	at org.mozilla.javascript.NativeJavaMethod.call(NativeJavaMethod.java:334) 
    	at org.mozilla.javascript.ScriptRuntime.call(ScriptRuntime.java:1254) 
    	at org.mozilla.javascript.gen.c2683.call(update_calculations:4) 
    	at org.mozilla.javascript.ScriptRuntime.call(ScriptRuntime.java:1254) 
    	at org.mozilla.javascript.gen.c4.call(batch1:11) 
    	at com.servoy.j2db.scripting.f.executeFunction(Unknown Source) 
    	at com.servoy.j2db.plugins.ClientPluginAccessProvider$a.run(Unknown Source) 
    	at com.servoy.j2db.server.headlessclient.h.invokeLater(Unknown Source) 
    	at com.servoy.j2db.plugins.ClientPluginAccessProvider$1.run(Unknown Source) 
    	at com.servoy.j2db.util.as.run(Unknown Source) 
    	at java.lang.Thread.run(Thread.java:613) 
    Caused by: java.sql.SQLException: Value '[B@882fb5' can not be represented as java.sql.Timestamp 
    	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1055) 
    	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956) 
    	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:926) 
    	at com.mysql.jdbc.ResultSetRow.getTimestampFast(ResultSetRow.java:1027) 
    	... 41 more
2009-08-25 01:06	TaskExecuter[0]	ERROR	com.servoy.j2db.util.Debug	Throwable
java.sql.SQLException: Cannot convert value '0000-00-00 00:00:00' from column 151 to TIMESTAMP. 
    	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1055) 
    	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956) 
    	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:926) 
    	at com.mysql.jdbc.ResultSetRow.getTimestampFast(ResultSetRow.java:1321) 
    	at com.mysql.jdbc.BufferRow.getTimestampFast(BufferRow.java:573) 
    	at com.mysql.jdbc.ResultSetImpl.getTimestampInternal(ResultSetImpl.java:6617) 
    	at com.mysql.jdbc.ResultSetImpl.getTimestamp(ResultSetImpl.java:5943) 
    	at org.apache.commons.dbcp.DelegatingResultSet.getTimestamp(DelegatingResultSet.java:150) 
    	at org.apache.commons.dbcp.DelegatingResultSet.getTimestamp(DelegatingResultSet.java:150) 
    	at org.apache.commons.dbcp.DelegatingResultSet.getTimestamp(DelegatingResultSet.java:150) 
    	at com.servoy.j2db.dataprocessing.BufferedDataSet.<init>(Unknown Source) 
    	at com.servoy.j2db.dataprocessing.SQLEngine.a(Unknown Source) 
    	at com.servoy.j2db.dataprocessing.SQLEngine.a(Unknown Source) 
    	at com.servoy.j2db.dataprocessing.SQLEngine.performQuery(Unknown Source) 
    	at com.servoy.j2db.dataprocessing.SQLEngine.performQuery(Unknown Source) 
    	at com.servoy.j2db.dataprocessing.RelatedFoundSet.createRelatedFoundSets(Unknown Source) 
    	at com.servoy.j2db.dataprocessing.FoundSetManager.a(Unknown Source) 
    	at com.servoy.j2db.dataprocessing.FoundSet.getRelatedFoundSet(Unknown Source) 
    	at com.servoy.j2db.dataprocessing.Record.getRelatedFoundSet(Unknown Source) 
    	at com.servoy.j2db.dataprocessing.Record.getValue(Unknown Source) 
    	at com.servoy.j2db.dataprocessing.Record.get(Unknown Source) 
    	at org.mozilla.javascript.ScriptRuntime.name(ScriptRuntime.java:1107) 
    	at org.mozilla.javascript.gen.c2681.call(mlr_appointment_conf:4) 
    	at com.servoy.j2db.scripting.f.executeFunction(Unknown Source) 
    	at com.servoy.j2db.scripting.k.get(Unknown Source) 
    	at com.servoy.j2db.dataprocessing.FoundSet.getCalculationValue(Unknown Source) 
    	at com.servoy.j2db.dataprocessing.Record.getValue(Unknown Source) 
    	at com.servoy.j2db.dataprocessing.Record.a(Unknown Source) 
    	at com.servoy.j2db.dataprocessing.JSDatabaseManager.a(Unknown Source) 
    	at com.servoy.j2db.dataprocessing.JSDatabaseManager.js_recalculate(Unknown Source) 
    	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) 
    	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) 
    	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) 
    	at java.lang.reflect.Method.invoke(Method.java:585) 
    	at org.mozilla.javascript.NativeJavaMethod.call(NativeJavaMethod.java:334) 
    	at org.mozilla.javascript.ScriptRuntime.call(ScriptRuntime.java:1254) 
    	at org.mozilla.javascript.gen.c2683.call(update_calculations:4) 
    	at org.mozilla.javascript.ScriptRuntime.call(ScriptRuntime.java:1254) 
    	at org.mozilla.javascript.gen.c4.call(batch1:11) 
    	at com.servoy.j2db.scripting.f.executeFunction(Unknown Source) 
    	at com.servoy.j2db.plugins.ClientPluginAccessProvider$a.run(Unknown Source) 
    	at com.servoy.j2db.server.headlessclient.h.invokeLater(Unknown Source) 
    	at com.servoy.j2db.plugins.ClientPluginAccessProvider$1.run(Unknown Source) 
    	at com.servoy.j2db.util.as.run(Unknown Source) 
    	at java.lang.Thread.run(Thread.java:613) 
    Caused by: java.sql.SQLException: Value '[B@b3f4bb' can not be represented as java.sql.Timestamp 
    	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1055) 
    	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956) 
    	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:926) 
    	at com.mysql.jdbc.ResultSetRow.getTimestampFast(ResultSetRow.java:1027) 
    	... 41 more
2009-08-25 01:06	TaskExecuter[0]	ERROR	com.servoy.j2db.util.Debug	Throwable
java.sql.SQLException: Cannot convert value '0000-00-00 00:00:00' from column 151 to TIMESTAMP. 
    	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1055) 
    	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956) 
    	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:926) 
    	at com.mysql.jdbc.ResultSetRow.getTimestampFast(ResultSetRow.java:1321) 
    	at com.mysql.jdbc.BufferRow.getTimestampFast(BufferRow.java:573) 
    	at com.mysql.jdbc.ResultSetImpl.getTimestampInternal(ResultSetImpl.java:6617) 
    	at com.mysql.jdbc.ResultSetImpl.getTimestamp(ResultSetImpl.java:5943) 
    	at org.apache.commons.dbcp.DelegatingResultSet.getTimestamp(DelegatingResultSet.java:150) 
    	at org.apache.commons.dbcp.DelegatingResultSet.getTimestamp(DelegatingResultSet.java:150) 
    	at org.apache.commons.dbcp.DelegatingResultSet.getTimestamp(DelegatingResultSet.java:150) 
    	at com.servoy.j2db.dataprocessing.BufferedDataSet.<init>(Unknown Source) 
    	at com.servoy.j2db.dataprocessing.SQLEngine.a(Unknown Source) 
    	at com.servoy.j2db.dataprocessing.SQLEngine.a(Unknown Source) 
    	at com.servoy.j2db.dataprocessing.SQLEngine.performQuery(Unknown Source) 
    	at com.servoy.j2db.dataprocessing.SQLEngine.performQuery(Unknown Source) 
    	at com.servoy.j2db.dataprocessing.RelatedFoundSet.createRelatedFoundSets(Unknown Source) 
    	at com.servoy.j2db.dataprocessing.FoundSetManager.a(Unknown Source) 
    	at com.servoy.j2db.dataprocessing.FoundSet.getRelatedFoundSet(Unknown Source) 
    	at com.servoy.j2db.dataprocessing.Record.getRelatedFoundSet(Unknown Source) 
    	at com.servoy.j2db.dataprocessing.Record.getValue(Unknown Source) 
    	at com.servoy.j2db.dataprocessing.Record.get(Unknown Source) 
    	at org.mozilla.javascript.ScriptRuntime.name(ScriptRuntime.java:1107) 
    	at org.mozilla.javascript.gen.c2681.call(mlr_appointment_conf:4) 
    	at com.servoy.j2db.scripting.f.executeFunction(Unknown Source) 
    	at com.servoy.j2db.scripting.k.get(Unknown Source) 
    	at com.servoy.j2db.dataprocessing.FoundSet.getCalculationValue(Unknown Source) 
    	at com.servoy.j2db.dataprocessing.Record.getValue(Unknown Source) 
    	at com.servoy.j2db.dataprocessing.Record.a(Unknown Source) 
    	at com.servoy.j2db.dataprocessing.JSDatabaseManager.a(Unknown Source) 
    	at com.servoy.j2db.dataprocessing.JSDatabaseManager.js_recalculate(Unknown Source) 
    	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) 
    	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) 
    	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) 
    	at java.lang.reflect.Method.invoke(Method.java:585) 
    	at org.mozilla.javascript.NativeJavaMethod.call(NativeJavaMethod.java:334) 
    	at org.mozilla.javascript.ScriptRuntime.call(ScriptRuntime.java:1254) 
    	at org.mozilla.javascript.gen.c2683.call(update_calculations:4) 
    	at org.mozilla.javascript.ScriptRuntime.call(ScriptRuntime.java:1254) 
    	at org.mozilla.javascript.gen.c4.call(batch1:11) 
    	at com.servoy.j2db.scripting.f.executeFunction(Unknown Source) 
    	at com.servoy.j2db.plugins.ClientPluginAccessProvider$a.run(Unknown Source) 
    	at com.servoy.j2db.server.headlessclient.h.invokeLater(Unknown Source) 
    	at com.servoy.j2db.plugins.ClientPluginAccessProvider$1.run(Unknown Source) 
    	at com.servoy.j2db.util.as.run(Unknown Source) 
    	at java.lang.Thread.run(Thread.java:613) 
    Caused by: java.sql.SQLException: Value '[B@58b105' can not be represented as java.sql.Timestamp 
    	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1055) 
    	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956) 
    	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:926) 
    	at com.mysql.jdbc.ResultSetRow.getTimestampFast(ResultSetRow.java:1027) 
    	... 41 more
2009-08-25 01:06	TaskExecuter[0]	ERROR	com.servoy.j2db.util.Debug	Throwable
java.sql.SQLException: Cannot convert value '0000-00-00 00:00:00' from column 151 to TIMESTAMP. 
    	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1055) 
    	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956) 
    	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:926) 
    	at com.mysql.jdbc.ResultSetRow.getTimestampFast(ResultSetRow.java:1321) 
    	at com.mysql.jdbc.BufferRow.getTimestampFast(BufferRow.java:573) 
    	at com.mysql.jdbc.ResultSetImpl.getTimestampInternal(ResultSetImpl.java:6617) 
    	at com.mysql.jdbc.ResultSetImpl.getTimestamp(ResultSetImpl.java:5943) 
    	at org.apache.commons.dbcp.DelegatingResultSet.getTimestamp(DelegatingResultSet.java:150) 
    	at org.apache.commons.dbcp.DelegatingResultSet.getTimestamp(DelegatingResultSet.java:150) 
    	at org.apache.commons.dbcp.DelegatingResultSet.getTimestamp(DelegatingResultSet.java:150) 
    	at com.servoy.j2db.dataprocessing.BufferedDataSet.<init>(Unknown Source) 
    	at com.servoy.j2db.dataprocessing.SQLEngine.a(Unknown Source) 
    	at com.servoy.j2db.dataprocessing.SQLEngine.a(Unknown Source) 
    	at com.servoy.j2db.dataprocessing.SQLEngine.performQuery(Unknown Source) 
    	at com.servoy.j2db.dataprocessing.SQLEngine.performQuery(Unknown Source) 
    	at com.servoy.j2db.dataprocessing.RelatedFoundSet.createRelatedFoundSets(Unknown Source) 
    	at com.servoy.j2db.dataprocessing.FoundSetManager.a(Unknown Source) 
    	at com.servoy.j2db.dataprocessing.FoundSet.getRelatedFoundSet(Unknown Source) 
    	at com.servoy.j2db.dataprocessing.Record.getRelatedFoundSet(Unknown Source) 
    	at com.servoy.j2db.dataprocessing.Record.getValue(Unknown Source) 
    	at com.servoy.j2db.dataprocessing.Record.get(Unknown Source) 
    	at org.mozilla.javascript.ScriptRuntime.name(ScriptRuntime.java:1107) 
    	at org.mozilla.javascript.gen.c2681.call(mlr_appointment_conf:4) 
    	at com.servoy.j2db.scripting.f.executeFunction(Unknown Source) 
    	at com.servoy.j2db.scripting.k.get(Unknown Source) 
    	at com.servoy.j2db.dataprocessing.FoundSet.getCalculationValue(Unknown Source) 
    	at com.servoy.j2db.dataprocessing.Record.getValue(Unknown Source) 
    	at com.servoy.j2db.dataprocessing.Record.a(Unknown Source) 
    	at com.servoy.j2db.dataprocessing.JSDatabaseManager.a(Unknown Source) 
    	at com.servoy.j2db.dataprocessing.JSDatabaseManager.js_recalculate(Unknown Source) 
    	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) 
    	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) 
    	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) 
    	at java.lang.reflect.Method.invoke(Method.java:585) 
    	at org.mozilla.javascript.NativeJavaMethod.call(NativeJavaMethod.java:334) 
    	at org.mozilla.javascript.ScriptRuntime.call(ScriptRuntime.java:1254) 
    	at org.mozilla.javascript.gen.c2683.call(update_calculations:4) 
    	at org.mozilla.javascript.ScriptRuntime.call(ScriptRuntime.java:1254) 
    	at org.mozilla.javascript.gen.c4.call(batch1:11) 
    	at com.servoy.j2db.scripting.f.executeFunction(Unknown Source) 
    	at com.servoy.j2db.plugins.ClientPluginAccessProvider$a.run(Unknown Source) 
    	at com.servoy.j2db.server.headlessclient.h.invokeLater(Unknown Source) 
    	at com.servoy.j2db.plugins.ClientPluginAccessProvider$1.run(Unknown Source) 
    	at com.servoy.j2db.util.as.run(Unknown Source) 
    	at java.lang.Thread.run(Thread.java:613) 
    Caused by: java.sql.SQLException: Value '[B@9edddd' can not be represented as java.sql.Timestamp 
    	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1055) 
    	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956) 
    	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:926) 
    	at com.mysql.jdbc.ResultSetRow.getTimestampFast(ResultSetRow.java:1027) 
    	... 41 more
2009-08-25 01:06	TaskExecuter[0]	ERROR	com.servoy.j2db.util.Debug	Throwable
java.sql.SQLException: Cannot convert value '0000-00-00 00:00:00' from column 151 to TIMESTAMP. 
    	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1055) 
    	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956) 
    	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:926) 
    	at com.mysql.jdbc.ResultSetRow.getTimestampFast(ResultSetRow.java:1321) 
    	at com.mysql.jdbc.BufferRow.getTimestampFast(BufferRow.java:573) 
    	at com.mysql.jdbc.ResultSetImpl.getTimestampInternal(ResultSetImpl.java:6617) 
    	at com.mysql.jdbc.ResultSetImpl.getTimestamp(ResultSetImpl.java:5943) 
    	at org.apache.commons.dbcp.DelegatingResultSet.getTimestamp(DelegatingResultSet.java:150) 
    	at org.apache.commons.dbcp.DelegatingResultSet.getTimestamp(DelegatingResultSet.java:150) 
    	at org.apache.commons.dbcp.DelegatingResultSet.getTimestamp(DelegatingResultSet.java:150) 
    	at com.servoy.j2db.dataprocessing.BufferedDataSet.<init>(Unknown Source) 
    	at com.servoy.j2db.dataprocessing.SQLEngine.a(Unknown Source) 
    	at com.servoy.j2db.dataprocessing.SQLEngine.a(Unknown Source) 
    	at com.servoy.j2db.dataprocessing.SQLEngine.performQuery(Unknown Source) 
    	at com.servoy.j2db.dataprocessing.SQLEngine.performQuery(Unknown Source) 
    	at com.servoy.j2db.dataprocessing.RelatedFoundSet.createRelatedFoundSets(Unknown Source) 
    	at com.servoy.j2db.dataprocessing.FoundSetManager.a(Unknown Source) 
    	at com.servoy.j2db.dataprocessing.FoundSet.getRelatedFoundSet(Unknown Source) 
    	at com.servoy.j2db.dataprocessing.Record.getRelatedFoundSet(Unknown Source) 
    	at com.servoy.j2db.dataprocessing.Record.getValue(Unknown Source) 
    	at com.servoy.j2db.dataprocessing.Record.get(Unknown Source) 
    	at org.mozilla.javascript.ScriptRuntime.name(ScriptRuntime.java:1107) 
    	at org.mozilla.javascript.gen.c2681.call(mlr_appointment_conf:4) 
    	at com.servoy.j2db.scripting.f.executeFunction(Unknown Source) 
    	at com.servoy.j2db.scripting.k.get(Unknown Source) 
    	at com.servoy.j2db.dataprocessing.FoundSet.getCalculationValue(Unknown Source) 
    	at com.servoy.j2db.dataprocessing.Record.getValue(Unknown Source) 
    	at com.servoy.j2db.dataprocessing.Record.a(Unknown Source) 
    	at com.servoy.j2db.dataprocessing.JSDatabaseManager.a(Unknown Source) 
    	at com.servoy.j2db.dataprocessing.JSDatabaseManager.js_recalculate(Unknown Source) 
    	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) 
    	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) 
    	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) 
    	at java.lang.reflect.Method.invoke(Method.java:585) 
    	at org.mozilla.javascript.NativeJavaMethod.call(NativeJavaMethod.java:334) 
    	at org.mozilla.javascript.ScriptRuntime.call(ScriptRuntime.java:1254) 
    	at org.mozilla.javascript.gen.c2683.call(update_calculations:4) 
    	at org.mozilla.javascript.ScriptRuntime.call(ScriptRuntime.java:1254) 
    	at org.mozilla.javascript.gen.c4.call(batch1:11) 
    	at com.servoy.j2db.scripting.f.executeFunction(Unknown Source) 
    	at com.servoy.j2db.plugins.ClientPluginAccessProvider$a.run(Unknown Source) 
    	at com.servoy.j2db.server.headlessclient.h.invokeLater(Unknown Source) 
    	at com.servoy.j2db.plugins.ClientPluginAccessProvider$1.run(Unknown Source) 
    	at com.servoy.j2db.util.as.run(Unknown Source) 
    	at java.lang.Thread.run(Thread.java:613) 
    Caused by: java.sql.SQLException: Value '[B@9d5b35' can not be represented as java.sql.Timestamp 
    	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1055) 
    	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956) 
    	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:926) 
    	at com.mysql.jdbc.ResultSetRow.getTimestampFast(ResultSetRow.java:1027) 
    	... 41 more
2009-08-25 01:06	TaskExecuter[0]	ERROR	com.servoy.j2db.util.Debug	Throwable
java.sql.SQLException: Cannot convert value '0000-00-00 00:00:00' from column 151 to TIMESTAMP. 
    	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1055) 
    	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956) 
    	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:926) 
    	at com.mysql.jdbc.ResultSetRow.getTimestampFast(ResultSetRow.java:1321) 
    	at com.mysql.jdbc.BufferRow.getTimestampFast(BufferRow.java:573) 
    	at com.mysql.jdbc.ResultSetImpl.getTimestampInternal(ResultSetImpl.java:6617) 
    	at com.mysql.jdbc.ResultSetImpl.getTimestamp(ResultSetImpl.java:5943) 
    	at org.apache.commons.dbcp.DelegatingResultSet.getTimestamp(DelegatingResultSet.java:150) 
    	at org.apache.commons.dbcp.DelegatingResultSet.getTimestamp(DelegatingResultSet.java:150) 
    	at org.apache.commons.dbcp.DelegatingResultSet.getTimestamp(DelegatingResultSet.java:150) 
    	at com.servoy.j2db.dataprocessing.BufferedDataSet.<init>(Unknown Source) 
    	at com.servoy.j2db.dataprocessing.SQLEngine.a(Unknown Source) 
    	at com.servoy.j2db.dataprocessing.SQLEngine.a(Unknown Source) 
    	at com.servoy.j2db.dataprocessing.SQLEngine.performQuery(Unknown Source) 
    	at com.servoy.j2db.dataprocessing.SQLEngine.performQuery(Unknown Source) 
    	at com.servoy.j2db.dataprocessing.RelatedFoundSet.createRelatedFoundSets(Unknown Source) 
    	at com.servoy.j2db.dataprocessing.FoundSetManager.a(Unknown Source) 
    	at com.servoy.j2db.dataprocessing.FoundSet.getRelatedFoundSet(Unknown Source) 
    	at com.servoy.j2db.dataprocessing.Record.getRelatedFoundSet(Unknown Source) 
    	at com.servoy.j2db.dataprocessing.Record.getValue(Unknown Source) 
    	at com.servoy.j2db.dataprocessing.Record.get(Unknown Source) 
    	at org.mozilla.javascript.ScriptRuntime.name(ScriptRuntime.java:1107) 
    	at org.mozilla.javascript.gen.c2681.call(mlr_appointment_conf:4) 
    	at com.servoy.j2db.scripting.f.executeFunction(Unknown Source) 
    	at com.servoy.j2db.scripting.k.get(Unknown Source) 
    	at com.servoy.j2db.dataprocessing.FoundSet.getCalculationValue(Unknown Source) 
    	at com.servoy.j2db.dataprocessing.Record.getValue(Unknown Source) 
    	at com.servoy.j2db.dataprocessing.Record.a(Unknown Source) 
    	at com.servoy.j2db.dataprocessing.JSDatabaseManager.a(Unknown Source) 
    	at com.servoy.j2db.dataprocessing.JSDatabaseManager.js_recalculate(Unknown Source) 
    	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) 
    	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) 
    	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) 
    	at java.lang.reflect.Method.invoke(Method.java:585) 
    	at org.mozilla.javascript.NativeJavaMethod.call(NativeJavaMethod.java:334) 
    	at org.mozilla.javascript.ScriptRuntime.call(ScriptRuntime.java:1254) 
    	at org.mozilla.javascript.gen.c2683.call(update_calculations:4) 
    	at org.mozilla.javascript.ScriptRuntime.call(ScriptRuntime.java:1254) 
    	at org.mozilla.javascript.gen.c4.call(batch1:11) 
    	at com.servoy.j2db.scripting.f.executeFunction(Unknown Source) 
    	at com.servoy.j2db.plugins.ClientPluginAccessProvider$a.run(Unknown Source) 
    	at com.servoy.j2db.server.headlessclient.h.invokeLater(Unknown Source) 
    	at com.servoy.j2db.plugins.ClientPluginAccessProvider$1.run(Unknown Source) 
    	at com.servoy.j2db.util.as.run(Unknown Source) 
    	at java.lang.Thread.run(Thread.java:613) 
    Caused by: java.sql.SQLException: Value '[B@849839' can not be represented as java.sql.Timestamp 
    	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1055) 
    	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956) 
    	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:926) 
    	at com.mysql.jdbc.ResultSetRow.getTimestampFast(ResultSetRow.java:1027) 
    	... 41 more
2009-08-25 01:06	TaskExecuter[0]	ERROR	com.servoy.j2db.util.Debug	Throwable
java.sql.SQLException: Cannot convert value '0000-00-00 00:00:00' from column 151 to TIMESTAMP. 
    	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1055) 
    	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956) 
    	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:926) 
    	at com.mysql.jdbc.ResultSetRow.getTimestampFast(ResultSetRow.java:1321) 
    	at com.mysql.jdbc.BufferRow.getTimestampFast(BufferRow.java:573) 
    	at com.mysql.jdbc.ResultSetImpl.getTimestampInternal(ResultSetImpl.java:6617) 
    	at com.mysql.jdbc.ResultSetImpl.getTimestamp(ResultSetImpl.java:5943) 
    	at org.apache.commons.dbcp.DelegatingResultSet.getTimestamp(DelegatingResultSet.java:150) 
    	at org.apache.commons.dbcp.DelegatingResultSet.getTimestamp(DelegatingResultSet.java:150) 
    	at org.apache.commons.dbcp.DelegatingResultSet.getTimestamp(DelegatingResultSet.java:150) 
    	at com.servoy.j2db.dataprocessing.BufferedDataSet.<init>(Unknown Source) 
    	at com.servoy.j2db.dataprocessing.SQLEngine.a(Unknown Source) 
    	at com.servoy.j2db.dataprocessing.SQLEngine.a(Unknown Source) 
    	at com.servoy.j2db.dataprocessing.SQLEngine.performQuery(Unknown Source) 
    	at com.servoy.j2db.dataprocessing.SQLEngine.performQuery(Unknown Source) 
    	at com.servoy.j2db.dataprocessing.RelatedFoundSet.createRelatedFoundSets(Unknown Source) 
    	at com.servoy.j2db.dataprocessing.FoundSetManager.a(Unknown Source) 
    	at com.servoy.j2db.dataprocessing.FoundSet.getRelatedFoundSet(Unknown Source) 
    	at com.servoy.j2db.dataprocessing.Record.getRelatedFoundSet(Unknown Source) 
    	at com.servoy.j2db.dataprocessing.Record.getValue(Unknown Source) 
    	at com.servoy.j2db.dataprocessing.Record.get(Unknown Source) 
    	at org.mozilla.javascript.ScriptRuntime.name(ScriptRuntime.java:1107) 
    	at org.mozilla.javascript.gen.c2681.call(mlr_appointment_conf:4) 
    	at com.servoy.j2db.scripting.f.executeFunction(Unknown Source) 
    	at com.servoy.j2db.scripting.k.get(Unknown Source) 
    	at com.servoy.j2db.dataprocessing.FoundSet.getCalculationValue(Unknown Source) 
    	at com.servoy.j2db.dataprocessing.Record.getValue(Unknown Source) 
    	at com.servoy.j2db.dataprocessing.Record.a(Unknown Source) 
    	at com.servoy.j2db.dataprocessing.JSDatabaseManager.a(Unknown Source) 
    	at com.servoy.j2db.dataprocessing.JSDatabaseManager.js_recalculate(Unknown Source) 
    	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) 
    	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) 
    	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) 
    	at java.lang.reflect.Method.invoke(Method.java:585) 
    	at org.mozilla.javascript.NativeJavaMethod.call(NativeJavaMethod.java:334) 
    	at org.mozilla.javascript.ScriptRuntime.call(ScriptRuntime.java:1254) 
    	at org.mozilla.javascript.gen.c2683.call(update_calculations:4) 
    	at org.mozilla.javascript.ScriptRuntime.call(ScriptRuntime.java:1254) 
    	at org.mozilla.javascript.gen.c4.call(batch1:11) 
    	at com.servoy.j2db.scripting.f.executeFunction(Unknown Source) 
    	at com.servoy.j2db.plugins.ClientPluginAccessProvider$a.run(Unknown Source) 
    	at com.servoy.j2db.server.headlessclient.h.invokeLater(Unknown Source) 
    	at com.servoy.j2db.plugins.ClientPluginAccessProvider$1.run(Unknown Source) 
    	at com.servoy.j2db.util.as.run(Unknown Source) 
    	at java.lang.Thread.run(Thread.java:613) 
    Caused by: java.sql.SQLException: Value '[B@dd961c' can not be represented as java.sql.Timestamp 
    	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1055) 
    	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956) 
    	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:926) 
    	at com.mysql.jdbc.ResultSetRow.getTimestampFast(ResultSetRow.java:1027) 
    	... 41 more
2009-08-25 01:06	TaskExecuter[0]	ERROR	com.servoy.j2db.util.Debug	Throwable
java.sql.SQLException: Cannot convert value '0000-00-00 00:00:00' from column 151 to TIMESTAMP. 
    	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1055) 
    	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956) 
    	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:926) 
    	at com.mysql.jdbc.ResultSetRow.getTimestampFast(ResultSetRow.java:1321) 
    	at com.mysql.jdbc.BufferRow.getTimestampFast(BufferRow.java:573) 
    	at com.mysql.jdbc.ResultSetImpl.getTimestampInternal(ResultSetImpl.java:6617) 
    	at com.mysql.jdbc.ResultSetImpl.getTimestamp(ResultSetImpl.java:5943) 
    	at org.apache.commons.dbcp.DelegatingResultSet.getTimestamp(DelegatingResultSet.java:150) 
    	at org.apache.commons.dbcp.DelegatingResultSet.getTimestamp(DelegatingResultSet.java:150) 
    	at org.apache.commons.dbcp.DelegatingResultSet.getTimestamp(DelegatingResultSet.java:150) 
    	at com.servoy.j2db.dataprocessing.BufferedDataSet.<init>(Unknown Source) 
    	at com.servoy.j2db.dataprocessing.SQLEngine.a(Unknown Source) 
    	at com.servoy.j2db.dataprocessing.SQLEngine.a(Unknown Source) 
    	at com.servoy.j2db.dataprocessing.SQLEngine.performQuery(Unknown Source) 
    	at com.servoy.j2db.dataprocessing.SQLEngine.performQuery(Unknown Source) 
    	at com.servoy.j2db.dataprocessing.RelatedFoundSet.createRelatedFoundSets(Unknown Source) 
    	at com.servoy.j2db.dataprocessing.FoundSetManager.a(Unknown Source) 
    	at com.servoy.j2db.dataprocessing.FoundSet.getRelatedFoundSet(Unknown Source) 
    	at com.servoy.j2db.dataprocessing.Record.getRelatedFoundSet(Unknown Source) 
    	at com.servoy.j2db.dataprocessing.Record.getValue(Unknown Source) 
    	at com.servoy.j2db.dataprocessing.Record.get(Unknown Source) 
    	at org.mozilla.javascript.ScriptRuntime.name(ScriptRuntime.java:1107) 
    	at org.mozilla.javascript.gen.c2681.call(mlr_appointment_conf:4) 
    	at com.servoy.j2db.scripting.f.executeFunction(Unknown Source) 
    	at com.servoy.j2db.scripting.k.get(Unknown Source) 
    	at com.servoy.j2db.dataprocessing.FoundSet.getCalculationValue(Unknown Source) 
    	at com.servoy.j2db.dataprocessing.Record.getValue(Unknown Source) 
    	at com.servoy.j2db.dataprocessing.Record.a(Unknown Source) 
    	at com.servoy.j2db.dataprocessing.JSDatabaseManager.a(Unknown Source) 
    	at com.servoy.j2db.dataprocessing.JSDatabaseManager.js_recalculate(Unknown Source) 
    	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) 
    	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) 
    	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) 
    	at java.lang.reflect.Method.invoke(Method.java:585) 
    	at org.mozilla.javascript.NativeJavaMethod.call(NativeJavaMethod.java:334) 
    	at org.mozilla.javascript.ScriptRuntime.call(ScriptRuntime.java:1254) 
    	at org.mozilla.javascript.gen.c2683.call(update_calculations:4) 
    	at org.mozilla.javascript.ScriptRuntime.call(ScriptRuntime.java:1254) 
    	at org.mozilla.javascript.gen.c4.call(batch1:11) 
    	at com.servoy.j2db.scripting.f.executeFunction(Unknown Source) 
    	at com.servoy.j2db.plugins.ClientPluginAccessProvider$a.run(Unknown Source) 
    	at com.servoy.j2db.server.headlessclient.h.invokeLater(Unknown Source) 
    	at com.servoy.j2db.plugins.ClientPluginAccessProvider$1.run(Unknown Source) 
    	at com.servoy.j2db.util.as.run(Unknown Source) 
    	at java.lang.Thread.run(Thread.java:613) 
    Caused by: java.sql.SQLException: Value '[B@6f83c3' can not be represented as java.sql.Timestamp 
    	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1055) 
    	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956) 
    	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:926) 
    	at com.mysql.jdbc.ResultSetRow.getTimestampFast(ResultSetRow.java:1027) 
    	... 41 more
2009-08-25 01:06	TaskExecuter[0]	ERROR	com.servoy.j2db.util.Debug	Throwable
java.sql.SQLException: Cannot convert value '0000-00-00 00:00:00' from column 151 to TIMESTAMP. 
    	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1055) 
    	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956) 
    	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:926) 
    	at com.mysql.jdbc.ResultSetRow.getTimestampFast(ResultSetRow.java:1321) 
    	at com.mysql.jdbc.BufferRow.getTimestampFast(BufferRow.java:573) 
    	at com.mysql.jdbc.ResultSetImpl.getTimestampInternal(ResultSetImpl.java:6617) 
    	at com.mysql.jdbc.ResultSetImpl.getTimestamp(ResultSetImpl.java:5943) 
    	at org.apache.commons.dbcp.DelegatingResultSet.getTimestamp(DelegatingResultSet.java:150) 
    	at org.apache.commons.dbcp.DelegatingResultSet.getTimestamp(DelegatingResultSet.java:150) 
    	at org.apache.commons.dbcp.DelegatingResultSet.getTimestamp(DelegatingResultSet.java:150) 
    	at com.servoy.j2db.dataprocessing.BufferedDataSet.<init>(Unknown Source) 
    	at com.servoy.j2db.dataprocessing.SQLEngine.a(Unknown Source) 
    	at com.servoy.j2db.dataprocessing.SQLEngine.a(Unknown Source) 
    	at com.servoy.j2db.dataprocessing.SQLEngine.performQuery(Unknown Source) 
    	at com.servoy.j2db.dataprocessing.SQLEngine.performQuery(Unknown Source) 
    	at com.servoy.j2db.dataprocessing.RelatedFoundSet.createRelatedFoundSets(Unknown Source) 
    	at com.servoy.j2db.dataprocessing.FoundSetManager.a(Unknown Source) 
    	at com.servoy.j2db.dataprocessing.FoundSet.getRelatedFoundSet(Unknown Source) 
    	at com.servoy.j2db.dataprocessing.Record.getRelatedFoundSet(Unknown Source) 
    	at com.servoy.j2db.dataprocessing.Record.getValue(Unknown Source) 
    	at com.servoy.j2db.dataprocessing.Record.get(Unknown Source) 
    	at org.mozilla.javascript.ScriptRuntime.name(ScriptRuntime.java:1107) 
    	at org.mozilla.javascript.gen.c2681.call(mlr_appointment_conf:4) 
    	at com.servoy.j2db.scripting.f.executeFunction(Unknown Source) 
    	at com.servoy.j2db.scripting.k.get(Unknown Source) 
    	at com.servoy.j2db.dataprocessing.FoundSet.getCalculationValue(Unknown Source) 
    	at com.servoy.j2db.dataprocessing.Record.getValue(Unknown Source) 
    	at com.servoy.j2db.dataprocessing.Record.a(Unknown Source) 
    	at com.servoy.j2db.dataprocessing.JSDatabaseManager.a(Unknown Source) 
    	at com.servoy.j2db.dataprocessing.JSDatabaseManager.js_recalculate(Unknown Source) 
    	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) 
    	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) 
    	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) 
    	at java.lang.reflect.Method.invoke(Method.java:585) 
    	at org.mozilla.javascript.NativeJavaMethod.call(NativeJavaMethod.java:334) 
    	at org.mozilla.javascript.ScriptRuntime.call(ScriptRuntime.java:1254) 
    	at org.mozilla.javascript.gen.c2683.call(update_calculations:4) 
    	at org.mozilla.javascript.ScriptRuntime.call(ScriptRuntime.java:1254) 
    	at org.mozilla.javascript.gen.c4.call(batch1:11) 
    	at com.servoy.j2db.scripting.f.executeFunction(Unknown Source) 
    	at com.servoy.j2db.plugins.ClientPluginAccessProvider$a.run(Unknown Source) 
    	at com.servoy.j2db.server.headlessclient.h.invokeLater(Unknown Source) 
    	at com.servoy.j2db.plugins.ClientPluginAccessProvider$1.run(Unknown Source) 
    	at com.servoy.j2db.util.as.run(Unknown Source) 
    	at java.lang.Thread.run(Thread.java:613) 
    Caused by: java.sql.SQLException: Value '[B@5ddd0' can not be represented as java.sql.Timestamp 
    	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1055) 
    	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956) 
    	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:926) 
    	at com.mysql.jdbc.ResultSetRow.getTimestampFast(ResultSetRow.java:1027) 
    	... 41 more
2009-08-25 01:06	TaskExecuter[0]	ERROR	com.servoy.j2db.util.Debug	Throwable
java.sql.SQLException: Cannot convert value '0000-00-00 00:00:00' from column 151 to TIMESTAMP. 
    	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1055) 
    	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956) 
    	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:926) 
    	at com.mysql.jdbc.ResultSetRow.getTimestampFast(ResultSetRow.java:1321) 
    	at com.mysql.jdbc.BufferRow.getTimestampFast(BufferRow.java:573) 
    	at com.mysql.jdbc.ResultSetImpl.getTimestampInternal(ResultSetImpl.java:6617) 
    	at com.mysql.jdbc.ResultSetImpl.getTimestamp(ResultSetImpl.java:5943) 
    	at org.apache.commons.dbcp.DelegatingResultSet.getTimestamp(DelegatingResultSet.java:150) 
    	at org.apache.commons.dbcp.DelegatingResultSet.getTimestamp(DelegatingResultSet.java:150) 
    	at org.apache.commons.dbcp.DelegatingResultSet.getTimestamp(DelegatingResultSet.java:150) 
    	at com.servoy.j2db.dataprocessing.BufferedDataSet.<init>(Unknown Source) 
    	at com.servoy.j2db.dataprocessing.SQLEngine.a(Unknown Source) 
    	at com.servoy.j2db.dataprocessing.SQLEngine.a(Unknown Source) 
    	at com.servoy.j2db.dataprocessing.SQLEngine.performQuery(Unknown Source) 
    	at com.servoy.j2db.dataprocessing.SQLEngine.performQuery(Unknown Source) 
    	at com.servoy.j2db.dataprocessing.RelatedFoundSet.createRelatedFoundSets(Unknown Source) 
    	at com.servoy.j2db.dataprocessing.FoundSetManager.a(Unknown Source) 
    	at com.servoy.j2db.dataprocessing.FoundSet.getRelatedFoundSet(Unknown Source) 
    	at com.servoy.j2db.dataprocessing.Record.getRelatedFoundSet(Unknown Source) 
    	at com.servoy.j2db.dataprocessing.Record.getValue(Unknown Source) 
    	at com.servoy.j2db.dataprocessing.Record.get(Unknown Source) 
    	at org.mozilla.javascript.ScriptRuntime.name(ScriptRuntime.java:1107) 
    	at org.mozilla.javascript.gen.c2681.call(mlr_appointment_conf:4) 
    	at com.servoy.j2db.scripting.f.executeFunction(Unknown Source) 
    	at com.servoy.j2db.scripting.k.get(Unknown Source) 
    	at com.servoy.j2db.dataprocessing.FoundSet.getCalculationValue(Unknown Source) 
    	at com.servoy.j2db.dataprocessing.Record.getValue(Unknown Source) 
    	at com.servoy.j2db.dataprocessing.Record.a(Unknown Source) 
    	at com.servoy.j2db.dataprocessing.JSDatabaseManager.a(Unknown Source) 
    	at com.servoy.j2db.dataprocessing.JSDatabaseManager.js_recalculate(Unknown Source) 
    	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) 
    	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) 
    	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) 
    	at java.lang.reflect.Method.invoke(Method.java:585) 
    	at org.mozilla.javascript.NativeJavaMethod.call(NativeJavaMethod.java:334) 
    	at org.mozilla.javascript.ScriptRuntime.call(ScriptRuntime.java:1254) 
    	at org.mozilla.javascript.gen.c2683.call(update_calculations:4) 
    	at org.mozilla.javascript.ScriptRuntime.call(ScriptRuntime.java:1254) 
    	at org.mozilla.javascript.gen.c4.call(batch1:11) 
    	at com.servoy.j2db.scripting.f.executeFunction(Unknown Source) 
    	at com.servoy.j2db.plugins.ClientPluginAccessProvider$a.run(Unknown Source) 
    	at com.servoy.j2db.server.headlessclient.h.invokeLater(Unknown Source) 
    	at com.servoy.j2db.plugins.ClientPluginAccessProvider$1.run(Unknown Source) 
    	at com.servoy.j2db.util.as.run(Unknown Source) 
    	at java.lang.Thread.run(Thread.java:613) 
    Caused by: java.sql.SQLException: Value '[B@629c70' can not be represented as java.sql.Timestamp 
    	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1055) 
    	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956) 
    	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:926) 
    	at com.mysql.jdbc.ResultSetRow.getTimestampFast(ResultSetRow.java:1027) 
    	... 41 more
2009-08-25 01:06	TaskExecuter[0]	ERROR	com.servoy.j2db.util.Debug	Throwable
java.sql.SQLException: Cannot convert value '0000-00-00 00:00:00' from column 151 to TIMESTAMP. 
    	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1055) 
    	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956) 
    	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:926) 
    	at com.mysql.jdbc.ResultSetRow.getTimestampFast(ResultSetRow.java:1321) 
    	at com.mysql.jdbc.BufferRow.getTimestampFast(BufferRow.java:573) 
    	at com.mysql.jdbc.ResultSetImpl.getTimestampInternal(ResultSetImpl.java:6617) 
    	at com.mysql.jdbc.ResultSetImpl.getTimestamp(ResultSetImpl.java:5943) 
    	at org.apache.commons.dbcp.DelegatingResultSet.getTimestamp(DelegatingResultSet.java:150) 
    	at org.apache.commons.dbcp.DelegatingResultSet.getTimestamp(DelegatingResultSet.java:150) 
    	at org.apache.commons.dbcp.DelegatingResultSet.getTimestamp(DelegatingResultSet.java:150) 
    	at com.servoy.j2db.dataprocessing.BufferedDataSet.<init>(Unknown Source) 
    	at com.servoy.j2db.dataprocessing.SQLEngine.a(Unknown Source) 
    	at com.servoy.j2db.dataprocessing.SQLEngine.a(Unknown Source) 
    	at com.servoy.j2db.dataprocessing.SQLEngine.performQuery(Unknown Source) 
    	at com.servoy.j2db.dataprocessing.SQLEngine.performQuery(Unknown Source) 
    	at com.servoy.j2db.dataprocessing.RelatedFoundSet.createRelatedFoundSets(Unknown Source) 
    	at com.servoy.j2db.dataprocessing.FoundSetManager.a(Unknown Source) 
    	at com.servoy.j2db.dataprocessing.FoundSet.getRelatedFoundSet(Unknown Source) 
    	at com.servoy.j2db.dataprocessing.Record.getRelatedFoundSet(Unknown Source) 
    	at com.servoy.j2db.dataprocessing.Record.getValue(Unknown Source) 
    	at com.servoy.j2db.dataprocessing.Record.get(Unknown Source) 
    	at org.mozilla.javascript.ScriptRuntime.name(ScriptRuntime.java:1107) 
    	at org.mozilla.javascript.gen.c2681.call(mlr_appointment_conf:4) 
    	at com.servoy.j2db.scripting.f.executeFunction(Unknown Source) 
    	at com.servoy.j2db.scripting.k.get(Unknown Source) 
    	at com.servoy.j2db.dataprocessing.FoundSet.getCalculationValue(Unknown Source) 
    	at com.servoy.j2db.dataprocessing.Record.getValue(Unknown Source) 
    	at com.servoy.j2db.dataprocessing.Record.a(Unknown Source) 
    	at com.servoy.j2db.dataprocessing.JSDatabaseManager.a(Unknown Source) 
    	at com.servoy.j2db.dataprocessing.JSDatabaseManager.js_recalculate(Unknown Source) 
    	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) 
    	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) 
    	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) 
    	at java.lang.reflect.Method.invoke(Method.java:585) 
    	at org.mozilla.javascript.NativeJavaMethod.call(NativeJavaMethod.java:334) 
    	at org.mozilla.javascript.ScriptRuntime.call(ScriptRuntime.java:1254) 
    	at org.mozilla.javascript.gen.c2683.call(update_calculations:4) 
    	at org.mozilla.javascript.ScriptRuntime.call(ScriptRuntime.java:1254) 
    	at org.mozilla.javascript.gen.c4.call(batch1:11) 
    	at com.servoy.j2db.scripting.f.executeFunction(Unknown Source) 
    	at com.servoy.j2db.plugins.ClientPluginAccessProvider$a.run(Unknown Source) 
    	at com.servoy.j2db.server.headlessclient.h.invokeLater(Unknown Source) 
    	at com.servoy.j2db.plugins.ClientPluginAccessProvider$1.run(Unknown Source) 
    	at com.servoy.j2db.util.as.run(Unknown Source) 
    	at java.lang.Thread.run(Thread.java:613) 
    Caused by: java.sql.SQLException: Value '[B@b2c754' can not be represented as java.sql.Timestamp 
    	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1055) 
    	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956) 
    	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:926) 
    	at com.mysql.jdbc.ResultSetRow.getTimestampFast(ResultSetRow.java:1027) 
    	... 41 more
2009-08-25 01:06	TaskExecuter[0]	ERROR	com.servoy.j2db.util.Debug	Throwable
java.sql.SQLException: Cannot convert value '0000-00-00 00:00:00' from column 151 to TIMESTAMP. 
    	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1055) 
    	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956) 
    	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:926) 
    	at com.mysql.jdbc.ResultSetRow.getTimestampFast(ResultSetRow.java:1321) 
    	at com.mysql.jdbc.BufferRow.getTimestampFast(BufferRow.java:573) 
    	at com.mysql.jdbc.ResultSetImpl.getTimestampInternal(ResultSetImpl.java:6617) 
    	at com.mysql.jdbc.ResultSetImpl.getTimestamp(ResultSetImpl.java:5943) 
    	at org.apache.commons.dbcp.DelegatingResultSet.getTimestamp(DelegatingResultSet.java:150) 
    	at org.apache.commons.dbcp.DelegatingResultSet.getTimestamp(DelegatingResultSet.java:150) 
    	at org.apache.commons.dbcp.DelegatingResultSet.getTimestamp(DelegatingResultSet.java:150) 
    	at com.servoy.j2db.dataprocessing.BufferedDataSet.<init>(Unknown Source) 
    	at com.servoy.j2db.dataprocessing.SQLEngine.a(Unknown Source) 
    	at com.servoy.j2db.dataprocessing.SQLEngine.a(Unknown Source) 
    	at com.servoy.j2db.dataprocessing.SQLEngine.performQuery(Unknown Source) 
    	at com.servoy.j2db.dataprocessing.SQLEngine.performQuery(Unknown Source) 
    	at com.servoy.j2db.dataprocessing.RelatedFoundSet.createRelatedFoundSets(Unknown Source) 
    	at com.servoy.j2db.dataprocessing.FoundSetManager.a(Unknown Source) 
    	at com.servoy.j2db.dataprocessing.FoundSet.getRelatedFoundSet(Unknown Source) 
    	at com.servoy.j2db.dataprocessing.Record.getRelatedFoundSet(Unknown Source) 
    	at com.servoy.j2db.dataprocessing.Record.getValue(Unknown Source) 
    	at com.servoy.j2db.dataprocessing.Record.get(Unknown Source) 
    	at org.mozilla.javascript.ScriptRuntime.name(ScriptRuntime.java:1107) 
    	at org.mozilla.javascript.gen.c2681.call(mlr_appointment_conf:4) 
    	at com.servoy.j2db.scripting.f.executeFunction(Unknown Source) 
    	at com.servoy.j2db.scripting.k.get(Unknown Source) 
    	at com.servoy.j2db.dataprocessing.FoundSet.getCalculationValue(Unknown Source) 
    	at com.servoy.j2db.dataprocessing.Record.getValue(Unknown Source) 
    	at com.servoy.j2db.dataprocessing.Record.a(Unknown Source) 
    	at com.servoy.j2db.dataprocessing.JSDatabaseManager.a(Unknown Source) 
    	at com.servoy.j2db.dataprocessing.JSDatabaseManager.js_recalculate(Unknown Source) 
    	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) 
    	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) 
    	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) 
    	at java.lang.reflect.Method.invoke(Method.java:585) 
    	at org.mozilla.javascript.NativeJavaMethod.call(NativeJavaMethod.java:334) 
    	at org.mozilla.javascript.ScriptRuntime.call(ScriptRuntime.java:1254) 
    	at org.mozilla.javascript.gen.c2683.call(update_calculations:4) 
    	at org.mozilla.javascript.ScriptRuntime.call(ScriptRuntime.java:1254) 
    	at org.mozilla.javascript.gen.c4.call(batch1:11) 
    	at com.servoy.j2db.scripting.f.executeFunction(Unknown Source) 
    	at com.servoy.j2db.plugins.ClientPluginAccessProvider$a.run(Unknown Source) 
    	at com.servoy.j2db.server.headlessclient.h.invokeLater(Unknown Source) 
    	at com.servoy.j2db.plugins.ClientPluginAccessProvider$1.run(Unknown Source) 
    	at com.servoy.j2db.util.as.run(Unknown Source) 
    	at java.lang.Thread.run(Thread.java:613) 
    Caused by: java.sql.SQLException: Value '[B@10a0e3' can not be represented as java.sql.Timestamp 
    	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1055) 
    	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956) 
    	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:926) 
    	at com.mysql.jdbc.ResultSetRow.getTimestampFast(ResultSetRow.java:1027) 
    	... 41 more

The calculation step that updates this mlr_appointment_conf field is:

if (fk_drcoopappid)
{
if(medleg_client_to_so_appointments.conf==2)
return 1;
else
return 0;
}
else
return null;

where the foreign key if it exists is fk_drcoopappid, so i cannot see how there could be an error as if a related record does not yet exist,
Where do i go next?

David

2

David,

When a related foundset is loaded, Servoy fetches all columns in the related result set.
And mysql seems to have a problem with a timestamp column, it cannot read the data back that it has stored it self.

Looks like the same problem as mentioned here: viewtopic.php?p=62060#p62060

I think you need to have a look at the data in the related table.

Rob

3

Thanks Rob,

I think what you are saying is that this is not the updatecalculations script but some issue with servoy erroring on loading foundsets when i run this script.

This would make sense as a couple of the errors at the top of the script are not through a relationship, but native to the table view the script is running on, and they do not take an part in the calculation update. This did puzzle me.

I have looked through the table and some of the entries are NULL, but they would normally just be ignored? the Mysql default is to set them to NULL on creation.

It seems to correct itself after i have gone into developer and run loaded the whole set onto a view and then run the script, but i am not sure that that is anecdotal!

Looking into the Mysql Help section it refers to Mysql accepting incorrect dates and putting them as 0000-00-00 00:00:00. I think what may be happening therefore is i have an incorrect date going into my database from Servoy. Mysql allows this to happen. When i run this script it sees it sees this incorrect date as 0000-00-00 00:00:00, but then when i actually bring the records up on screen it may convert this to NULL so the next time i run the script it works OK?

i have found a line that converts date from a text field into a date, but doesn’t check to see if it is a correct date first. This may explain things:

accident_date=new Date(utils.stringRight(acc_date,4),utils.stringMiddle(acc_date, 4, 2)-1,utils.stringLeft(acc_date,2),'00', '00', '00')

dob=new Date(utils.stringRight(iCl_dob,4),utils.stringMiddle(iCl_dob, 4, 2)-1,utils.stringLeft(iCl_dob,2),'00', '00', '00')

These are dates supplied to me in an XML file from email. I think I will check that the text field contains DD-MM-YYYY or else not set the date field.

Hopefully this will fix the issue.

Thanks for the pointer. Let me know if my theory is incorrect!

David