We recently moved from 11.0.11 to 11.1.7.
We have a report which only uses database tables, and only data modules (not framework manager).
We have an issue when all 3 pages of the report are included. If we update the report to only have page 1 OR just pages 2,3 then it runs (quite a bit slower than pre-upgrade as well, but that is a separate concern). When we run with all 3 pages of the report we start to see exceptions. I have attached the full log of the session, but below is where the errors are shown.
It seems that the main culprit here is: java.lang.ArrayStoreException
2021-06-09T18:58:02.836+0000 INFO XQE.MDXEngine [Default Executor-thread-4386] Msyyd49wG89wljjMCl2q8MqhvwyyMlG4hlwGjwMd Msyyd49wG89wljjMCl2q8MqhvwyyMlG4hlwGjwMd eae521a8-bb72-45c7-a1fb-5608abed1938 127.0.0.1 44124 NA /datasets/soap query-service 34048 SELECT
ORDER([TBdimension_3].[TBhierarchy_3].[TBlevel_1].MEMBERS, [TBdimension_3].[TBhierarchy_3].CURRENTMEMBER.PROPERTIES("MEMBER_CAPTION"), BASC) DIMENSION PROPERTIES PARENT_LEVEL, PARENT_UNIQUE_NAME ON AXIS(0),
{[Measures].[Measures].[TBmeasure_0], [Measures].[Measures].[TBmeasure_1]} DIMENSION PROPERTIES PARENT_LEVEL, PARENT_UNIQUE_NAME ON AXIS(1)
FROM [/content/folder[@name='Customer1']]/folder[@name='Study2081']]/module[@name='Adverse Event ME 9June2021']]] CELL PROPERTIES CELL_ORDINAL, FORMAT_STRING, VALUE
2021-06-09T18:58:02.839+0000 INFO XQE.ExecutionEnvironmentContext [Default Executor-thread-4386] Msyyd49wG89wljjMCl2q8MqhvwyyMlG4hlwGjwMd Msyyd49wG89wljjMCl2q8MqhvwyyMlG4hlwGjwMd eae521a8-bb72-45c7-a1fb-5608abed1938 127.0.0.1 44124 NA /datasets/soap query-service 34048 Exit ExecutionEnvironmentContext (com.cognos.xqe.query.engine.ExecutionEnvironment@dff4f074).
2021-06-09T18:58:02.839+0000 INFO XQE.ExecutionEnvironmentContext [Default Executor-thread-4386] Msyyd49wG89wljjMCl2q8MqhvwyyMlG4hlwGjwMd Msyyd49wG89wljjMCl2q8MqhvwyyMlG4hlwGjwMd eae521a8-bb72-45c7-a1fb-5608abed1938 127.0.0.1 44124 NA /datasets/soap query-service 34048 Exit ExecutionEnvironmentContext (com.cognos.xqe.query.engine.ExecutionEnvironment@dff4f074).
2021-06-09T18:58:02.839+0000 INFO XQE.ExecutionEnvironmentContext [Default Executor-thread-4386] Msyyd49wG89wljjMCl2q8MqhvwyyMlG4hlwGjwMd Msyyd49wG89wljjMCl2q8MqhvwyyMlG4hlwGjwMd eae521a8-bb72-45c7-a1fb-5608abed1938 127.0.0.1 44124 NA /datasets/soap query-service 34048 Exit ExecutionEnvironmentContext (com.cognos.xqe.query.engine.ExecutionEnvironment@dff4f074).
2021-06-09T18:58:02.839+0000 INFO XQE.ROLAPCubes.Reservation [Default Executor-thread-4386] Msyyd49wG89wljjMCl2q8MqhvwyyMlG4hlwGjwMd Msyyd49wG89wljjMCl2q8MqhvwyyMlG4hlwGjwMd eae521a8-bb72-45c7-a1fb-5608abed1938 127.0.0.1 44124 NA /datasets/soap query-service 34048 Query nesting count: 0
2021-06-09T18:58:02.840+0000 ERROR XQE.Exception [Default Executor-thread-4386] Msyyd49wG89wljjMCl2q8MqhvwyyMlG4hlwGjwMd Msyyd49wG89wljjMCl2q8MqhvwyyMlG4hlwGjwMd eae521a8-bb72-45c7-a1fb-5608abed1938 127.0.0.1 44124 NA /datasets/soap query-service 34048 Caught error in V5QueryHandler: XQE-GEN-0005 Found an internal error.
at com.cognos.xqe.exception.XQERuntimeException.wrap(XQERuntimeException.java:638)
at com.cognos.xqe.exception.XQERuntimeException.wrap(XQERuntimeException.java:621)
at com.cognos.xqebifw.bibushandler.ExecuteRequestAdapter.executeRequest(ExecuteRequestAdapter.java:323)
at com.cognos.xqebifw.bibushandler.ExecuteRequestAdapter.executeRequest(ExecuteRequestAdapter.java:99)
at com.cognos.xqebifw.cubingservices.V5QueryHandler.executeRequestInSequence(V5QueryHandler.java:866)
at com.cognos.xqebifw.cubingservices.V5QueryHandler.execute(V5QueryHandler.java:656)
at com.ibm.bi.qs.rest.endpoints.QueryServiceEndPoint.executeSOAPCommand(QueryServiceEndPoint.java:442)
at com.ibm.bi.qs.rest.endpoints.QueryServiceEndPoint.executeSOAPRequest(QueryServiceEndPoint.java:106)
at sun.reflect.GeneratedMethodAccessor60.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:55)
at java.lang.reflect.Method.invoke(Method.java:508)
at com.ibm.ws.jaxrs20.server.LibertyJaxRsServerFactoryBean.performInvocation(LibertyJaxRsServerFactoryBean.java:656)
at com.ibm.ws.jaxrs20.server.LibertyJaxRsInvoker.performInvocation(LibertyJaxRsInvoker.java:160)
at org.apache.cxf.service.invoker.AbstractInvoker.invoke(AbstractInvoker.java:96)
at com.ibm.ws.jaxrs20.server.LibertyJaxRsInvoker.invoke(LibertyJaxRsInvoker.java:273)
at org.apache.cxf.jaxrs.JAXRSInvoker.invoke(JAXRSInvoker.java:191)
at com.ibm.ws.jaxrs20.server.LibertyJaxRsInvoker.invoke(LibertyJaxRsInvoker.java:444)
at org.apache.cxf.jaxrs.JAXRSInvoker.invoke(JAXRSInvoker.java:101)
at org.apache.cxf.interceptor.ServiceInvokerInterceptor$1.run(ServiceInvokerInterceptor.java:61)
at org.apache.cxf.interceptor.ServiceInvokerInterceptor.handleMessage(ServiceInvokerInterceptor.java:99)
at org.apache.cxf.phase.PhaseInterceptorChain.doIntercept(PhaseInterceptorChain.java:309)
at org.apache.cxf.transport.ChainInitiationObserver.onMessage(ChainInitiationObserver.java:124)
at org.apache.cxf.transport.http.AbstractHTTPDestination.invoke(AbstractHTTPDestination.java:271)
at com.ibm.ws.jaxrs20.endpoint.AbstractJaxRsWebEndpoint.invoke(AbstractJaxRsWebEndpoint.java:136)
at com.ibm.websphere.jaxrs.server.IBMRestServlet.handleRequest(IBMRestServlet.java:146)
at com.ibm.websphere.jaxrs.server.IBMRestServlet.doPost(IBMRestServlet.java:104)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:707)
at com.ibm.websphere.jaxrs.server.IBMRestServlet.service(IBMRestServlet.java:96)
at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:1230)
at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:729)
at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:426)
at com.ibm.ws.webcontainer.filter.WebAppFilterChain.invokeTarget(WebAppFilterChain.java:182)
at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:93)
at com.ibm.bi.logging.glug.support.web.BITransactionFilter.doFilter(BITransactionFilter.java:68)
at com.ibm.ws.webcontainer.filter.FilterInstanceWrapper.doFilter(FilterInstanceWrapper.java:201)
at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:90)
at com.ibm.bi.platform.commons.shared.BIBlockingFilter.doFilter(BIBlockingFilter.java:60)
at com.ibm.ws.webcontainer.filter.FilterInstanceWrapper.doFilter(FilterInstanceWrapper.java:201)
at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:90)
at com.ibm.ws.webcontainer.filter.WebAppFilterManager.doFilter(WebAppFilterManager.java:1001)
at com.ibm.ws.webcontainer.filter.WebAppFilterManager.invokeFilters(WebAppFilterManager.java:1139)
at com.ibm.ws.webcontainer.filter.WebAppFilterManager.invokeFilters(WebAppFilterManager.java:1010)
at com.ibm.ws.webcontainer.servlet.CacheServletWrapper.handleRequest(CacheServletWrapper.java:75)
at com.ibm.ws.webcontainer.WebContainer.handleRequest(WebContainer.java:938)
at com.ibm.ws.webcontainer.osgi.DynamicVirtualHost$2.run(DynamicVirtualHost.java:279)
at com.ibm.ws.http.dispatcher.internal.channel.HttpDispatcherLink$TaskWrapper.run(HttpDispatcherLink.java:1134)
at com.ibm.ws.http.dispatcher.internal.channel.HttpDispatcherLink.wrapHandlerAndExecute(HttpDispatcherLink.java:415)
at com.ibm.ws.http.dispatcher.internal.channel.HttpDispatcherLink.ready(HttpDispatcherLink.java:374)
at com.ibm.ws.http.channel.internal.inbound.HttpInboundLink.handleDiscrimination(HttpInboundLink.java:546)
at com.ibm.ws.http.channel.internal.inbound.HttpInboundLink.handleNewRequest(HttpInboundLink.java:480)
at com.ibm.ws.http.channel.internal.inbound.HttpInboundLink.processRequest(HttpInboundLink.java:345)
at com.ibm.ws.http.channel.internal.inbound.HttpICLReadCallback.complete(HttpICLReadCallback.java:70)
at com.ibm.ws.tcpchannel.internal.WorkQueueManager.requestComplete(WorkQueueManager.java:504)
at com.ibm.ws.tcpchannel.internal.WorkQueueManager.attemptIO(WorkQueueManager.java:574)
at com.ibm.ws.tcpchannel.internal.WorkQueueManager.workerRun(WorkQueueManager.java:958)
at com.ibm.ws.tcpchannel.internal.WorkQueueManager$Worker.run(WorkQueueManager.java:1047)
at com.ibm.ws.threading.internal.ExecutorServiceImpl$RunnableWrapper.run(ExecutorServiceImpl.java:239)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1160)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:635)
at java.lang.Thread.run(Thread.java:822)
Caused by: java.lang.ArrayStoreException
at com.cognos.xqe.transformation.runtree.relational.vectorization.GenerateXVectorGroupBy.apply(GenerateXVectorGroupBy.java:186)
at com.cognos.xqe.transformation.runtree.relational.vectorization.GenerateXVectorGroupBy.apply(GenerateXVectorGroupBy.java:67)
at com.cognos.xqe.transformation.runtree.relational.vectorization.GenerateXVectorGroupBy.apply(GenerateXVectorGroupBy.java:42)
at com.cognos.xqeqte.QTETransformationEngine.applyTransformation(QTETransformationEngine.java:1178)
at com.cognos.xqeqte.QTETransformationEngine.applyApplicableTransformation(QTETransformationEngine.java:1105)
at com.cognos.xqeqte.QTETransformationEngine.applyTopDownFastOrBottomUpTransformations(QTETransformationEngine.java:720)
at com.cognos.xqeqte.QTETransformationEngine.applyBottomUpTransformations(QTETransformationEngine.java:530)
at com.cognos.xqeqte.QTETransformationEngine.transformationIteration(QTETransformationEngine.java:320)
at com.cognos.xqeqte.QTETransformationEngine.applyTransformations(QTETransformationEngine.java:253)
at com.cognos.xqe.query.engine.TransformationEngine.applyTransformations(TransformationEngine.java:219)
at com.cognos.xqe.query.planner.QueryPlanner.plan(QueryPlanner.java:374)
at com.cognos.xqe.query.planner.QueryPlanner.planQuery(QueryPlanner.java:515)
at com.cognos.xqe.query.planner.QueryPlanner.planQuery(QueryPlanner.java:443)
at com.cognos.xqe.query.planner.QueryPlanner.planQueryAllowPlanReuse(QueryPlanner.java:663)
at com.cognos.xqe.query.engine.QueryEngine.prepareV5Request(QueryEngine.java:645)
at com.cognos.xqe.query.engine.QueryEngine.prepareRequest(QueryEngine.java:471)
at com.cognos.xqe.query.engine.QueryEngine.fetchRSAPIDatasets(QueryEngine.java:2324)
at com.cognos.xqe.query.engine.QueryEngine.executeRequest(QueryEngine.java:416)
at com.cognos.xqebifw.bibushandler.ExecuteRequestAdapter.executeRequest(ExecuteRequestAdapter.java:167)
... 57 more
------------------------------
Ethan Davis
Product Manager
IBM Clinical Development
------------------------------
#CognosAnalyticswithWatson