hxtt DBF SQLException Can't find column

deezzub · January 31, 2014, 10:42am

We get a strange error on our test application server, but we don’t why, because the table is not used. Also strange is, the error message contains the column name table client_stats, but in FoxPro DBF it only is total_clie and in the Servoy DBI file it is total_clien.

java.sql.SQLException: Can't find column: total_clients_running in table client_stats 
    	at com.hxtt.global.SQLState.SQLException(Unknown Source) 
    	at com.hxtt.sql.d3.a(Unknown Source) 
    	at com.hxtt.sql.de.a(Unknown Source) 
    	at com.hxtt.sql.bz.a(Unknown Source) 
    	at com.hxtt.sql.am.a(Unknown Source) 
    	at com.hxtt.sql.d5.executeUpdate(Unknown Source) 
    	at sun.reflect.GeneratedMethodAccessor171.invoke(Unknown Source) 
    	at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) 
    	at java.lang.reflect.Method.invoke(Unknown Source) 
    	at com.servoy.j2db.datasource.Zg.invoke(Zg.java:13) 
    	at $Proxy0.executeUpdate(Unknown Source) 
    	at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105) 
    	at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105) 
    	at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105) 
    	at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105) 
    	at com.servoy.j2db.dataprocessing.Zi.Za(Zi.java:35) 
    	at com.servoy.j2db.dataprocessing.Zi.Za(Zi.java:17) 
    	at com.servoy.j2db.dataprocessing.Zb.Za(Zb.java:384) 
    	at com.servoy.j2db.dataprocessing.Zg.run(Zg.java:1) 
    	at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) 
    	at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) 
    	at java.lang.Thread.run(Unknown Source)

[attachment=2]2014-01-31_11_15_56-FoxPro_Table_Designer_-_client_stats.dbf_structure.png[/attachment]

[attachment=1]client_stats.dbi.txt[/attachment]

[attachment=0]2014-01-31_11_29_44-Servoy_Developer_search_client_stats.png[/attachment]

What causes this error?

client_stats.dbi.txt (804 Bytes)

deezzub · January 31, 2014, 10:43am

[attachment=1]2014-01-31_11_32_22-Servoy_Developer_search_total_clients_running.png[/attachment]

[attachment=0]2014-01-31_11_45_05-Servoy_Developer_search_total_clien.png[/attachment]

deezzub · January 31, 2014, 12:47pm

I have deleted all client_stats DBF and DBI files in the developement environment and the client_stats DBF on our test application server. Also I have deleted all solutions on the server. Then I have exported the solution in developer and uploaded it to the server. After that I get the following error in the server log.

2014-01-31 13:18:33,912 ERROR [pre-import hook: svy_pre_import] com.servoy.j2db.util.Debug - Throwable [ ]
com.servoy.j2db.persistence.RepositoryException: could not update columninfo from column 'total_clien' in table 'client_stats', column has none
	at com.servoy.j2db.server.Za.Zs.Za(Zs.java:8)
	at com.servoy.j2db.server.Za.Zs.Za(Zs.java:83)
	at com.servoy.j2db.server.Za.Zs.updateAllColumnInfo(Zs.java:235)
	at com.servoy.j2db.server.Za.Zo.updateAllColumnInfo(Zo.java:1081)
	at com.servoy.j2db.server.Za.Zo.Za(Zo.java:1679)
	at com.servoy.j2db.server.Za.Zo.syncTableObjWithDB(Zo.java:1460)
	at com.servoy.j2db.server.Za.Zo.createClientStatsTable(Zo.java:1495)
	at com.servoy.j2db.dataprocessing.Zi.Za(Zi.java:34)
	at com.servoy.j2db.dataprocessing.Zi.Za(Zi.java:60)
	at com.servoy.j2db.dataprocessing.Zb.Za(Zb.java:349)
	at com.servoy.j2db.dataprocessing.Za.register(Za.java:5)
	at com.servoy.j2db.ClientState.registerClient(ClientState.java:625)
	at com.servoy.j2db.server.headlessclient.SessionClient.registerClient(SessionClient.java:341)
	at com.servoy.j2db.ClientState.applicationServerInit(ClientState.java:317)
	at com.servoy.j2db.server.headlessclient.SessionClient.<init>(SessionClient.java:208)
	at com.servoy.j2db.server.headlessclient.SessionClient.<init>(SessionClient.java:162)
	at com.servoy.j2db.server.headlessclient.HeadlessClientFactoryInternal$2.<init>(HeadlessClientFactoryInternal.java:125)
	at com.servoy.j2db.server.headlessclient.HeadlessClientFactoryInternal.createImportHookClient(HeadlessClientFactoryInternal.java:125)
	at com.servoy.j2db.server.Zc.Zhb.run(Zhb.java:5)
	at java.lang.Thread.run(Unknown Source)
2014-01-31 13:18:33,912 ERROR [pre-import hook: svy_pre_import] com.servoy.j2db.util.Debug - client_stats table missing in log server, cannot save client statistics [ ]
2014-01-31 13:18:35,207 ERROR [pool-2-thread-2] com.servoy.j2db.dataprocessing.Zb - Error updating client stats [ ]
java.sql.SQLException: Can't find column: total_clients_running in table client_stats
	at com.hxtt.global.SQLState.SQLException(Unknown Source)
	at com.hxtt.sql.d3.a(Unknown Source)
	at com.hxtt.sql.de.a(Unknown Source)
	at com.hxtt.sql.bz.a(Unknown Source)
	at com.hxtt.sql.am.a(Unknown Source)
	at com.hxtt.sql.d5.executeUpdate(Unknown Source)
	at sun.reflect.GeneratedMethodAccessor41.invoke(Unknown Source)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
	at java.lang.reflect.Method.invoke(Unknown Source)
	at com.servoy.j2db.datasource.Zg.invoke(Zg.java:13)
	at $Proxy0.executeUpdate(Unknown Source)
	at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
	at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
	at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
	at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
	at com.servoy.j2db.dataprocessing.Zi.Za(Zi.java:35)
	at com.servoy.j2db.dataprocessing.Zi.Za(Zi.java:17)
	at com.servoy.j2db.dataprocessing.Zb.Za(Zb.java:384)
	at com.servoy.j2db.dataprocessing.Zg.run(Zg.java:1)
	at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
	at java.lang.Thread.run(Unknown Source)
2014-01-31 13:25:09,140 ERROR [post-import hook: svy_post_import] com.servoy.j2db.dataprocessing.Zb - Error updating client stats [ ]
java.sql.SQLException: Can't find column: total_clients_running in table client_stats
	at com.hxtt.global.SQLState.SQLException(Unknown Source)
	at com.hxtt.sql.d3.a(Unknown Source)
	at com.hxtt.sql.de.a(Unknown Source)
	at com.hxtt.sql.bz.a(Unknown Source)
	at com.hxtt.sql.am.a(Unknown Source)
	at com.hxtt.sql.d5.executeUpdate(Unknown Source)
	at sun.reflect.GeneratedMethodAccessor41.invoke(Unknown Source)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
	at java.lang.reflect.Method.invoke(Unknown Source)
	at com.servoy.j2db.datasource.Zg.invoke(Zg.java:13)
	at $Proxy0.executeUpdate(Unknown Source)
	at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
	at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
	at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
	at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
	at com.servoy.j2db.dataprocessing.Zi.Za(Zi.java:35)
	at com.servoy.j2db.dataprocessing.Zi.Za(Zi.java:60)
	at com.servoy.j2db.dataprocessing.Zb.Za(Zb.java:349)
	at com.servoy.j2db.dataprocessing.Za.register(Za.java:5)
	at com.servoy.j2db.ClientState.registerClient(ClientState.java:625)
	at com.servoy.j2db.server.headlessclient.SessionClient.registerClient(SessionClient.java:341)
	at com.servoy.j2db.ClientState.applicationServerInit(ClientState.java:317)
	at com.servoy.j2db.server.headlessclient.SessionClient.<init>(SessionClient.java:208)
	at com.servoy.j2db.server.headlessclient.SessionClient.<init>(SessionClient.java:162)
	at com.servoy.j2db.server.headlessclient.HeadlessClientFactoryInternal$2.<init>(HeadlessClientFactoryInternal.java:125)
	at com.servoy.j2db.server.headlessclient.HeadlessClientFactoryInternal.createImportHookClient(HeadlessClientFactoryInternal.java:125)
	at com.servoy.j2db.server.Zc.Zhb.run(Zhb.java:5)
	at java.lang.Thread.run(Unknown Source)
2014-01-31 13:25:09,343 ERROR [pool-2-thread-2] com.servoy.j2db.dataprocessing.Zb - Error updating client stats [ ]
java.sql.SQLException: Can't find column: total_clients_running in table client_stats
	at com.hxtt.global.SQLState.SQLException(Unknown Source)
	at com.hxtt.sql.d3.a(Unknown Source)
	at com.hxtt.sql.de.a(Unknown Source)
	at com.hxtt.sql.bz.a(Unknown Source)
	at com.hxtt.sql.am.a(Unknown Source)
	at com.hxtt.sql.d5.executeUpdate(Unknown Source)
	at sun.reflect.GeneratedMethodAccessor41.invoke(Unknown Source)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
	at java.lang.reflect.Method.invoke(Unknown Source)
	at com.servoy.j2db.datasource.Zg.invoke(Zg.java:13)
	at $Proxy0.executeUpdate(Unknown Source)
	at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
	at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
	at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
	at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
	at com.servoy.j2db.dataprocessing.Zi.Za(Zi.java:35)
	at com.servoy.j2db.dataprocessing.Zi.Za(Zi.java:17)
	at com.servoy.j2db.dataprocessing.Zb.Za(Zb.java:384)
	at com.servoy.j2db.dataprocessing.Zg.run(Zg.java:1)
	at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
	at java.lang.Thread.run(Unknown Source)
2014-01-31 13:27:16,224 ERROR [RMI TCP Connection(2)-172.20.20.9] com.servoy.j2db.dataprocessing.Zb - Error updating client stats [ ]
java.sql.SQLException: Can't find column: total_clients_running in table client_stats
	at com.hxtt.global.SQLState.SQLException(Unknown Source)
	at com.hxtt.sql.d3.a(Unknown Source)
	at com.hxtt.sql.de.a(Unknown Source)
	at com.hxtt.sql.bz.a(Unknown Source)
	at com.hxtt.sql.am.a(Unknown Source)
	at com.hxtt.sql.d5.executeUpdate(Unknown Source)
	at sun.reflect.GeneratedMethodAccessor41.invoke(Unknown Source)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
	at java.lang.reflect.Method.invoke(Unknown Source)
	at com.servoy.j2db.datasource.Zg.invoke(Zg.java:13)
	at $Proxy0.executeUpdate(Unknown Source)
	at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
	at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
	at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
	at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
	at com.servoy.j2db.dataprocessing.Zi.Za(Zi.java:35)
	at com.servoy.j2db.dataprocessing.Zi.Za(Zi.java:60)
	at com.servoy.j2db.dataprocessing.Zb.Za(Zb.java:349)
	at com.servoy.j2db.dataprocessing.Za.register(Za.java:5)
	at com.servoy.j2db.dataprocessing.Zu.register(Zu.java:1)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
	at java.lang.reflect.Method.invoke(Unknown Source)
	at sun.rmi.server.UnicastServerRef.dispatch(Unknown Source)
	at sun.rmi.transport.Transport$1.run(Unknown Source)
	at sun.rmi.transport.Transport$1.run(Unknown Source)
	at java.security.AccessController.doPrivileged(Native Method)
	at sun.rmi.transport.Transport.serviceCall(Unknown Source)
	at sun.rmi.transport.tcp.TCPTransport.handleMessages(Unknown Source)
	at sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run0(Unknown Source)
	at sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run(Unknown Source)
	at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
	at java.lang.Thread.run(Unknown Source)
2014-01-31 13:27:20,576 ERROR [RMI TCP Connection(2)-172.20.20.9] com.servoy.j2db.dataprocessing.Zb - Error updating client stats [ ]
java.sql.SQLException: Can't find column: total_clients_running in table client_stats
	at com.hxtt.global.SQLState.SQLException(Unknown Source)
	at com.hxtt.sql.d3.a(Unknown Source)
	at com.hxtt.sql.de.a(Unknown Source)
	at com.hxtt.sql.bz.a(Unknown Source)
	at com.hxtt.sql.am.a(Unknown Source)
	at com.hxtt.sql.d5.executeUpdate(Unknown Source)
	at sun.reflect.GeneratedMethodAccessor41.invoke(Unknown Source)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
	at java.lang.reflect.Method.invoke(Unknown Source)
	at com.servoy.j2db.datasource.Zg.invoke(Zg.java:13)
	at $Proxy0.executeUpdate(Unknown Source)
	at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
	at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
	at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
	at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
	at com.servoy.j2db.dataprocessing.Zi.Za(Zi.java:35)
	at com.servoy.j2db.dataprocessing.Zi.Za(Zi.java:60)
	at com.servoy.j2db.dataprocessing.Zb.Za(Zb.java:349)
	at com.servoy.j2db.dataprocessing.Za.register(Za.java:5)
	at com.servoy.j2db.ClientState.registerClient(ClientState.java:625)
	at com.servoy.j2db.server.headlessclient.SessionClient.registerClient(SessionClient.java:341)
	at com.servoy.j2db.ClientState.applicationServerInit(ClientState.java:317)
	at com.servoy.j2db.server.headlessclient.SessionClient.<init>(SessionClient.java:208)
	at com.servoy.j2db.server.headlessclient.SessionClient.<init>(SessionClient.java:162)
	at com.servoy.j2db.server.main.Zd.<init>(Zd.java:5)
	at com.servoy.j2db.server.main.Zq.run(Zq.java:35)
	at com.servoy.j2db.server.main.Zm.login(Zm.java:4)
	at com.servoy.j2db.server.main.Zo.login(Zo.java:10)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
	at java.lang.reflect.Method.invoke(Unknown Source)
	at sun.rmi.server.UnicastServerRef.dispatch(Unknown Source)
	at sun.rmi.transport.Transport$1.run(Unknown Source)
	at sun.rmi.transport.Transport$1.run(Unknown Source)
	at java.security.AccessController.doPrivileged(Native Method)
	at sun.rmi.transport.Transport.serviceCall(Unknown Source)
	at sun.rmi.transport.tcp.TCPTransport.handleMessages(Unknown Source)
	at sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run0(Unknown Source)
	at sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run(Unknown Source)
	at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
	at java.lang.Thread.run(Unknown Source)
2014-01-31 13:27:21,700 ERROR [pool-2-thread-2] com.servoy.j2db.dataprocessing.Zb - Error updating client stats [ ]
java.sql.SQLException: Can't find column: total_clients_running in table client_stats
	at com.hxtt.global.SQLState.SQLException(Unknown Source)
	at com.hxtt.sql.d3.a(Unknown Source)
	at com.hxtt.sql.de.a(Unknown Source)
	at com.hxtt.sql.bz.a(Unknown Source)
	at com.hxtt.sql.am.a(Unknown Source)
	at com.hxtt.sql.d5.executeUpdate(Unknown Source)
	at sun.reflect.GeneratedMethodAccessor41.invoke(Unknown Source)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
	at java.lang.reflect.Method.invoke(Unknown Source)
	at com.servoy.j2db.datasource.Zg.invoke(Zg.java:13)
	at $Proxy0.executeUpdate(Unknown Source)
	at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
	at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
	at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
	at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
	at com.servoy.j2db.dataprocessing.Zi.Za(Zi.java:35)
	at com.servoy.j2db.dataprocessing.Zi.Za(Zi.java:17)
	at com.servoy.j2db.dataprocessing.Zb.Za(Zb.java:384)
	at com.servoy.j2db.dataprocessing.Zg.run(Zg.java:1)
	at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
	at java.lang.Thread.run(Unknown Source)

Also, really strange is, that the client_stats DBF file again there are on the server.

deezzub · January 31, 2014, 2:59pm

Problem solved. The log server was mistakenly set to the DBF server.

But, why are the DBF column name and the DBI column name different?

Topic		Replies	Views
SQL Error Classic Servoy	4	3010	July 23, 2011
jdbc:ODBC error: Column not found Classic Servoy	1	1441	March 30, 2004
java.sql.SQLException: Failed to calculate index value ... Classic Servoy	0	2221	February 21, 2014
'nan' error? Classic Servoy	12	4384	March 1, 2005
HXTT foxpro DBF connection Classic Servoy	5	5438	February 10, 2016

hxtt DBF SQLException Can't find column

Related topics