exception in retrieve list from database

0
Hi, one of our microflows, is loading a list of objects from the database in order to cleanup the table if any dirty data is still there. We get the following error: The activity is a simple retrieve from database, with no xpath restrictions (basically get the whole table). The odd bit is that it's only failing on the client server, running under windows service. ################## java.util.concurrent.ExecutionException: la: n: An exception has occurred for the following request(s): fu (depth = 0): //PipsAndSubbies.MendixExtract at PipsAndSubbies.excelImportImportJob (Retrieve : 'Retrieve list of MendixExtract from database') at PipsAndSubbies.jobreadFile (SubMicroflow : 'Call 'excelImport_ImportJob'') Advanced stacktrace: at java.util.concurrent.FutureTask$Sync.innerGet(Unknown Source) at java.util.concurrent.FutureTask.get(Unknown Source) at gy.a(SourceFile:95) at gy.execute(SourceFile:69) at iW.a(SourceFile:304) at com.mendix.externalinterface.connector.RequestDispatching$Worker.a(SourceFile:148) at com.mendix.externalinterface.connector.RequestDispatching$Worker$a.a(SourceFile:140) at com.mendix.externalinterface.connector.RequestDispatching$Worker$a.apply(SourceFile:138) at akka.actor.Actor$class.apply(Actor.scala:545) at com.mendix.externalinterface.connector.RequestDispatching$Worker.apply(SourceFile:134) at akka.actor.LocalActorRef.invoke(ActorRef.scala:910) at akka.dispatch.MessageInvocation.invoke(MessageHandling.scala:25) at akka.dispatch.ExecutableMailbox$class.processMailbox(ExecutorBasedEventDrivenDispatcher.scala:223) at akka.dispatch.ExecutorBasedEventDrivenDispatcher$$anon$4.processMailbox(ExecutorBasedEventDrivenDispatcher.scala:123) at akka.dispatch.ExecutableMailbox$class.run(ExecutorBasedEventDrivenDispatcher.scala:195) at akka.dispatch.ExecutorBasedEventDrivenDispatcher$$anon$4.run(ExecutorBasedEventDrivenDispatcher.scala:123) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source) at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) at java.lang.Thread.run(Unknown Source) at akka.dispatch.MonitorableThread.run(ThreadPoolBuilder.scala:192) Caused by: la: n: An exception has occurred for the following request(s): fu (depth = 0): //PipsAndSubbies.MendixExtract at PipsAndSubbies.excelImportImportJob (Retrieve : 'Retrieve list of MendixExtract from database') at PipsAndSubbies.jobreadFile (SubMicroflow : 'Call 'excelImport_ImportJob'') Advanced stacktrace: at mg.a(SourceFile:188) Caused by: com.mendix.core.CoreRuntimeException: n: An exception has occurred for the following request(s): fu (depth = 0): //PipsAndSubbies.MendixExtract at hC.b(SourceFile:194) Caused by: n: An exception has occurred for the following request(s): fu (depth = 0): //PipsAndSubbies.MendixExtract at x.a(SourceFile:57) Caused by: java.lang.IllegalArgumentException: Entity id should be not zero at ih.a(SourceFile:1494) at ie.b(SourceFile:99) at ie.<init>(SourceFile:89) at com.mendix.core.Core.createMendixIdentifier(SourceFile:1906) at p.a(SourceFile:106) at r.a(SourceFile:77) at q.a(SourceFile) at aU.f(SourceFile:456) at dJ.a(SourceFile:119) at dA.a(SourceFile:89) at dE.a(SourceFile:68) at x.a(SourceFile:43) at h.a(SourceFile:269) at hu.b(SourceFile:126) at hu.a(SourceFile:67) at hq.a(SourceFile:61) at hq.executeAction(SourceFile:21) at com.mendix.systemwideinterfaces.core.UserAction.execute(SourceFile:57) at com.mendix.core.actionmanagement.CoreAction.call(SourceFile:457) at hC.b(SourceFile:183) at com.mendix.core.Core.retrieveXPathQuery(SourceFile:1043) at lI.b(SourceFile:130) at lI.a(SourceFile:84) at mg.a(SourceFile:73) at mf.executeAction(SourceFile:101) at com.mendix.systemwideinterfaces.core.UserAction.execute(SourceFile:57) at com.mendix.core.actionmanagement.CoreAction.call(SourceFile:457) at hC.b(SourceFile:183) at com.mendix.core.Core.executeSync(SourceFile:196) at li.a(SourceFile:70) at mg.a(SourceFile:73) at mf.executeAction(SourceFile:101) at com.mendix.systemwideinterfaces.core.UserAction.execute(SourceFile:57) at com.mendix.core.actionmanagement.CoreAction.call(SourceFile:457) at java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source) at java.util.concurrent.FutureTask.run(Unknown Source) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source) at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) at java.lang.Thread.run(Unknown Source)
asked
2 answers
2

From the stack trace you can see that you're trying to do something on an object that is not available:

"Caused by: n: An exception has occurred for the following request(s): fu (depth = 0): //PipsAndSubbies.MendixExtract at x.a(SourceFile:57) Caused by: java.lang.IllegalArgumentException: Entity id should be not zero"

Could it be that there is a difference in the data available for the client and locally?

answered
1

The entity id is is an identifier for each entity (not the entity's instances!) that is kept in a separate table. If this entity is 0 it might mean your database is corrupt for that entity. This is a state that normally only happens if someone changes the database structure manually. Or it could be some obscure bug, but considering the same model runs fine on your own server I think this is probably not the case here.

answered