Hi Guys, I have created a model with a few entities and forms. No errors in the model. When I run I get the folowing error: Request action: start Message: runtime.start() should not throw anything other than AdminException! Cause: java.sql.SQLException: invalid cursor state: identifier cursor not positioned on row in UPDATE, DELETE, SET, or GET statement: ; ResultSet is empty Stack trace: runtime.start() should not throw anything other than AdminException! at kX.execute(SourceFile:61) at com.mendix.m2ee.server.handler.AdminHandler.handle(AdminHandler.java:105) at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:113) at org.eclipse.jetty.server.Server.handle(Server.java:334) at org.eclipse.jetty.server.HttpConnection.handleRequest(HttpConnection.java:559) at org.eclipse.jetty.server.HttpConnection$RequestHandler.headerComplete(HttpConnection.java:992) at org.eclipse.jetty.http.HttpParser.parseNext(HttpParser.java:550) at org.eclipse.jetty.http.HttpParser.parseAvailable(HttpParser.java:203) at org.eclipse.jetty.server.HttpConnection.handle(HttpConnection.java:406) at org.eclipse.jetty.io.nio.SelectChannelEndPoint.run(SelectChannelEndPoint.java:462) at org.eclipse.jetty.util.thread.QueuedThreadPool$2.run(QueuedThreadPool.java:436) at java.lang.Thread.run(Thread.java:619) Caused by: java.sql.SQLException: invalid cursor state: identifier cursor not positioned on row in UPDATE, DELETE, SET, or GET statement: ; ResultSet is empty at x.b(SourceFile:914) at x.b(SourceFile:832) at x.b(SourceFile:231) at x.a(SourceFile:72) at fl.b(SourceFile:175) at fl.a(SourceFile:149) at iM.b(SourceFile:130) at com.mendix.core.MxRuntime.F(SourceFile:438) at com.mendix.core.MxRuntime.a(SourceFile:219) at kX.execute(SourceFile:53) at com.mendix.m2ee.server.handler.AdminHandler.handle(AdminHandler.java:105) at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:113) at org.eclipse.jetty.server.Server.handle(Server.java:334) at org.eclipse.jetty.server.HttpConnection.handleRequest(HttpConnection.java:559) at org.eclipse.jetty.server.HttpConnection$RequestHandler.headerComplete(HttpConnection.java:992) at org.eclipse.jetty.http.HttpParser.parseNext(HttpParser.java:550) at org.eclipse.jetty.http.HttpParser.parseAvailable(HttpParser.java:203) at org.eclipse.jetty.server.HttpConnection.handle(HttpConnection.java:406) at org.eclipse.jetty.io.nio.SelectChannelEndPoint.run(SelectChannelEndPoint.java:462) at org.eclipse.jetty.util.thread.QueuedThreadPool$2.run(QueuedThreadPool.java:436) at java.lang.Thread.run(Thread.java:619) Caused by: invalid cursor state: identifier cursor not positioned on row in UPDATE, DELETE, SET, or GET statement: ; ResultSet is empty at org.hsqldb.jdbc.Util.sqlException(Unknown Source) at org.hsqldb.jdbc.Util.sqlException(Unknown Source) at org.hsqldb.jdbc.Util.sqlException(Unknown Source) at org.hsqldb.jdbc.JDBCResultSet.getCurrent(Unknown Source) at org.hsqldb.jdbc.JDBCResultSet.getColumnInType(Unknown Source) at org.hsqldb.jdbc.JDBCResultSet.getLong(Unknown Source) at org.apache.commons.dbcp.DelegatingResultSet.getLong(DelegatingResultSet.java:228) at org.apache.commons.dbcp.DelegatingResultSet.getLong(DelegatingResultSet.java:228) at x.b(SourceFile:910) at x.b(SourceFile:832) at x.b(SourceFile:231) at x.a(SourceFile:72) at fl.b(SourceFile:175) at fl.a(SourceFile:149) at iM.b(SourceFile:130) at com.mendix.core.MxRuntime.F(SourceFile:438) at com.mendix.core.MxRuntime.a(SourceFile:219) at kX.execute(SourceFile:53) at com.mendix.m2ee.server.handler.AdminHandler.handle(AdminHandler.java:105) at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:113) at org.eclipse.jetty.server.Server.handle(Server.java:334) at org.eclipse.jetty.server.HttpConnection.handleRequest(HttpConnection.java:559) at org.eclipse.jetty.server.HttpConnection$RequestHandler.headerComplete(HttpConnection.java:992) at org.eclipse.jetty.http.HttpParser.parseNext(HttpParser.java:550) at org.eclipse.jetty.http.HttpParser.parseAvailable(HttpParser.java:203) at org.eclipse.jetty.server.HttpConnection.handle(HttpConnection.java:406) at org.eclipse.jetty.io.nio.SelectChannelEndPoint.run(SelectChannelEndPoint.java:462) at org.eclipse.jetty.util.thread.QueuedThreadPool$2.run(QueuedThreadPool.java:436) at java.lang.Thread.run(Thread.java:619) Caused by: invalid cursor state: identifier cursor not positioned on row in UPDATE, DELETE, SET, or GET statement: ; ResultSet is empty at org.hsqldb.error.Error.error(Unknown Source) at org.hsqldb.error.Error.error(Unknown Source) at org.hsqldb.jdbc.Util.sqlException(Unknown Source) at org.hsqldb.jdbc.JDBCResultSet.getCurrent(Unknown Source) at org.hsqldb.jdbc.JDBCResultSet.getColumnInType(Unknown Source) at org.hsqldb.jdbc.JDBCResultSet.getLong(Unknown Source) at org.apache.commons.dbcp.DelegatingResultSet.getLong(DelegatingResultSet.java:228) at org.apache.commons.dbcp.DelegatingResultSet.getLong(DelegatingResultSet.java:228) at x.b(SourceFile:910) at x.b(SourceFile:832) at x.b(SourceFile:231) at x.a(SourceFile:72) at fl.b(SourceFile:175) at fl.a(SourceFile:149) at iM.b(SourceFile:130) at com.mendix.core.MxRuntime.F(SourceFile:438) at com.mendix.core.MxRuntime.a(SourceFile:219) at kX.execute(SourceFile:53) at com.mendix.m2ee.server.handler.AdminHandler.handle(AdminHandler.java:105) at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:113) at org.eclipse.jetty.server.Server.handle(Server.java:334) at org.eclipse.jetty.server.HttpConnection.handleRequest(HttpConnection.java:559) at org.eclipse.jetty.server.HttpConnection$RequestHandler.headerComplete(HttpConnection.java:992) at org.eclipse.jetty.http.HttpParser.parseNext(HttpParser.java:550) at org.eclipse.jetty.http.HttpParser.parseAvailable(HttpParser.java:203) at org.eclipse.jetty.server.HttpConnection.handle(HttpConnection.java:406) at org.eclipse.jetty.io.nio.SelectChannelEndPoint.run(SelectChannelEndPoint.java:462) at org.eclipse.jetty.util.thread.QueuedThreadPool$2.run(QueuedThreadPool.java:436) at java.lang.Thread.run(Thread.java:619) Can anyone help me. Erik Diepstraten
asked
Erik Diepstraten
2 answers
4
Seems like an error I have had before after making changes to the datamodel (for example changing a non-numeric field into a numeric field) and already having numeric entries in the database.
My solution is 1) closing mendix, 2) removing the files from the deployment location and 3) deploy again.
Downpart is that your database is removed and all entries are lost
answered
Jacco Feenstra
2
Try to reproduce this and file a bug report at the partner portal (mxdn), with the hsqldb files (in deployment/data/hsqldb) and the project file (mpr) as attachment. This looks like an edge-case where synchonizing the database structure fails.
If reproducing fails, just file a bug because of the excessive amount of 'Caused by' in the stack trace.