Cognos Analytics

 View Only

ArrayStoreException

  • 1.  ArrayStoreException

    Posted Thu June 10, 2021 10:10 AM
      |   view attached
    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

    Attachment(s)

    zip
    report_execution_error.zip   1.80 MB 1 version