-1

Hi Guys i am having an issue with the Mendix excel export java action, i followed this guide to set up a test export: https://world.mendix.com/display/howto50/Using+the+Excel+Exporter however i get an error when i try to export, from the stacktrace it looks as if the data isnt being queried, if anyone experienced a similar issue, please explain the cause to me. Here is what my stack trace looks like. Thank you: com.mendix.modules.microflowengine.MicroflowException: com.mendix.core.CoreRuntimeException: com.mendix.systemwideinterfaces.MendixRuntimeException: com.mendix.core.CoreRuntimeException: com.mendix.systemwideinterfaces.MendixRuntimeException: com.mendix.connectionbus.ConnectionBusRuntimeException: An exception has occurred for the following request(s): OQLTextGetRequest (depth = -1): SELECT a8014df95.UniqueId AS UniqueId0, a8014df95.AssessmentType AS AssessmentType0, a8014df95.StartDate AS StartDate0, a8014df95.EndDate AS EndDate0, a8014df95.InputNotes AS InputNotes0, a8014df95.Status AS Status0, a8014df95.AllAreas AS AllAreas0, a8014df95.MultipleAssessors AS MultipleAssessors0, a8014df95.Scope AS Scope0 FROM TransactionalData."Assessment" AS a8014df95 INNER JOIN a8014df95/TransactionalData.Assessment_TestReport/TransactionalData."TestReport" AS refobject ON refobject/ID = 77124143618719947 ORDER BY a8014df95.AllAreas ASC; at XLSReport.GenerateReport (JavaAction : 'GenerateExcelDoc') Advanced stacktrace: at com.mendix.modules.microflowengine.MicroflowUtil.processException(MicroflowUtil.java:143) Caused by: com.mendix.core.CoreException: com.mendix.core.CoreRuntimeException: com.mendix.systemwideinterfaces.MendixRuntimeException: com.mendix.core.CoreRuntimeException: com.mendix.systemwideinterfaces.MendixRuntimeException: com.mendix.connectionbus.ConnectionBusRuntimeException: An exception has occurred for the following request(s): OQLTextGetRequest (depth = -1): SELECT a8014df95.UniqueId AS UniqueId0, a8014df95.AssessmentType AS AssessmentType0, a8014df95.StartDate AS StartDate0, a8014df95.EndDate AS EndDate0, a8014df95.InputNotes AS InputNotes0, a8014df95.Status AS Status0, a8014df95.AllAreas AS AllAreas0, a8014df95.MultipleAssessors AS MultipleAssessors0, a8014df95.Scope AS Scope0 FROM TransactionalData."Assessment" AS a8014df95 INNER JOIN a8014df95/TransactionalData.Assessment_TestReport/TransactionalData."TestReport" AS refobject ON refobject/ID = 77124143618719947 ORDER BY a8014df95.AllAreas ASC; at com.mendix.core.component.InternalCore.execute(InternalCore.java:394) Caused by: com.mendix.core.CoreRuntimeException: com.mendix.systemwideinterfaces.MendixRuntimeException: com.mendix.core.CoreRuntimeException: com.mendix.systemwideinterfaces.MendixRuntimeException: com.mendix.connectionbus.ConnectionBusRuntimeException: An exception has occurred for the following request(s): OQLTextGetRequest (depth = -1): SELECT a8014df95.UniqueId AS UniqueId0, a8014df95.AssessmentType AS AssessmentType0, a8014df95.StartDate AS StartDate0, a8014df95.EndDate AS EndDate0, a8014df95.InputNotes AS InputNotes0, a8014df95.Status AS Status0, a8014df95.AllAreas AS AllAreas0, a8014df95.MultipleAssessors AS MultipleAssessors0, a8014df95.Scope AS Scope0 FROM TransactionalData."Assessment" AS a8014df95 INNER JOIN a8014df95/TransactionalData.Assessment_TestReport/TransactionalData."TestReport" AS refobject ON refobject/ID = 77124143618719947 ORDER BY a8014df95.AllAreas ASC; at com.mendix.core.actionmanagement.ActionManager.executeSync(ActionManager.java:198) Caused by: com.mendix.systemwideinterfaces.MendixRuntimeException: com.mendix.core.CoreRuntimeException: com.mendix.systemwideinterfaces.MendixRuntimeException: com.mendix.connectionbus.ConnectionBusRuntimeException: An exception has occurred for the following request(s): OQLTextGetRequest (depth = -1): SELECT a8014df95.UniqueId AS UniqueId0, a8014df95.AssessmentType AS AssessmentType0, a8014df95.StartDate AS StartDate0, a8014df95.EndDate AS EndDate0, a8014df95.InputNotes AS InputNotes0, a8014df95.Status AS Status0, a8014df95.AllAreas AS AllAreas0, a8014df95.MultipleAssessors AS MultipleAssessors0, a8014df95.Scope AS Scope0 FROM TransactionalData."Assessment" AS a8014df95 INNER JOIN a8014df95/TransactionalData.Assessment_TestReport/TransactionalData."TestReport" AS refobject ON refobject/ID = 77124143618719947 ORDER BY a8014df95.AllAreas ASC; at com.mendix.util.classloading.Runner.doRunUsingClassLoaderOf(Runner.java:36) Caused by: com.mendix.core.CoreRuntimeException: com.mendix.systemwideinterfaces.MendixRuntimeException: com.mendix.connectionbus.ConnectionBusRuntimeException: An exception has occurred for the following request(s): OQLTextGetRequest (depth = -1): SELECT a8014df95.UniqueId AS UniqueId0, a8014df95.AssessmentType AS AssessmentType0, a8014df95.StartDate AS StartDate0, a8014df95.EndDate AS EndDate0, a8014df95.InputNotes AS InputNotes0, a8014df95.Status AS Status0, a8014df95.AllAreas AS AllAreas0, a8014df95.MultipleAssessors AS MultipleAssessors0, a8014df95.Scope AS Scope0 FROM TransactionalData."Assessment" AS a8014df95 INNER JOIN a8014df95/TransactionalData.Assessment_TestReport/TransactionalData."TestReport" AS refobject ON refobject/ID = 77124143618719947 ORDER BY a8014df95.AllAreas ASC; at com.mendix.core.actionmanagement.ActionManager.executeSync(ActionManager.java:198) Caused by: com.mendix.systemwideinterfaces.MendixRuntimeException: com.mendix.connectionbus.ConnectionBusRuntimeException: An exception has occurred for the following request(s): OQLTextGetRequest (depth = -1): SELECT a8014df95.UniqueId AS UniqueId0, a8014df95.AssessmentType AS AssessmentType0, a8014df95.StartDate AS StartDate0, a8014df95.EndDate AS EndDate0, a8014df95.InputNotes AS InputNotes0, a8014df95.Status AS Status0, a8014df95.AllAreas AS AllAreas0, a8014df95.MultipleAssessors AS MultipleAssessors0, a8014df95.Scope AS Scope0 FROM TransactionalData."Assessment" AS a8014df95 INNER JOIN a8014df95/TransactionalData.Assessment_TestReport/TransactionalData."TestReport" AS refobject ON refobject/ID = 77124143618719947 ORDER BY a8014df95.AllAreas ASC; at com.mendix.util.classloading.Runner.doRunUsingClassLoaderOf(Runner.java:36) Caused by: com.mendix.connectionbus.ConnectionBusRuntimeException: An exception has occurred for the following request(s): OQLTextGetRequest (depth = -1): SELECT a8014df95.UniqueId AS UniqueId0, a8014df95.AssessmentType AS AssessmentType0, a8014df95.StartDate AS StartDate0, a8014df95.EndDate AS EndDate0, a8014df95.InputNotes AS InputNotes0, a8014df95.Status AS Status0, a8014df95.AllAreas AS AllAreas0, a8014df95.MultipleAssessors AS MultipleAssessors0, a8014df95.Scope AS Scope0 FROM TransactionalData."Assessment" AS a8014df95 INNER JOIN a8014df95/TransactionalData.Assessment_TestReport/TransactionalData."TestReport" AS refobject ON refobject/ID = 77124143618719947 ORDER BY a8014df95.AllAreas ASC; at com.mendix.connectionbus.RequestAnalyzer.doRequest(RequestAnalyzer.java:59) Caused by: com.mendix.connectionbus.ConnectionBusRuntimeException: There isn't a meta association with name 'TransactionalData.AssessmentTestReport' of meta object 'TransactionalData.Assessment'., exception occurred on mapping the following query: SELECT a8014df95.UniqueId AS UniqueId0, a8014df95.AssessmentType AS AssessmentType0, a8014df95.StartDate AS StartDate0, a8014df95.EndDate AS EndDate0, a8014df95.InputNotes AS InputNotes0, a8014df95.Status AS Status0, a8014df95.AllAreas AS AllAreas0, a8014df95.MultipleAssessors AS MultipleAssessors0, a8014df95.Scope AS Scope0 FROM transactionaldata$assessment AS a8014df95 INNER JOIN a8014df95/TransactionalData.AssessmentTestReport/TransactionalData.TestReport AS refobject ON refobject.id = 77124143618719947 ORDER BY a8014df95.allareas AS AllAreas0 ASC at com.mendix.connectionbus.retrieve.query.mapping.QueryMapper.getMappedQueries(QueryMapper.java:265) Caused by: com.mendix.connectionbus.ConnectionBusRuntimeException: There isn't a meta association with name 'TransactionalData.Assessment_TestReport' of meta object 'TransactionalData.Assessment'. at com.mendix.connectionbus.retrieve.query.mapping.QueryFromLocationsMapper.getAssociationMapper(QueryFromLocationsMapper.java:313) at com.mendix.connectionbus.retrieve.query.mapping.QueryFromLocationsMapper.getAssociationMapper(QueryFromLocationsMapper.java:306) at com.mendix.connectionbus.retrieve.query.mapping.QueryFromLocationsMapper.handleLocationStep(QueryFromLocationsMapper.java:183) at com.mendix.connectionbus.retrieve.query.mapping.QueryFromLocationsMapper.mapJoinElement(QueryFromLocationsMapper.java:123) at com.mendix.connectionbus.retrieve.query.mapping.QueryFromLocationsMapper.mapJoinClauseLocations(QueryFromLocationsMapper.java:86) at com.mendix.connectionbus.retrieve.query.mapping.QueryFromLocationsMapper.mapQueryFromLocations(QueryFromLocationsMapper.java:43) at com.mendix.connectionbus.retrieve.query.mapping.QueryMapper.getMappedQueries(QueryMapper.java:248) at com.mendix.connectionbus.retrieve.query.mapping.QueryMapper.getQueryInstances(QueryMapper.java:128) at com.mendix.connectionbus.retrieve.DataStoreCaller.mapToQueryInstances(DataStoreCaller.java:87) at com.mendix.connectionbus.retrieve.DataStoreCaller.getResult(DataStoreCaller.java:60) at com.mendix.connectionbus.retrieve.GetRequestHandler.doRequest(GetRequestHandler.java:73) at com.mendix.connectionbus.RequestAnalyzer.doRequest(RequestAnalyzer.java:45) at com.mendix.connectionbus.ConnectionBusImpl.doRequest(ConnectionBusImpl.java:391) 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.ActionManager$1.execute(ActionManager.java:188) at com.mendix.util.classloading.Runner.doRunUsingClassLoaderOf(Runner.java:32) at com.mendix.core.actionmanagement.ActionManager.executeSync(ActionManager.java:194) at com.mendix.core.component.InternalCore.retrieveOQLDataTable(InternalCore.java:1009) at com.mendix.core.Core.retrieveOQLDataTable(Core.java:963) at xlsreport.report.DataOQL.getRowData(DataOQL.java:89) at xlsreport.actions.GenerateExcelDoc.executeAction(GenerateExcelDoc.java:166) at xlsreport.actions.GenerateExcelDoc.executeAction(GenerateExcelDoc.java:36) 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.ActionManager$1.execute(ActionManager.java:188) at com.mendix.util.classloading.Runner.doRunUsingClassLoaderOf(Runner.java:32) at com.mendix.core.actionmanagement.ActionManager.executeSync(ActionManager.java:194) at com.mendix.core.component.InternalCore.execute(InternalCore.java:386) at com.mendix.modules.microflowengine.actions.actioncall.JavaAction.execute(JavaAction.scala:52) at com.mendix.modules.microflowengine.microflow.impl.MicroflowObject.execute(MicroflowObject.java:47) at com.mendix.modules.microflowengine.microflow.impl.MicroflowImpl.executeAfterBreakingIfNecessary(MicroflowImpl.java:192) at com.mendix.modules.microflowengine.microflow.impl.MicroflowImpl.executeAction(MicroflowImpl.java:149) 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.ActionManager$1.execute(ActionManager.java:188) at com.mendix.util.classloading.Runner.doRunUsingClassLoaderOf(Runner.java:32) at com.mendix.core.actionmanagement.ActionManager.executeSync(ActionManager.java:194) at com.mendix.core.component.InternalCore.execute(InternalCore.java:386) at com.mendix.webui.actions.client.ExecuteAction.execute(ExecuteAction.java:135) at com.mendix.webui.requesthandling.ClientRequestHandler$$anonfun$handleRequest$1.apply$mcV$sp(ClientRequestHandler.scala:322) at com.mendix.webui.requesthandling.ClientRequestHandler$$anonfun$handleRequest$1.apply(ClientRequestHandler.scala:315) at com.mendix.webui.requesthandling.ClientRequestHandler$$anonfun$handleRequest$1.apply(ClientRequestHandler.scala:315) at com.mendix.core.session.Worker$$anonfun$receive$3$$anonfun$2$$anon$1.execute(ActionDispatching.scala:145) at com.mendix.util.classloading.Runner.doRunUsingClassLoaderOf(Runner.java:32) at com.mendix.core.session.Worker$$anonfun$receive$3$$anonfun$2.apply(ActionDispatching.scala:147) at scala.util.Try$.apply(Try.scala:191) at com.mendix.core.session.Worker$$anonfun$receive$3.applyOrElse(ActionDispatching.scala:141) at akka.actor.Actor$class.aroundReceive(Actor.scala:465) at com.mendix.core.session.Worker.aroundReceive(ActionDispatching.scala:137) 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 2016-03-17

1 answers