Java error using XLSReport

0
I want to export a TSV file to deliver to an ETL service but the XLSReport seems to have it against me. I´m really not sure what this error is going to tell me. I have no constraints, only one reference on Inner Join. I have double checked at the app store and all the code should be downloaded. If someone can help me decode this stack trace that would be great. Regards, Derk-Jan An error has occurred while handling the request. [User 'Anonymous_ce423564-b667-41ae-b58c-66de71a1fd09' with session id '53c1052e-9fe7-4604-a562-dbb97822ac8b' and roles 'Administrator'] 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 a74e60f09.productID AS productID0, a331a0b80.newPrice AS newPrice0, a331a0b80.updateTime AS updateTime0 FROM PricingTwoPointO."pricetag" AS a331a0b80 INNER JOIN a331a0b80/PricingTwoPointO.picnicProduct_priceTag/PricingTwoPointO."picnicProduct" AS a74e60f09 ; 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 a74e60f09.productID AS productID0, a331a0b80.newPrice AS newPrice0, a331a0b80.updateTime AS updateTime0 FROM PricingTwoPointO."pricetag" AS a331a0b80 INNER JOIN a331a0b80/PricingTwoPointO.picnicProduct_priceTag/PricingTwoPointO."picnicProduct" AS a74e60f09 ; at com.mendix.core.component.InternalCore.execute(InternalCore.java:391) 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 a74e60f09.productID AS productID0, a331a0b80.newPrice AS newPrice0, a331a0b80.updateTime AS updateTime0 FROM PricingTwoPointO."pricetag" AS a331a0b80 INNER JOIN a331a0b80/PricingTwoPointO.picnicProduct_priceTag/PricingTwoPointO."picnicProduct" AS a74e60f09 ; at com.mendix.core.actionmanagement.ActionManager.executeSync(ActionManager.java:178) 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 a74e60f09.productID AS productID0, a331a0b80.newPrice AS newPrice0, a331a0b80.updateTime AS updateTime0 FROM PricingTwoPointO."pricetag" AS a331a0b80 INNER JOIN a331a0b80/PricingTwoPointO.picnicProduct_priceTag/PricingTwoPointO."picnicProduct" AS a74e60f09 ; 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 a74e60f09.productID AS productID0, a331a0b80.newPrice AS newPrice0, a331a0b80.updateTime AS updateTime0 FROM PricingTwoPointO."pricetag" AS a331a0b80 INNER JOIN a331a0b80/PricingTwoPointO.picnicProduct_priceTag/PricingTwoPointO."picnicProduct" AS a74e60f09 ; at com.mendix.core.actionmanagement.ActionManager.executeSync(ActionManager.java:178) Caused by: com.mendix.systemwideinterfaces.MendixRuntimeException: com.mendix.connectionbus.ConnectionBusRuntimeException: An exception has occurred for the following request(s): OQLTextGetRequest (depth = -1): SELECT a74e60f09.productID AS productID0, a331a0b80.newPrice AS newPrice0, a331a0b80.updateTime AS updateTime0 FROM PricingTwoPointO."pricetag" AS a331a0b80 INNER JOIN a331a0b80/PricingTwoPointO.picnicProduct_priceTag/PricingTwoPointO."picnicProduct" AS a74e60f09 ; 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 a74e60f09.productID AS productID0, a331a0b80.newPrice AS newPrice0, a331a0b80.updateTime AS updateTime0 FROM PricingTwoPointO."pricetag" AS a331a0b80 INNER JOIN a331a0b80/PricingTwoPointO.picnicProduct_priceTag/PricingTwoPointO."picnicProduct" AS a74e60f09 ; at com.mendix.connectionbus.RequestAnalyzer.doRequest(RequestAnalyzer.java:53) Caused by: com.mendix.connectionbus.ConnectionBusRuntimeException: Object 'PricingTwoPointO.pricetag' doesn't contain column 'newPrice', exception occurred on mapping the following query: SELECT a74e60f09.productID AS productID0, a331a0b80.newPrice AS newPrice0, a331a0b80.updateTime AS updateTime0 FROM PricingTwoPointO.pricetag AS a331a0b80 INNER JOIN a331a0b80/PricingTwoPointO.picnicProduct_priceTag/PricingTwoPointO.picnicProduct AS a74e60f09 at com.mendix.connectionbus.retrieve.query.mapping.QueryMapper.getMappedQueries(QueryMapper.java:259) Caused by: com.mendix.connectionbus.ConnectionBusRuntimeException: Object 'PricingTwoPointO.pricetag' doesn't contain column 'newPrice' at com.mendix.connectionbus.retrieve.query.mapping.SelectColumnsMapper.getColumnLocation(SelectColumnsMapper.java:353) at com.mendix.connectionbus.retrieve.query.mapping.SelectColumnsMapper.handleDoubleLocationSelectColumn(SelectColumnsMapper.java:251) at com.mendix.connectionbus.retrieve.query.mapping.SelectColumnsMapper.handleLocationSelectColumn(SelectColumnsMapper.java:167) at com.mendix.connectionbus.retrieve.query.mapping.SelectColumnsMapper.handleColumn(SelectColumnsMapper.java:102) at com.mendix.connectionbus.retrieve.query.mapping.SelectColumnsMapper.mapSelectColumns(SelectColumnsMapper.java:69) at com.mendix.connectionbus.retrieve.query.mapping.QueryMapper.mapSelectColumns(QueryMapper.java:698) at com.mendix.connectionbus.retrieve.query.mapping.QueryMapper.getMappedQueries(QueryMapper.java:230) at com.mendix.connectionbus.retrieve.query.mapping.QueryMapper.getQueryInstances(QueryMapper.java:128) at com.mendix.connectionbus.retrieve.DataStoreCaller.doOldQueryHandling(DataStoreCaller.java:101) at com.mendix.connectionbus.retrieve.DataStoreCaller.mapToQueryInstances(DataStoreCaller.java:148) at com.mendix.connectionbus.retrieve.DataStoreCaller.getResult(DataStoreCaller.java:77) at com.mendix.connectionbus.retrieve.GetRequestHandler.doRequest(GetRequestHandler.java:62) 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.ActionManager$1.execute(ActionManager.java:168) at com.mendix.util.classloading.Runner.doRunUsingClassLoaderOf(Runner.java:32) at com.mendix.core.actionmanagement.ActionManager.executeSync(ActionManager.java:174) at com.mendix.core.component.InternalCore.retrieveOQLDataTable(InternalCore.java:1012) at com.mendix.core.Core.retrieveOQLDataTable(Core.java:909) at xlsreport.report.DataOQL.getRowData(DataOQL.java:89) at xlsreport.actions.GenerateExcelDoc.executeAction(GenerateExcelDoc.java:163) at xlsreport.actions.GenerateExcelDoc.executeAction(GenerateExcelDoc.java:33) 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:168) at com.mendix.util.classloading.Runner.doRunUsingClassLoaderOf(Runner.java:32) at com.mendix.core.actionmanagement.ActionManager.executeSync(ActionManager.java:174) at com.mendix.core.component.InternalCore.execute(InternalCore.java:383) 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:168) at com.mendix.util.classloading.Runner.doRunUsingClassLoaderOf(Runner.java:32) at com.mendix.core.actionmanagement.ActionManager.executeSync(ActionManager.java:174) at com.mendix.core.component.InternalCore.execute(InternalCore.java:383) 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:317) at com.mendix.webui.requesthandling.ClientRequestHandler$$anonfun$handleRequest$1.apply(ClientRequestHandler.scala:312) at com.mendix.webui.requesthandling.ClientRequestHandler$$anonfun$handleRequest$1.apply(ClientRequestHandler.scala:312) at com.mendix.core.session.Worker$$anonfun$receive$3$$anonfun$2$$anon$1.execute(ActionDispatching.scala:144) at com.mendix.util.classloading.Runner.doRunUsingClassLoaderOf(Runner.java:32) at com.mendix.core.session.Worker$$anonfun$receive$3$$anonfun$2.apply(ActionDispatching.scala:146) at scala.util.Try$.apply(Try.scala:192) at com.mendix.core.session.Worker$$anonfun$receive$3.applyOrElse(ActionDispatching.scala:140) at akka.actor.Actor$class.aroundReceive(Actor.scala:465) at com.mendix.core.session.Worker.aroundReceive(ActionDispatching.scala:136) 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
1 answers
3

The key error is this line:

Object 'PricingTwoPointO.pricetag' doesn't contain column 'newPrice'

Does that make sense in context of your application?

answered