restoring postgres DB from cloud locally - error

0
Hi guys, I keep getting this error when restoring cloud backup DB locally, no matter what application is from. I realised some references/license detail could create an issue, but this restore used to be straight forward in earlier versions of both Postgres and Mendix modeler. The only way to get the app to work with the restore is to truncate languages and users tables. Obviously this cannot' be the way to bypass this.  Are there any known fixes to get a full restore of the DB and get the app to run correctly (locally)?   After restoring the DB, I run the app and get the following (and this is verified in a different number of apps, in different versions, e.g. 5.9.1, 5.20, 610.3) :   Request action: start Message: Starting Mendix Runtime failed. Cause: com.mendix.core.CoreRuntimeException: Exception occurred in action '{"amount":-1,"sort":{},"offset":-1,"type":"RetrieveXPathAction","depth":0,"xpath":"//System.Language"}', all database changes executed by this action were rolled back Stack trace: com.mendix.m2ee.api.AdminException: Starting Mendix Runtime failed.     at com.mendix.core.impl.MxRuntimeImpl.fireZeeMissile(SourceFile:436) Caused by: com.mendix.core.CoreRuntimeException: com.mendix.core.CoreRuntimeException: Exception occurred in action '{"amount":-1,"sort":{},"offset":-1,"type":"RetrieveXPathAction","depth":0,"xpath":"//System.Language"}', all database changes executed by this action were rolled back     at com.mendix.core.actionmanagement.ActionManager.executeSync(SourceFile:210) Caused by: com.mendix.core.CoreRuntimeException: Exception occurred in action '{"amount":-1,"sort":{},"offset":-1,"type":"RetrieveXPathAction","depth":0,"xpath":"//System.Language"}', all database changes executed by this action were rolled back     at com.mendix.core.actionmanagement.CoreAction.processErrorState(SourceFile:343) Caused by: java.lang.IllegalArgumentException: The current id belongs to another object type than the given type to set. Type of this MendixObject is 'System.Language', the given id is of type 'Triage.Patient'     at com.mendix.core.objectmanagement.MendixObjectImpl.setId(SourceFile:357)     at com.mendix.core.objectmanagement.SchemeManagerImpl.getInstance(SourceFile:968)     at com.mendix.core.action.user.RetrieveXPathAction.executeAction(SourceFile:58)     at com.mendix.core.action.user.RetrieveXPathAction.executeAction(SourceFile:17)     at com.mendix.systemwideinterfaces.core.UserAction.execute(SourceFile:53)     at com.mendix.core.actionmanagement.CoreAction.doCall(SourceFile:291)     at com.mendix.core.actionmanagement.CoreAction.call(SourceFile:276)     at com.mendix.core.actionmanagement.CustomActionMonitorImpl$$anonfun$run$1.apply(SourceFile:17)     at com.mendix.core.session.Worker$$anonfun$receive$3$$anonfun$2$$anon$1.execute(SourceFile:158)     at com.mendix.util.classloading.Runner.doRunUsingClassLoaderOf(SourceFile:36)     at com.mendix.core.session.Worker$$anonfun$receive$3$$anonfun$2.apply(SourceFile:160)     at scala.util.Try$.apply(Try.scala:191)     at com.mendix.core.session.Worker$$anonfun$receive$3.applyOrElse(SourceFile:154)     at akka.actor.Actor$class.aroundReceive(Actor.scala:465)     at com.mendix.core.session.Worker.aroundReceive(SourceFile:147)     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)       LR.
asked
3 answers
0

Have you tried removing your local database, creating the database and then do a restore?

Caused by: java.lang.IllegalArgumentException: The current id belongs to another object type than the given type to set. Type of this MendixObject is 'System.Language', the given id is of type 'Triage.Patient'

This message has me thinking the structure of your local database is not in sync with the one you are trying to restore.

answered
0

Looking at your error it seems you restored a database on top of existing data - all MendixIdentifiers are unique and relate back to an entity type. You should recreate the database and import afterwards.

answered
0

This problem also occurred in my application.
Check your language settings.

  1. Your computer timezone
  2. Mendix Settings:

answered