Upgrade to mendix 5

0
Hi All, I just upgraded my project from 4.8.10 to 5.21.5. When I run it first time it gives me following error -  com.mendix.m2ee.api.AdminException: Executing DDL commands for component MyFirstComponent failed.     at com.mendix.core.component.internal.LocalComponentImpl.executeDDLCommands(LocalComponentImpl.scala:133) Caused by: com.mendix.systemwideinterfaces.connectionbus.ConnectionBusException: Error (SQL State: 42501, Error Code: -5501) on executing: ALTER TABLE "system$licenseinformation" RENAME TO "65468d26459e403eb1b3b266191ccd67"; ALTER TABLE "system$userlimitation" RENAME TO "7db7acb509ec4d67b04ef3648d8c236f";   ALTER TABLE "system$filedocument"     ADD "__uuid__" VARCHAR_IGNORECASE(36) NULL;   Caused by: java.sql.SQLSyntaxErrorException: user lacks privilege or object not found: PUBLIC.system$licenseinformation     at org.hsqldb.jdbc.JDBCUtil.sqlException(Unknown Source)     at org.hsqldb.jdbc.JDBCUtil.sqlException(Unknown Source)     at org.hsqldb.jdbc.JDBCStatement.fetchResult(Unknown Source)     at org.hsqldb.jdbc.JDBCStatement.execute(Unknown Source)     at org.apache.commons.dbcp2.DelegatingStatement.execute(DelegatingStatement.java:291)     at org.apache.commons.dbcp2.DelegatingStatement.execute(DelegatingStatement.java:291)     at com.mendix.connectionbus.modelsynchronization.DDLCommandExecutor.executeDDLCommands(DDLCommandExecutor.java:139)     at com.mendix.connectionbus.modelsynchronization.DDLCommandExecutor.execute(DDLCommandExecutor.java:47)     at com.mendix.connectionbus.modelsynchronization.SynchronizationManager.synchronizeModel(SynchronizationManager.scala:138)     at com.mendix.connectionbus.modelsynchronization.SynchronizationManager.executeImpl(SynchronizationManager.scala:129)     at com.mendix.connectionbus.modelsynchronization.SynchronizationManager.execute(SynchronizationManager.scala:79)     at com.mendix.connectionbus.ConnectionBusImpl.executeDDLCommands(ConnectionBusImpl.java:324)     at com.mendix.core.component.internal.LocalComponentImpl.executeDDLCommands(LocalComponentImpl.scala:130)     at com.mendix.core.impl.MxRuntimeImpl.executeDDLCommands(MxRuntimeImpl.java:852)     at com.mendix.core.action.admin.ExecuteDDLCommandsAction.call(ExecuteDDLCommandsAction.java:27)     at com.mendix.core.action.admin.RuntimeAdminAction$1.execute(RuntimeAdminAction.java:23)     at com.mendix.core.action.admin.RuntimeAdminAction$1.execute(RuntimeAdminAction.java:20)     at com.mendix.util.classloading.Runner.doRunUsingClassLoaderOf(Runner.java:32)     at com.mendix.util.classloading.Runner$1.run(Runner.java:21)     at java.security.AccessController.doPrivileged(Native Method)     at com.mendix.util.classloading.Runner.runUsingClassLoaderOf(Runner.java:17)     at com.mendix.core.action.admin.RuntimeAdminAction.execute(RuntimeAdminAction.java:25)     at com.mendix.m2ee.appcontainer.server.handler.HttpAdminHandler.handle(HttpAdminHandler.java:122)     at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:116)     at org.eclipse.jetty.server.Server.handle(Server.java:368)     at org.eclipse.jetty.server.AbstractHttpConnection.handleRequest(AbstractHttpConnection.java:489)     at org.eclipse.jetty.server.AbstractHttpConnection.headerComplete(AbstractHttpConnection.java:942)     at org.eclipse.jetty.server.AbstractHttpConnection$RequestHandler.headerComplete(AbstractHttpConnection.java:1004)     at org.eclipse.jetty.http.HttpParser.parseNext(HttpParser.java:647)     at org.eclipse.jetty.http.HttpParser.parseAvailable(HttpParser.java:235)     at org.eclipse.jetty.server.AsyncHttpConnection.handle(AsyncHttpConnection.java:82)     at org.eclipse.jetty.io.nio.SelectChannelEndPoint.handle(SelectChannelEndPoint.java:628)     at org.eclipse.jetty.io.nio.SelectChannelEndPoint$1.run(SelectChannelEndPoint.java:52)     at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:608)     at org.eclipse.jetty.util.thread.QueuedThreadPool$3.run(QueuedThreadPool.java:543)     at java.lang.Thread.run(Thread.java:745) Caused by: org.hsqldb.HsqlException: user lacks privilege or object not found: PUBLIC.system$licenseinformation     at org.hsqldb.error.Error.error(Unknown Source) I can see there is no table "system$userlimitation" present in project.   Could you please let me know how can i resolve it? Thanks Abhinay
asked
1 answers
1

It could be that you are using an really old or maybe corrupted version of HSQL db (the built-in db). Mendix 4 wasn't the best in keeping the builtin db in a correct structure.

 

If you can I'd recommend to just remove the built-in database, by removing your 'deployment' folder, and throwing away the datasnapshot.zip    that allows the platform to start from scratch and should generate a new consistent empty db.
If you want to keep the database, you should review the database structure manually and restore any issue that Mx4 may have caused. 

answered