TRIRIGA

 View Only

  • 1.  BIRT report runs fine in the designer, but fails when run from Tririga

    Posted Mon November 18, 2024 02:55 PM
    Sorry if I'm spamming the group with this, but I inadvertently sent the initial email on this with an incorrect subject line.

    I've created a report that runs just fine in the BIRT report designer, but when I run it from Tririga, I get the error, "There is an error in the report query loading, Can not retrieve data to generate the report." This seems to be similar to the problem discussed here (www.ibm.com/support/pages/apar/IV68911) but the suggested workaround is entirely specific to the poster's application and it's not clear how I could apply it to my situation. Also, the link above seems to indicate that this apparent defect was resolved in 3.4.1-TIV-TAP-FP002-WIN, but we're running 3.5.2 and the problem remains.
    Has anyone else encountered and resolved this issue?
     
     


  • 2.  RE: BIRT report runs fine in the designer, but fails when run from Tririga

    Posted Tue November 19, 2024 09:00 AM

    The message you are getting is a generic BIRT error when running in TRIRIGA. Does the error have a (+) displayed anywhere? if so, you can click it and get a full error stack. That will include more details on the actual error. The server.log file will also contain the full error stack.



    ------------------------------
    Brian Brinkmann
    ------------------------------

    Original Message


  • 3.  RE: BIRT report runs fine in the designer, but fails when run from Tririga

    Posted Tue November 19, 2024 09:48 AM

    Thank you so much for responding Brian!

     

    The error occurs when BIRT tries to populate a table. The report runs if I remove that table, but another table in the report renders fine. The odd thing to me is that the report runs without error in the designer but fails when run from Tririga. The entire error is below, but I didn't find anything particularly enlightening here; maybe there's something that catches your eye?

     

    Regards,

    Lee J.

    The following items have errors:

     

    Table (id = 875):

    - There is an error in the report query loading, Can not retrieve data to generate the report. 

    Error.ReportQueryLoadingError ( 1 time(s) )

    detail : org.eclipse.birt.report.engine.api.EngineException: There is an error in the report query loading, Can not retrieve data to generate the report.

            at org.eclipse.birt.report.engine.data.dte.DataPresentationEngine.doExecuteQuery(DataPresentationEngine.java:161)

            at org.eclipse.birt.report.engine.data.dte.AbstractDataEngine.execute(AbstractDataEngine.java:275)

            at org.eclipse.birt.report.engine.executor.ExecutionContext.executeQuery(ExecutionContext.java:1947)

            at org.eclipse.birt.report.engine.internal.document.v4.ReportItemExecutor.executeQuery(ReportItemExecutor.java:412)

            at org.eclipse.birt.report.engine.internal.document.v4.TableItemExecutor.doExecute(TableItemExecutor.java:72)

            at org.eclipse.birt.report.engine.internal.document.v4.ReportItemExecutor.execute(ReportItemExecutor.java:294)

            at org.eclipse.birt.report.engine.internal.document.v4.ContainerExecutor.prepareChildExecutor(ContainerExecutor.java:226)

            at org.eclipse.birt.report.engine.internal.document.v4.ContainerExecutor.hasNextChild(ContainerExecutor.java:110)

            at org.eclipse.birt.report.engine.internal.executor.wrap.WrappedReportItemExecutor.hasNextChild(WrappedReportItemExecutor.java:86)

            at org.eclipse.birt.report.engine.internal.executor.wrap.WrappedReportItemExecutor.hasNextChild(WrappedReportItemExecutor.java:86)

            at org.eclipse.birt.report.engine.api.impl.RenderTask$ReportExecutorWrapper.hasNextChild(RenderTask.java:850)

            at org.eclipse.birt.report.engine.layout.html.HTMLPageLM$1.hasNextChild(HTMLPageLM.java:68)

            at org.eclipse.birt.report.engine.layout.html.HTMLBlockStackingLM.layoutNodes(HTMLBlockStackingLM.java:62)

            at org.eclipse.birt.report.engine.layout.html.HTMLPageLM.layout(HTMLPageLM.java:92)

            at org.eclipse.birt.report.engine.layout.html.HTMLReportLayoutEngine.layout(HTMLReportLayoutEngine.java:100)

            at org.eclipse.birt.report.engine.api.impl.RenderTask$PageRangeRender.render(RenderTask.java:718)

            at org.eclipse.birt.report.engine.api.impl.RenderTask.render(RenderTask.java:321)

            at org.eclipse.birt.report.service.ReportEngineService.renderReport(ReportEngineService.java:1545)

            at org.eclipse.birt.report.service.BirtViewerReportService.getPage(BirtViewerReportService.java:204)

            at org.eclipse.birt.report.service.actionhandler.AbstractGetPageActionHandler.doExecution(AbstractGetPageActionHandler.java:238)

            at org.eclipse.birt.report.service.actionhandler.AbstractGetPageActionHandler.__execute(AbstractGetPageActionHandler.java:105)

            at org.eclipse.birt.report.service.actionhandler.AbstractBaseActionHandler.execute(AbstractBaseActionHandler.java:90)

            at org.eclipse.birt.report.soapengine.processor.AbstractBaseDocumentProcessor.__executeAction(AbstractBaseDocumentProcessor.java:47)

            at org.eclipse.birt.report.soapengine.processor.AbstractBaseComponentProcessor.executeAction(AbstractBaseComponentProcessor.java:143)

            at com.tririga.platform.birt.viewer.soapengine.processor.TriBirtDocumentProcessor.handleGetPage(TriBirtDocumentProcessor.java:32)

            at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

            at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:95)

            at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:55)

            at java.lang.reflect.Method.invoke(Method.java:508)

            at org.eclipse.birt.report.soapengine.processor.AbstractBaseComponentProcessor.process(AbstractBaseComponentProcessor.java:112)

            at org.eclipse.birt.report.soapengine.endpoint.BirtSoapBindingImpl.getUpdatedObjects(BirtSoapBindingImpl.java:66)

            at com.tririga.platform.birt.viewer.soapengine.endpoint.TriBirtSoapBindingImpl.access$201(TriBirtSoapBindingImpl.java:41)

            at com.tririga.platform.birt.viewer.soapengine.endpoint.TriBirtSoapBindingImpl$BirtMemoryManagedProcess.executeInternal(TriBirtSoapBindingImpl.java:62)

            at com.tririga.platform.memory.impl.MemoryManagedProcesses$AbstractBirtProcess.execute(MemoryManagedProcesses.java:72)

            at com.tririga.platform.memory.impl.MemoryManagedProcesses$AbstractBirtProcess.execute(MemoryManagedProcesses.java:28)

            at com.tririga.platform.memory.impl.MemoryManagedServiceImpl.manageProcess(MemoryManagedServiceImpl.java:183)

            at com.tririga.platform.birt.viewer.soapengine.endpoint.TriBirtSoapBindingImpl.getUpdatedObjects(TriBirtSoapBindingImpl.java:111)

            at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

            at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:95)

            at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:55)

            at java.lang.reflect.Method.invoke(Method.java:508)

            at org.apache.axis.providers.java.RPCProvider.invokeMethod(RPCProvider.java:397)

            at org.apache.axis.providers.java.RPCProvider.processMessage(RPCProvider.java:186)

            at org.apache.axis.providers.java.JavaProvider.invoke(JavaProvider.java:323)

            at org.apache.axis.strategies.InvocationStrategy.visit(InvocationStrategy.java:32)

            at org.apache.axis.SimpleChain.doVisiting(SimpleChain.java:118)

            at org.apache.axis.SimpleChain.invoke(SimpleChain.java:83)

            at org.apache.axis.handlers.soap.SOAPService.invoke(SOAPService.java:454)

            at org.apache.axis.server.AxisServer.invoke(AxisServer.java:281)

            at org.apache.axis.transport.http.AxisServlet.doPost(AxisServlet.java:699)

            at org.eclipse.birt.report.servlet.BirtSoapMessageDispatcherServlet.doPost(BirtSoapMessageDispatcherServlet.java:265)

            at javax.servlet.http.HttpServlet.service(HttpServlet.java:595)

            at org.apache.axis.transport.http.AxisServletBase.service(AxisServletBase.java:327)

            at com.tririga.platform.birt.viewer.TriViewerServlet.service(TriViewerServlet.java:145)

            at javax.servlet.http.HttpServlet.service(HttpServlet.java:668)

            at org.eclipse.birt.report.servlet.BirtSoapMessageDispatcherServlet.service(BirtSoapMessageDispatcherServlet.java:122)

            at org.eclipse.equinox.http.servlet.internal.ServletRegistration.service(ServletRegistration.java:61)

            at org.eclipse.equinox.http.servlet.internal.ProxyServlet.processAlias(ProxyServlet.java:126)

            at org.eclipse.equinox.http.servlet.internal.ProxyServlet.service(ProxyServlet.java:60)

            at javax.servlet.http.HttpServlet.service(HttpServlet.java:668)

            at org.eclipse.equinox.servletbridge.BridgeServlet.service(BridgeServlet.java:120)

            at javax.servlet.http.HttpServlet.service(HttpServlet.java:668)

            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.tririga.platform.context.ContextFilter$2.execute(ContextFilter.java:144)

            at com.tririga.platform.context.ContextServiceImpl.runInNewReadOnlyContext(ContextServiceImpl.java:177)

            at com.tririga.platform.context.ContextServiceImpl.runInNewReadOnlyContext(ContextServiceImpl.java:148)

            at com.tririga.platform.context.ContextFilter.doFilterInternal(ContextFilter.java:130)

            at com.tririga.platform.context.ContextFilter.doFilter(ContextFilter.java:79)

            at com.ibm.ws.webcontainer.filter.FilterInstanceWrapper.doFilter(FilterInstanceWrapper.java:201)

            at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:90)

            at com.tririga.web.filter.XSSDecodingFilter.doFilter(XSSDecodingFilter.java:61)

            at com.ibm.ws.webcontainer.filter.FilterInstanceWrapper.doFilter(FilterInstanceWrapper.java:201)

            at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:90)

            at com.tririga.web.filter.XSSURLEncodeFilter.doFilter(XSSURLEncodeFilter.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.tririga.web.filter.StandardsModeFilter.doFilter(StandardsModeFilter.java:35)

            at com.ibm.ws.webcontainer.filter.FilterInstanceWrapper.doFilter(FilterInstanceWrapper.java:201)

            at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:90)

            at com.tririga.web.filter.UserSessionFilter.doFilter(UserSessionFilter.java:78)

            at com.ibm.ws.webcontainer.filter.FilterInstanceWrapper.doFilter(FilterInstanceWrapper.java:201)

            at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:90)

            at com.tririga.web.filter.EncodingFilter.doFilter(EncodingFilter.java:55)

            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:1136)

            at com.ibm.ws.http.dispatcher.internal.channel.HttpDispatcherLink.wrapHandlerAndExecute(HttpDispatcherLink.java:417)

            at com.ibm.ws.http.dispatcher.internal.channel.HttpDispatcherLink.ready(HttpDispatcherLink.java:376)

            at com.ibm.ws.http.channel.internal.inbound.HttpInboundLink.handleDiscrimination(HttpInboundLink.java:548)

            at com.ibm.ws.http.channel.internal.inbound.HttpInboundLink.handleNewRequest(HttpInboundLink.java:482)

            at com.ibm.ws.http.channel.internal.inbound.HttpInboundLink.processRequest(HttpInboundLink.java:347)

            at com.ibm.ws.http.channel.internal.inbound.HttpICLReadCallback.complete(HttpICLReadCallback.java:70)

            at com.ibm.ws.channel.ssl.internal.SSLReadServiceContext$SSLReadCompletedCallback.complete(SSLReadServiceContext.java:1803)

            at com.ibm.ws.tcpchannel.internal.WorkQueueManager.requestComplete(WorkQueueManager.java:503)

            at com.ibm.ws.tcpchannel.internal.WorkQueueManager.attemptIO(WorkQueueManager.java:573)

            at com.ibm.ws.tcpchannel.internal.WorkQueueManager.workerRun(WorkQueueManager.java:954)

            at com.ibm.ws.tcpchannel.internal.WorkQueueManager$Worker.run(WorkQueueManager.java:1043)

            at com.ibm.ws.threading.internal.ExecutorServiceImpl$RunnableWrapper.run(ExecutorServiceImpl.java:239)

            at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1153)

            at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628)

            at java.lang.Thread.run(Thread.java:785)

     

     




    Original Message


  • 4.  RE: BIRT report runs fine in the designer, but fails when run from Tririga

    Posted Wed November 20, 2024 09:12 AM

    I don't see anything in the error stack. Usually when I have seen this kind of behavior it has been due to either an issue with the dataset or with the table binding. When you remove and re-add the table are you using undo/redo, or recreating manually? You might try creating a new report with just the table that is causing issues to make sure that it isn't something with layout or binding.



    ------------------------------
    Brian Brinkmann
    ------------------------------

    Original Message