Excel Exporter Error - MxCellStyle Issue

0
Hello I've managed to import the excel exporter module and have configured it in line with the following post (https://community.mendix.com/link/questions/7790). The problem I'm experiencing now is the following error...anyone got any ideas?: 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):      InternalXPathTextGetRequest (depth = 0): //XLSreport.MxCellStyle[XLSReport.MxCellStyle_Template='26740122787512521']     at ResourcelinkAdmin.IVK_Download_NGA_Operators (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):      InternalXPathTextGetRequest (depth = 0): //XLSreport.MxCellStyle[XLSReport.MxCellStyle_Template='26740122787512521']     at com.mendix.basis.component.InternalCore.execute(InternalCore.java:535) 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):      InternalXPathTextGetRequest (depth = 0): //XLSreport.MxCellStyle[XLSReport.MxCellStyle_Template='26740122787512521']     at com.mendix.basis.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):      InternalXPathTextGetRequest (depth = 0): //XLSreport.MxCellStyle[XLSReport.MxCellStyle_Template='26740122787512521']     at com.mendix.util.classloading.Runner.doRunUsingClassLoaderOf(Runner.java:37) Caused by: com.mendix.core.CoreRuntimeException: com.mendix.systemwideinterfaces.MendixRuntimeException: com.mendix.connectionbus.ConnectionBusRuntimeException: An exception has occurred for the following request(s):      InternalXPathTextGetRequest (depth = 0): //XLSreport.MxCellStyle[XLSReport.MxCellStyle_Template='26740122787512521']     at com.mendix.basis.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):      InternalXPathTextGetRequest (depth = 0): //XLSreport.MxCellStyle[XLSReport.MxCellStyle_Template='26740122787512521']     at com.mendix.util.classloading.Runner.doRunUsingClassLoaderOf(Runner.java:37) Caused by: com.mendix.connectionbus.ConnectionBusRuntimeException: An exception has occurred for the following request(s):      InternalXPathTextGetRequest (depth = 0): //XLSreport.MxCellStyle[XLSReport.MxCellStyle_Template='26740122787512521']     at com.mendix.connectionbus.RequestAnalyzer.doRequest(RequestAnalyzer.java:56) Caused by: com.mendix.connectionbus.ConnectionBusRuntimeException: Entity 'XLSreport.MxCellStyle' doesn't contain association 'XLSReport.MxCellStyle_Template'. Entity is used in path 'XLSreport.MxCellStyle'., exception occurred on mapping the following query: SELECT x1XLSreport.MxCellStyle.ID FROM XLSreport.MxCellStyle AS x1XLSreport.MxCellStyle WHERE x1XLSreport.MxCellStyle/XLSReport.MxCellStyle_Template = '26740122787512521', exception occurred on mapping the following query: SELECT XLSreport.MxCellStyle/* FROM XLSreport.MxCellStyle WHERE XLSreport.MxCellStyle.ID IN (SELECT x1XLSreport.MxCellStyle.ID FROM XLSreport.MxCellStyle AS x1XLSreport.MxCellStyle WHERE x1XLSreport.MxCellStyle/XLSReport.MxCellStyle_Template = '26740122787512521')     at com.mendix.connectionbus.retrieve.query.mapping.QueryMapper.getMappedQueries(QueryMapper.java:260) Caused by: com.mendix.connectionbus.ConnectionBusRuntimeException: Entity 'XLSreport.MxCellStyle' doesn't contain association 'XLSReport.MxCellStyle_Template'. Entity is used in path 'XLSreport.MxCellStyle'., exception occurred on mapping the following query: SELECT x1XLSreport.MxCellStyle.ID FROM XLSreport.MxCellStyle AS x1XLSreport.MxCellStyle WHERE x1XLSreport.MxCellStyle/XLSReport.MxCellStyle_Template = '26740122787512521'     at com.mendix.connectionbus.retrieve.query.mapping.QueryMapper.getMappedQueries(QueryMapper.java:260) Caused by: com.mendix.connectionbus.ConnectionBusRuntimeException: Entity 'XLSreport.MxCellStyle' doesn't contain association 'XLSReport.MxCellStyle_Template'. Entity is used in path 'XLSreport.MxCellStyle'.     at com.mendix.connectionbus.retrieve.query.mapping.QueryColumnItemHandler.createAssociationColumnDefinition(QueryColumnItemHandler.java:241)     at com.mendix.connectionbus.retrieve.query.mapping.QueryColumnItemHandler.createColumnDefinition(QueryColumnItemHandler.java:170)     at com.mendix.connectionbus.retrieve.query.mapping.QueryColumnItemHandler.mapSelectorLocation(QueryColumnItemHandler.java:127)     at com.mendix.connectionbus.retrieve.query.mapping.QueryColumnItemHandler.handleQueryWhereTermLocation(QueryColumnItemHandler.java:64)     at com.mendix.connectionbus.retrieve.query.mapping.WhereClauseMapper.prehandleWhereTermSide(WhereClauseMapper.java:236)     at com.mendix.connectionbus.retrieve.query.mapping.WhereClauseMapper.handleWhereTerm(WhereClauseMapper.java:167)     at com.mendix.connectionbus.retrieve.query.mapping.WhereClauseMapper.map(WhereClauseMapper.java:144)     at com.mendix.connectionbus.retrieve.query.mapping.QueryMapper.mapWhereClauseWhereTerms(QueryMapper.java:723)     at com.mendix.connectionbus.retrieve.query.mapping.QueryMapper.getMappedQueries(QueryMapper.java:227)     at com.mendix.connectionbus.retrieve.query.mapping.QueryMapper.getQueryInstances(QueryMapper.java:127)     at com.mendix.connectionbus.retrieve.query.mapping.WhereClauseMapper.handleSubQuery(WhereClauseMapper.java:1118)     at com.mendix.connectionbus.retrieve.query.mapping.WhereClauseMapper.handleSelectColumn(WhereClauseMapper.java:984)     at com.mendix.connectionbus.retrieve.query.mapping.WhereClauseMapper.handleWhereTermSide(WhereClauseMapper.java:593)     at com.mendix.connectionbus.retrieve.query.mapping.WhereClauseMapper.handleWhereTerm(WhereClauseMapper.java:171)     at com.mendix.connectionbus.retrieve.query.mapping.WhereClauseMapper.map(WhereClauseMapper.java:144)     at com.mendix.connectionbus.retrieve.query.mapping.QueryMapper.mapWhereClauseWhereTerms(QueryMapper.java:723)     at com.mendix.connectionbus.retrieve.query.mapping.QueryMapper.getMappedQueries(QueryMapper.java:227)     at com.mendix.connectionbus.retrieve.query.mapping.QueryMapper.getQueryInstances(QueryMapper.java:127)     at com.mendix.connectionbus.retrieve.DataStoreCaller.doOldQueryHandling(DataStoreCaller.java:100)     at com.mendix.connectionbus.retrieve.DataStoreCaller.mapToQueryInstances(DataStoreCaller.java:148)     at com.mendix.connectionbus.retrieve.DataStoreCaller.getResult(DataStoreCaller.java:76)     at com.mendix.connectionbus.retrieve.GetRequestHandler.doRequest(GetRequestHandler.java:69)     at com.mendix.connectionbus.RequestAnalyzer.doRequest(RequestAnalyzer.java:44)     at com.mendix.connectionbus.ConnectionBusImpl.doRequest(ConnectionBusImpl.java:465)     at com.mendix.basis.action.user.RetrieveXPathRawAction.retrieveXPathRaw(RetrieveXPathRawAction.java:123)     at com.mendix.basis.action.user.RetrieveXPathRawAction.executeAction(RetrieveXPathRawAction.java:69)     at com.mendix.basis.action.user.RetrieveXPathAction.executeAction(RetrieveXPathAction.java:49)     at com.mendix.basis.action.user.RetrieveXPathAction.executeAction(RetrieveXPathAction.java:17)     at com.mendix.systemwideinterfaces.core.UserAction.execute(UserAction.java:50)     at com.mendix.basis.actionmanagement.CoreActionHandlerImpl.doCall(CoreActionHandlerImpl.scala:73)     at com.mendix.basis.actionmanagement.CoreActionHandlerImpl.call(CoreActionHandlerImpl.scala:53)     at com.mendix.core.actionmanagement.CoreAction.call(CoreAction.java:51)     at com.mendix.basis.actionmanagement.ActionManager$1.execute(ActionManager.java:170)     at com.mendix.util.classloading.Runner.doRunUsingClassLoaderOf(Runner.java:33)     at com.mendix.basis.actionmanagement.ActionManager.executeSync(ActionManager.java:174)     at com.mendix.basis.component.InternalCore.retrieveXPathQuery(InternalCore.java:1300)     at com.mendix.basis.component.InternalCore.retrieveXPathQuery(InternalCore.java:1266)     at com.mendix.core.Core.retrieveXPathQuery(Core.java:707)     at com.mendix.core.Core.retrieveXPathQuery(Core.java:823)     at xlsreport.report.Styling.setAllStyles(Styling.java:87)     at xlsreport.report.export.ExportExcel.<init>(ExportExcel.java:81)     at xlsreport.actions.GenerateExcelDoc.executeAction(GenerateExcelDoc.java:85)     at xlsreport.actions.GenerateExcelDoc.executeAction(GenerateExcelDoc.java:33)     at com.mendix.systemwideinterfaces.core.UserAction.execute(UserAction.java:50)     at com.mendix.basis.actionmanagement.CoreActionHandlerImpl.doCall(CoreActionHandlerImpl.scala:73)     at com.mendix.basis.actionmanagement.CoreActionHandlerImpl.call(CoreActionHandlerImpl.scala:53)     at com.mendix.core.actionmanagement.CoreAction.call(CoreAction.java:51)     at com.mendix.basis.actionmanagement.ActionManager$1.execute(ActionManager.java:170)     at com.mendix.util.classloading.Runner.doRunUsingClassLoaderOf(Runner.java:33)     at com.mendix.basis.actionmanagement.ActionManager.executeSync(ActionManager.java:174)     at com.mendix.basis.component.InternalCore.execute(InternalCore.java:531)     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:200)     at com.mendix.modules.microflowengine.microflow.impl.MicroflowImpl.executeAction(MicroflowImpl.java:157)     at com.mendix.systemwideinterfaces.core.UserAction.execute(UserAction.java:50)     at com.mendix.basis.actionmanagement.CoreActionHandlerImpl.doCall(CoreActionHandlerImpl.scala:73)     at com.mendix.basis.actionmanagement.CoreActionHandlerImpl.call(CoreActionHandlerImpl.scala:53)     at com.mendix.core.actionmanagement.CoreAction.call(CoreAction.java:51)     at com.mendix.basis.actionmanagement.ActionManager$1.execute(ActionManager.java:170)     at com.mendix.util.classloading.Runner.doRunUsingClassLoaderOf(Runner.java:33)     at com.mendix.basis.actionmanagement.ActionManager.executeSync(ActionManager.java:174)     at com.mendix.basis.component.InternalCore.execute(InternalCore.java:531)     at com.mendix.webui.actions.client.ExecuteAction.execute(ExecuteAction.java:143)     at com.mendix.webui.requesthandling.ClientRequestHandler$$anonfun$handleRequest$1.apply$mcV$sp(ClientRequestHandler.scala:308)     at com.mendix.webui.requesthandling.ClientRequestHandler$$anonfun$handleRequest$1.apply(ClientRequestHandler.scala:293)     at com.mendix.webui.requesthandling.ClientRequestHandler$$anonfun$handleRequest$1.apply(ClientRequestHandler.scala:293)     at com.mendix.basis.actionmanagement.IMonitoredAction$$anon$1.execute(IMonitoredAction.scala:47)     at com.mendix.util.classloading.Runner.doRunUsingClassLoaderOf(Runner.java:33)     at com.mendix.basis.actionmanagement.IMonitoredAction$class.monitor(IMonitoredAction.scala:49)     at com.mendix.webui.requesthandling.ClientRequestHandler$ClientMonitoredAction.monitor(ClientRequestHandler.scala:410)     at com.mendix.webui.requesthandling.ClientRequestHandler.handleRequest(ClientRequestHandler.scala:293)     at com.mendix.webui.requesthandling.ClientRequestHandler.handleActionWithSessionRequired(ClientRequestHandler.scala:235)     at com.mendix.webui.requesthandling.ClientRequestHandler.handleAction(ClientRequestHandler.scala:202)     at com.mendix.webui.requesthandling.ClientRequestHandler.liftedTree1$1(ClientRequestHandler.scala:101)     at com.mendix.webui.requesthandling.ClientRequestHandler.processRequest(ClientRequestHandler.scala:93)     at com.mendix.externalinterface.connector.RequestHandler.doProcessRequest(RequestHandler.java:40)     at com.mendix.external.connector.MxRuntimeConnector$1.execute(MxRuntimeConnector.java:70)     at com.mendix.external.connector.MxRuntimeConnector$1.execute(MxRuntimeConnector.java:67)     at com.mendix.util.classloading.Runner.doRunUsingClassLoaderOf(Runner.java:33)     at com.mendix.external.connector.MxRuntimeConnector.processRequest(MxRuntimeConnector.java:73)     at com.mendix.basis.impl.MxRuntimeImpl.processRequest(MxRuntimeImpl.java:885)     at com.mendix.m2ee.appcontainer.server.handler.RuntimeHandler.handle(RuntimeHandler.java:41)     at org.eclipse.jetty.server.handler.HandlerList.handle(HandlerList.java:52)     at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:116)     at org.eclipse.jetty.server.Server.handle(Server.java:368)     at org.eclipse.jetty.server.AbstractHttpConnection.handleRequest(AbstractHttpConnection.java:489)     at org.eclipse.jetty.server.AbstractHttpConnection.content(AbstractHttpConnection.java:953)     at org.eclipse.jetty.server.AbstractHttpConnection$RequestHandler.content(AbstractHttpConnection.java:1014)     at org.eclipse.jetty.http.HttpParser.parseNext(HttpParser.java:861)     at org.eclipse.jetty.http.HttpParser.parseAvailable(HttpParser.java:240)     at org.eclipse.jetty.server.AsyncHttpConnection.handle(AsyncHttpConnection.java:82)     at org.eclipse.jetty.io.nio.SelectChannelEndPoint.handle(SelectChannelEndPoint.java:628)     at org.eclipse.jetty.io.nio.SelectChannelEndPoint$1.run(SelectChannelEndPoint.java:52)     at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:608)     at org.eclipse.jetty.util.thread.QueuedThreadPool$3.run(QueuedThreadPool.java:543)     at java.lang.Thread.run(Thread.java:745)  
asked
2 answers
2

In the styling.java is a line 87

 

        List<IMendixObject> stylesObjects = Core.retrieveXPathQuery(context,"//" + MxCellStyle.getType()
                + "[XLSReport.MxCellStyle_Template='" + TemplateObject.getMendixObject().getId().toLong() + "']");

an improvement is:

        List<IMendixObject> stylesObjects = Core.retrieveXPathQuery(context,"//" + MxCellStyle.getType()
                + "[" + MxCellStyle.MemberNames.MxCellStyle_Template +"='" + TemplateObject.getMendixObject().getId().toLong() + "']");

Maybe this will gives you a java error so you can see something is renamed.

answered
1

My guess is that the module was renamed from XLSReport to XLSreport (with a lower case R )

The module uses fixed naming at the line Chris pointed out, thus it fails there.

answered