Error when deploying in 2.5.0.1

2
When trying to deploy a project from the Modeler 2.5.0.1, the following error occurs. The model-database and data-database are hosted on SQL2005. Deployment has worked before, but now the error occurs every time. In the mean time there were no changes in the model or database. The connection between the Mendix server and the SQL server is fine. The 'log node' is M2EE. Does anyone know what causes this problem? This is the error: Request action: start Message: An error occurred while reading the Application Model Cause: An error occurred while storing column data for all existing tables in the SQLite database Stack trace: An error occurred while reading the Application Model at com.mendix.core.MxRuntime.B(SourceFile:343) at com.mendix.core.MxRuntime.a(SourceFile:182) at lh.execute(SourceFile:54) at com.mendix.m2ee.server.handler.AdminHandler.handle(AdminHandler.java:113) 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: An error occurred while storing column data for all existing tables in the SQLite database at eM.a(SourceFile:125) at eM.<init>(SourceFile:57) at kY.a(SourceFile:41) at dL.a(SourceFile:126) at com.mendix.core.MxRuntime.B(SourceFile:333) at com.mendix.core.MxRuntime.a(SourceFile:182) at lh.execute(SourceFile:54) at com.mendix.m2ee.server.handler.AdminHandler.handle(AdminHandler.java:113) 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: unable to open database file at org.sqlite.DB.execute(DB.java:275) at org.sqlite.PrepStmt.executeQuery(PrepStmt.java:67) at eM.a(SourceFile:116) at eM.<init>(SourceFile:57) at kY.a(SourceFile:41) at dL.a(SourceFile:126) at com.mendix.core.MxRuntime.B(SourceFile:333) at com.mendix.core.MxRuntime.a(SourceFile:182) at lh.execute(SourceFile:54) at com.mendix.m2ee.server.handler.AdminHandler.handle(AdminHandler.java:113) 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)
asked
2 answers
2

Did your problem occur since you installed 2.5.0.1? And are you using windows 7?

In some of my projects i have a similar, this happend because I initially deployed while the modeler was running as administrator. When that happens windows does something with the security of the folder. Which causes this exception next time you start your modeler.

The only solutionsI have found for my problem so far:
- run the modeler and eclipse as administrator
- choose a different deployment folder. (and never deploy when the modeler is started as admin)

answered
3

Cause: An error occurred while storing column data for all existing tables in the SQLite database Stack trace.

Seems like you have made changes to the datamodel (for example changing a non-numeric field into a numeric field) and already having numeric entries in the database. Remove the entries from the datamodel and deploy again.

Otherwise try to reproduce the error in another model and see what happens.

answered