Could not resolve column ServoyException Errorcode: 217

Classic Servoy
1

I get the following error. Seems to be a Servoy / Framework bug?

Exception Object: com.servoy.j2db.persistence.RepositoryException: java.lang.IllegalStateException: Could not resolve column src_svy_framework_entwicklung:dbo:nav_tab<db:/svy_framework/nav_tab>#navtab51006.1073773068=?
MSG: java.lang.IllegalStateException: Could not resolve column src_svy_framework_entwicklung:dbo:nav_tab<db:/svy_framework/nav_tab>#navtab51006.1073773068=?
is a ServoyException
Errorcode: 217
com.servoy.j2db.persistence.RepositoryException: java.lang.IllegalStateException: Could not resolve column src_svy_framework_entwicklung:dbo:nav_tab<db:/svy_framework/nav_tab>#navtab51006.1073773068=?
	at com.servoy.j2db.server.Za.Zo.getSQLQuerySet(Zo.java:1238)
	at com.servoy.j2db.dataprocessing.Zv.getSQLQuerySet(Zv.java:405)
	at sun.reflect.GeneratedMethodAccessor227.invoke(Unknown Source)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
	at java.lang.reflect.Method.invoke(Unknown Source)
	at com.servoy.j2db.util.AbstractRemoteInvocationHandler.invokeMethod(AbstractRemoteInvocationHandler.java:77)
	at com.servoy.j2db.util.ThreadingRemoteInvocationHandler$1.run(ThreadingRemoteInvocationHandler.java:79)
	at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
	at java.lang.Thread.run(Unknown Source)

java.lang.IllegalStateException: Could not resolve column src_svy_framework_entwicklung:dbo:nav_tab<db:/svy_framework/nav_tab>#navtab51006.1073773068=?
Wrapped com.servoy.j2db.persistence.RepositoryException: java.lang.IllegalStateException: Could not resolve column src_svy_framework_entwicklung:dbo:nav_tab<db:/svy_framework/nav_tab>#navtab51006.1073773068=? (H:\servoy_workspace_git\boss\modUtils\modUtils$data.js#91)
	at H:\servoy_workspace_git\boss\modUtils\modUtils$data.js:91 (getRecord)
	at H:\servoy_workspace_git\boss\svy_nav_navigation\forms\svy_nav_base.js:2298 (syncFoundsets)
	at H:\servoy_workspace_git\boss\svy_nav_navigation\forms\svy_nav_base.js:2329 (syncFoundsets)
	at H:\servoy_workspace_git\boss\br_boss_globals\forms\boss_svy_framework_extensions.js:922 (onRecordSelection)
	at H:\servoy_workspace_git\boss\br_boss_claims_vessel_documents\forms\br_boss_claims_vessel_documents_head_tbl.js:152 (onRecordSelection)

Exception Object: com.servoy.j2db.persistence.RepositoryException: java.lang.IllegalStateException: Could not resolve column src_svy_framework_entwicklung:dbo:sec_user<db:/svy_framework/sec_user>#secuser51079.1073772489=?
MSG: java.lang.IllegalStateException: Could not resolve column src_svy_framework_entwicklung:dbo:sec_user<db:/svy_framework/sec_user>#secuser51079.1073772489=?
is a ServoyException
Errorcode: 217
com.servoy.j2db.persistence.RepositoryException: java.lang.IllegalStateException: Could not resolve column src_svy_framework_entwicklung:dbo:sec_user<db:/svy_framework/sec_user>#secuser51079.1073772489=?
	at com.servoy.j2db.server.Za.Zo.getSQLQuerySet(Zo.java:1238)
	at com.servoy.j2db.dataprocessing.Zv.getSQLQuerySet(Zv.java:405)
	at sun.reflect.GeneratedMethodAccessor227.invoke(Unknown Source)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
	at java.lang.reflect.Method.invoke(Unknown Source)
	at com.servoy.j2db.util.AbstractRemoteInvocationHandler.invokeMethod(AbstractRemoteInvocationHandler.java:77)
	at com.servoy.j2db.util.ThreadingRemoteInvocationHandler$1.run(ThreadingRemoteInvocationHandler.java:79)
	at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
	at java.lang.Thread.run(Unknown Source)

java.lang.IllegalStateException: Could not resolve column src_svy_framework_entwicklung:dbo:sec_user<db:/svy_framework/sec_user>#secuser51079.1073772489=?
Wrapped com.servoy.j2db.persistence.RepositoryException: java.lang.IllegalStateException: Could not resolve column src_svy_framework_entwicklung:dbo:sec_user<db:/svy_framework/sec_user>#secuser51079.1073772489=? (H:\servoy_workspace_git\boss\svyApplicationCore\svySecurityManager.js#573)
	at H:\servoy_workspace_git\boss\svyApplicationCore\svySecurityManager.js:573 (getUserById)
	at H:\servoy_workspace_git\boss\svyApplicationCore\svyProperties.js:2190 (setUserProperty)
	at H:\servoy_workspace_git\boss\svyApplicationCore\forms\svyUserPropertiesPersistenceImpl.js:19 (setUserProperty)
	at H:\servoy_workspace_git\boss\modUtils\modUtils$system.js:167 (setUserProperty)
	at H:\servoy_workspace_git\boss\modUtils\modUtils$UI.js:239 (persistSplitPaneDividerPosition)
	at H:\servoy_workspace_git\boss\svy_nav_navigation\forms\svy_nav_fr_template_base.js:620 (onHide)
	at H:\servoy_workspace_git\boss\svy_nav_navigation\forms\svy_nav_fr_p_main.js:184 (onClose)
	at H:\servoy_workspace_git\boss\svy_nav_navigation\globals.js:1161 (svy_nav_onClose)
	at H:\servoy_workspace_git\boss\BOSS\boss$initialization.js:201 (onSolutionClose)

Exception Object: com.servoy.j2db.persistence.RepositoryException: java.lang.IllegalStateException: Could not resolve column src_svy_framework_entwicklung:dbo:sec_user_table_properties<db:/svy_framework/sec_user_table_properties>#secusertableproperties51082.1073773330=?
MSG: java.lang.IllegalStateException: Could not resolve column src_svy_framework_entwicklung:dbo:sec_user_table_properties<db:/svy_framework/sec_user_table_properties>#secusertableproperties51082.1073773330=?
is a ServoyException
Errorcode: 217
com.servoy.j2db.persistence.RepositoryException: java.lang.IllegalStateException: Could not resolve column src_svy_framework_entwicklung:dbo:sec_user_table_properties<db:/svy_framework/sec_user_table_properties>#secusertableproperties51082.1073773330=?
	at com.servoy.j2db.server.Za.Zo.getSQLQuerySet(Zo.java:1238)
	at com.servoy.j2db.dataprocessing.Zv.getSQLQuerySet(Zv.java:405)
	at sun.reflect.GeneratedMethodAccessor227.invoke(Unknown Source)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
	at java.lang.reflect.Method.invoke(Unknown Source)
	at com.servoy.j2db.util.AbstractRemoteInvocationHandler.invokeMethod(AbstractRemoteInvocationHandler.java:77)
	at com.servoy.j2db.util.ThreadingRemoteInvocationHandler$1.run(ThreadingRemoteInvocationHandler.java:79)
	at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
	at java.lang.Thread.run(Unknown Source)

java.lang.IllegalStateException: Could not resolve column src_svy_framework_entwicklung:dbo:sec_user_table_properties<db:/svy_framework/sec_user_table_properties>#secusertableproperties51082.1073773330=?
Wrapped com.servoy.j2db.persistence.RepositoryException: java.lang.IllegalStateException: Could not resolve column src_svy_framework_entwicklung:dbo:sec_user_table_properties<db:/svy_framework/sec_user_table_properties>#secusertableproperties51082.1073773330=? (H:\servoy_workspace_git\boss\svy_nav_navigation\globals.js#1020)
	at H:\servoy_workspace_git\boss\svy_nav_navigation\globals.js:1020 (svy_nav_saveTableViewPersistance)
	at H:\servoy_workspace_git\boss\svy_nav_navigation\forms\svy_nav_base.js:72 (onHide)
	at H:\servoy_workspace_git\boss\svy_nav_navigation\forms\svy_nav_fr_p_main.js:184 (onClose)
	at H:\servoy_workspace_git\boss\svy_nav_navigation\globals.js:1161 (svy_nav_onClose)
	at H:\servoy_workspace_git\boss\BOSS\boss$initialization.js:201 (onSolutionClose)

Exception Object: com.servoy.j2db.persistence.RepositoryException: java.lang.IllegalStateException: Could not resolve column src_svy_framework_entwicklung:dbo:sec_user<db:/svy_framework/sec_user>#secuser51085.1073772489=?
MSG: java.lang.IllegalStateException: Could not resolve column src_svy_framework_entwicklung:dbo:sec_user<db:/svy_framework/sec_user>#secuser51085.1073772489=?
is a ServoyException
Errorcode: 217
com.servoy.j2db.persistence.RepositoryException: java.lang.IllegalStateException: Could not resolve column src_svy_framework_entwicklung:dbo:sec_user<db:/svy_framework/sec_user>#secuser51085.1073772489=?
	at com.servoy.j2db.server.Za.Zo.getSQLQuerySet(Zo.java:1238)
	at com.servoy.j2db.dataprocessing.Zv.getSQLQuerySet(Zv.java:405)
	at sun.reflect.GeneratedMethodAccessor227.invoke(Unknown Source)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
	at java.lang.reflect.Method.invoke(Unknown Source)
	at com.servoy.j2db.util.AbstractRemoteInvocationHandler.invokeMethod(AbstractRemoteInvocationHandler.java:77)
	at com.servoy.j2db.util.ThreadingRemoteInvocationHandler$1.run(ThreadingRemoteInvocationHandler.java:79)
	at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
	at java.lang.Thread.run(Unknown Source)

java.lang.IllegalStateException: Could not resolve column src_svy_framework_entwicklung:dbo:sec_user<db:/svy_framework/sec_user>#secuser51085.1073772489=?
Wrapped com.servoy.j2db.persistence.RepositoryException: java.lang.IllegalStateException: Could not resolve column src_svy_framework_entwicklung:dbo:sec_user<db:/svy_framework/sec_user>#secuser51085.1073772489=? (H:\servoy_workspace_git\boss\svyApplicationCore\svySecurityManager.js#573)
	at H:\servoy_workspace_git\boss\svyApplicationCore\svySecurityManager.js:573 (getUserById)
	at H:\servoy_workspace_git\boss\svyApplicationCore\svyProperties.js:2190 (setUserProperty)
	at H:\servoy_workspace_git\boss\svyApplicationCore\forms\svyUserPropertiesPersistenceImpl.js:19 (setUserProperty)
	at H:\servoy_workspace_git\boss\modUtils\modUtils$system.js:167 (setUserProperty)
	at H:\servoy_workspace_git\boss\modUtils\modUtils$UI.js:239 (persistSplitPaneDividerPosition)
	at H:\servoy_workspace_git\boss\svy_nav_navigation\forms\svy_nav_fr_template_base.js:620 (onHide)
	at H:\servoy_workspace_git\boss\svy_nav_navigation\forms\svy_nav_fr_p_main.js:184 (onClose)
	at H:\servoy_workspace_git\boss\svy_nav_navigation\globals.js:1161 (svy_nav_onClose)
	at H:\servoy_workspace_git\boss\BOSS\boss$initialization.js:201 (onSolutionClose)
2

are you sure you don’t have problems in the problem area that your dbi files are out of sync with the actual database?

Because the query that is generated on the client and send to the server part is using a column that is not actually found in the server bookkeeping

3

jcompagner:
are you sure you don’t have problems in the problem area that your dbi files are out of sync with the actual database?

Because the query that is generated on the client and send to the server part is using a column that is not actually found in the server bookkeeping

I don’t think, that they out of sync, because it is our Servoy Framework MS SQL server and we don’t change anything on that database. After Smart Client restart the problem was gone.

4

Today I got the ServoyException Errorcode: 217 again.

Excerpt:

Exception Object: com.servoy.j2db.persistence.RepositoryException: java.lang.IllegalStateException: Could not resolve column AUFKOPF<db:/boss_db/aufkopf>#AUFKOPF1759.1073761107=?
MSG: java.lang.IllegalStateException: Could not resolve column AUFKOPF<db:/boss_db/aufkopf>#AUFKOPF1759.1073761107=?
is a ServoyException
Errorcode: 217
com.servoy.j2db.persistence.RepositoryException: java.lang.IllegalStateException: Could not resolve column AUFKOPF<db:/boss_db/aufkopf>#AUFKOPF1759.1073761107=?
	at com.servoy.j2db.server.Za.Zo.getSQLQuerySet(Zo.java:1307)
	at com.servoy.j2db.server.dataprocessing.Zw.getSQLQuerySet(Zw.java:1065)
	at sun.reflect.GeneratedMethodAccessor242.invoke(Unknown Source)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
	at java.lang.reflect.Method.invoke(Unknown Source)
	at com.servoy.j2db.util.AbstractRemoteInvocationHandler.invokeMethod(AbstractRemoteInvocationHandler.java:77)
	at com.servoy.j2db.util.ThreadingRemoteInvocationHandler$1.run(ThreadingRemoteInvocationHandler.java:79)
	at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
	at java.lang.Thread.run(Unknown Source)
 
Could not load record
 > com.servoy.j2db.persistence.RepositoryException: java.lang.IllegalStateException: Could not resolve column AUFKOPF<db:/boss_db/aufkopf>#AUFKOPF1759.1073761107=?
Exception Object: com.servoy.j2db.persistence.RepositoryException: java.lang.IllegalStateException: Could not resolve column AUFKOPF<db:/boss_db/aufkopf>#AUFKOPF1761.1073761107=?
MSG: java.lang.IllegalStateException: Could not resolve column AUFKOPF<db:/boss_db/aufkopf>#AUFKOPF1761.1073761107=?
is a ServoyException
Errorcode: 217
com.servoy.j2db.persistence.RepositoryException: java.lang.IllegalStateException: Could not resolve column AUFKOPF<db:/boss_db/aufkopf>#AUFKOPF1761.1073761107=?
	at com.servoy.j2db.server.Za.Zo.getSQLQuerySet(Zo.java:1307)
	at com.servoy.j2db.server.dataprocessing.Zw.getSQLQuerySet(Zw.java:1065)
	at sun.reflect.GeneratedMethodAccessor242.invoke(Unknown Source)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
	at java.lang.reflect.Method.invoke(Unknown Source)
	at com.servoy.j2db.util.AbstractRemoteInvocationHandler.invokeMethod(AbstractRemoteInvocationHandler.java:77)
	at com.servoy.j2db.util.ThreadingRemoteInvocationHandler$1.run(ThreadingRemoteInvocationHandler.java:79)
	at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
	at java.lang.Thread.run(Unknown Source)
5

Sebastian,

Basically, what happens is that when Servoy does a query from smart client to server, the column names are not sent but the column ids.
On the server these are resolved to the column names.
When this fails the above exception is thrown,

From the stack trace I see this happens to you in developer,
It seems it can happen that server-side info in Developer is modified (by editing tables, reloading from db, etc), and the running debug-smartclient has out-of-date column info.
A restart of the debug-smartclient should fix that.

Since db data is not changing in Application Server, this should not happen in regular smart clients.

Rob

6

At an end user site (Servoy application server running, no developer) we get this error message :

java.lang.IllegalStateException: Could not resolve column public:crm_department#crmdepartment376592.9627=?
at com.servoy.j2db.server.Zc.Zc.Za(Zc.java:97)
at com.servoy.j2db.dataprocessing.Zw.Za(Zw.java:431)
at com.servoy.j2db.dataprocessing.Zw.Za(Zw.java:476)
at com.servoy.j2db.dataprocessing.Zw.performQuery(Zw.java:1074)
at com.servoy.j2db.dataprocessing.Zw.performQuery(Zw.java:633)
at sun.reflect.GeneratedMethodAccessor253.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)

What is happening ?

Servoy 5.2.17.

Regards,