Database exception when running project

0
Hi everyone,  I migrated a project from Mendix 4.7.2 to Mendix 5.21.5 and then to Mendix 6.10.2. In Mendix 5.21.5 it was no problem to run the project locally. But after migrating to Mendix 6.10.2 I receive the following exception when running the project locally on a SQL database. This is the same Database used for the migration from Mendix 4.7.2 to Mendix 5.21.5.  Does anyone know what the cause of the exception is and how to solve this exception?   Exception in execution of monitored action 'null' (execution id: c0833243-27a1-43a9-b1f2-a51dcde8b571, execution type: SCHEDULED_EVENT)   --------   com.mendix.core.CoreRuntimeException: com.mendix.systemwideinterfaces.MendixRuntimeException: com.mendix.core.CoreRuntimeException: Exception occurred in action '{}', all database changes executed by this action were rolled back                 at com.mendix.core.actionmanagement.ActionManager.executeSync(ActionManager.java:176)   Caused by: com.mendix.systemwideinterfaces.MendixRuntimeException: com.mendix.core.CoreRuntimeException: Exception occurred in action '{}', all database changes executed by this action were rolled back                 at com.mendix.util.classloading.Runner.doRunUsingClassLoaderOf(Runner.java:40)   Caused by: com.mendix.core.CoreRuntimeException: Exception occurred in action '{}', all database changes executed by this action were rolled back                 at com.mendix.core.actionmanagement.CoreAction.processErrorState(CoreAction.java:303)   Caused by: com.mendix.core.CoreRuntimeException: com.mendix.systemwideinterfaces.MendixRuntimeException: com.mendix.core.CoreRuntimeException: Exception occurred in action '{"request":"OQLTextGetRequest (depth = -1): SELECT *            FROM System.BackgroundJob            WHERE                EndTime < $END_TIME                or StartTime < $START_TIME","type":"RetrieveOQLDataTableAction"}', all database changes executed by this action were rolled back                 at com.mendix.core.actionmanagement.ActionManager.executeSync(ActionManager.java:176)   Caused by: com.mendix.systemwideinterfaces.MendixRuntimeException: com.mendix.core.CoreRuntimeException: Exception occurred in action '{"request":"OQLTextGetRequest (depth = -1): SELECT *            FROM System.BackgroundJob            WHERE                EndTime < $END_TIME                or StartTime < $START_TIME","type":"RetrieveOQLDataTableAction"}', all database changes executed by this action were rolled back                 at com.mendix.util.classloading.Runner.doRunUsingClassLoaderOf(Runner.java:40)   Caused by: com.mendix.core.CoreRuntimeException: Exception occurred in action '{"request":"OQLTextGetRequest (depth = -1): SELECT *            FROM System.BackgroundJob            WHERE                EndTime < $END_TIME                or StartTime < $START_TIME","type":"RetrieveOQLDataTableAction"}', all database changes executed by this action were rolled back                 at com.mendix.core.actionmanagement.CoreAction.processErrorState(CoreAction.java:303)   Caused by: com.mendix.systemwideinterfaces.connectionbus.ConnectionBusException: An exception has occurred for the following request(s):                 OQLTextGetRequest (depth = -1): SELECT *            FROM System.BackgroundJob            WHERE                EndTime < $END_TIME                or StartTime < $START_TIME                 at com.mendix.connectionbus.RequestAnalyzer.doRequest(RequestAnalyzer.java:46)   Caused by: com.mendix.systemwideinterfaces.connectionbus.ConnectionBusException: Exception occurred while retrieving data. (SQL State: S0002, Error Code: 208)                 at com.mendix.connectionbus.connections.jdbc.JDBCDataStore.getCorrectException(JDBCDataStore.java:1203)   Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Invalid object name 'system$backgroundjob'.                 at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:217)                 at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1635)                 at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(SQLServerPreparedStatement.java:426)                 at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PrepStmtExecCmd.doExecute(SQLServerPreparedStatement.java:372)                 at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:6276)                 at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1793)                 at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:184)                 at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:159)                 at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.executeQuery(SQLServerPreparedStatement.java:284)                 at org.apache.commons.dbcp2.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:83)                 at org.apache.commons.dbcp2.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:83)                 at com.mendix.connectionbus.connections.jdbc.JDBCDataStore.execRetrieveQuery(JDBCDataStore.java:297)                 at com.mendix.connectionbus.connections.jdbc.JDBCDataStore.execRetrieveQueries(JDBCDataStore.java:198)                 at com.mendix.connectionbus.connections.jdbc.JDBCDataStore.retrieve(JDBCDataStore.java:163)                 at com.mendix.connectionbus.connections.jdbc.JDBCDataStore.retrieve(JDBCDataStore.java:152)                 at com.mendix.connectionbus.retrieve.DataStoreCaller.executeQueries(DataStoreCaller.java:229)                 at com.mendix.connectionbus.retrieve.DataStoreCaller.executeQueries(DataStoreCaller.java:196)                 at com.mendix.connectionbus.retrieve.DataStoreCaller.getResult(DataStoreCaller.java:78)                 at com.mendix.connectionbus.retrieve.GetRequestHandler.doRequest(GetRequestHandler.java:64)                 at com.mendix.connectionbus.RequestAnalyzer.doRequest(RequestAnalyzer.java:41)                 at com.mendix.connectionbus.ConnectionBusImpl.doRequest(ConnectionBusImpl.java:459)                 at com.mendix.core.action.user.RetrieveOQLDataTableAction.executeAction(RetrieveOQLDataTableAction.java:92)                 at com.mendix.core.action.user.RetrieveOQLDataTableAction.executeAction(RetrieveOQLDataTableAction.java:17)                 at com.mendix.systemwideinterfaces.core.UserAction.execute(UserAction.java:49)                 at com.mendix.core.actionmanagement.CoreAction.doCall(CoreAction.java:260)                 at com.mendix.core.actionmanagement.CoreAction.call(CoreAction.java:248)                 at com.mendix.core.actionmanagement.CustomActionMonitorImpl$$anonfun$run$1.apply(CustomMonitoredAction.scala:14)                 at com.mendix.core.session.Worker$$anonfun$receive$3$$anonfun$2$$anon$1.execute(ActionDispatching.scala:143)                 at com.mendix.util.classloading.Runner.doRunUsingClassLoaderOf(Runner.java:36)                 at com.mendix.core.session.Worker$$anonfun$receive$3$$anonfun$2.apply(ActionDispatching.scala:145)                 at scala.util.Try$.apply(Try.scala:192)                 at com.mendix.core.session.Worker$$anonfun$receive$3.applyOrElse(ActionDispatching.scala:139)                 at akka.actor.Actor$class.aroundReceive(Actor.scala:465)                 at com.mendix.core.session.Worker.aroundReceive(ActionDispatching.scala:135)                 at akka.actor.ActorCell.receiveMessage(ActorCell.scala:516)                 at akka.actor.ActorCell.invoke(ActorCell.scala:487)                 at akka.dispatch.Mailbox.processMailbox(Mailbox.scala:238)                 at akka.dispatch.Mailbox.run(Mailbox.scala:220)                 at akka.dispatch.ForkJoinExecutorConfigurator$AkkaForkJoinTask.exec(AbstractDispatcher.scala:393)                 at scala.concurrent.forkjoin.ForkJoinTask.doExec(ForkJoinTask.java:260)                 at scala.concurrent.forkjoin.ForkJoinPool$WorkQueue.runTask(ForkJoinPool.java:1339)                 at scala.concurrent.forkjoin.ForkJoinPool.runWorker(ForkJoinPool.java:1979)                 at scala.concurrent.forkjoin.ForkJoinWorkerThread.run(ForkJoinWorkerThread.java:107)
asked
4 answers
0

Table system$backgroundjob  not created? Can you create it by hand? Create an empty SQL server database from Mendix and script the tables to create-scripts.

answered
0

Did you also try to migrate in one go? So from Mx4 straight to Mx6.

Regards,

Ronald

 

answered
0

@Chris 

The table already exists in the SQL-Database in the Mendix 6 version, but it is empty. But when I look at the database which is used in the Production environment (Mendix 4.7.2) and the database after migrating to Mendix 5.21.5, I found out that this table doesn't exists in these databases, See screens:

System tables after migrating to Mendix 6

 

System tables after migrating to Mendix 5

System tables on production Mendix 4

answered
0

Today I have the same error as Maik. Strange because I did the exact same proces yesterday and then I had no problems with that database. Even more I have done this proces the last couple of week several times without problems. I thnk this is a bug in the migration proces. Now only how to reproduce this consistently.

Regards,

Ronald

 

answered