Unable to run report under tomcat

KarstenP
edited February 11, 2022 in Analytics #1
<p>Please excuse my ignorance and noob knowledge, I'm all new to BIRT, being an intern hoping to become a developer someday.</p>
<p>The company I do my internship in shall switch it's reporting to BIRT, so therefor I installed Eclipse Neoan with BIRT runtime 4.6.0.</p>
<p>After a lot of trial and error I get my first reports working from Eclipse, but when I open a report via the birt-viewer at localhost (tomcat 7.0.56) I get the viewer, can enter my parameter, but then get following error messages:</p>
<p> </p>
<p><b><span>org.eclipse.birt.report.engine.api.EngineException: Error happened while running the report.</span></b></p>
<p> </p>
<p><span style="color:rgb(0,0,0);font-family:monospace;font-size:10.6667px;background-color:rgb(255,255,239);">org.eclipse.birt.report.engine.api.EngineException: Error happened while running the report.</span><br><span style="color:rgb(0,0,0);font-family:monospace;font-size:10.6667px;background-color:rgb(255,255,239);">   at org.eclipse.birt.report.engine.api.impl.EngineTask.handleFatalExceptions(EngineTask.java:2375)</span><br><span style="color:rgb(0,0,0);font-family:monospace;font-size:10.6667px;background-color:rgb(255,255,239);">   at org.eclipse.birt.report.engine.api.impl.RunTask.doRun(RunTask.java:281)</span><br><span style="color:rgb(0,0,0);font-family:monospace;font-size:10.6667px;background-color:rgb(255,255,239);">   at org.eclipse.birt.report.engine.api.impl.RunTask.run(RunTask.java:89)</span><br><span style="color:rgb(0,0,0);font-family:monospace;font-size:10.6667px;background-color:rgb(255,255,239);">   at org.eclipse.birt.report.service.ReportEngineService.runReport(ReportEngineService.java:1325)</span><br><span style="color:rgb(0,0,0);font-family:monospace;font-size:10.6667px;background-color:rgb(255,255,239);">   at org.eclipse.birt.report.service.BirtViewerReportService.runReport(BirtViewerReportService.java:159)</span><br><span style="color:rgb(0,0,0);font-family:monospace;font-size:10.6667px;background-color:rgb(255,255,239);">   at org.eclipse.birt.report.service.actionhandler.BirtRunReportActionHandler.__execute(BirtRunReportActionHandler.java:81)</span><br><span style="color:rgb(0,0,0);font-family:monospace;font-size:10.6667px;background-color:rgb(255,255,239);">   at org.eclipse.birt.report.service.actionhandler.BirtChangeParameterActionHandler.runReport(BirtChangeParameterActionHandler.java:58)</span><br><span style="color:rgb(0,0,0);font-family:monospace;font-size:10.6667px;background-color:rgb(255,255,239);">   at org.eclipse.birt.report.service.actionhandler.AbstractChangeParameterActionHandler.__execute(AbstractChangeParameterActionHandler.java:52)</span><br><span style="color:rgb(0,0,0);font-family:monospace;font-size:10.6667px;background-color:rgb(255,255,239);">   at org.eclipse.birt.report.service.actionhandler.AbstractBaseActionHandler.execute(AbstractBaseActionHandler.java:90)</span><br><span style="color:rgb(0,0,0);font-family:monospace;font-size:10.6667px;background-color:rgb(255,255,239);">   at org.eclipse.birt.report.soapengine.processor.AbstractBaseDocumentProcessor.__executeAction(AbstractBaseDocumentProcessor.java:47)</span><br><span style="color:rgb(0,0,0);font-family:monospace;font-size:10.6667px;background-color:rgb(255,255,239);">   at org.eclipse.birt.report.soapengine.processor.AbstractBaseComponentProcessor.executeAction(AbstractBaseComponentProcessor.java:143)</span><br><span style="color:rgb(0,0,0);font-family:monospace;font-size:10.6667px;background-color:rgb(255,255,239);">   at org.eclipse.birt.report.soapengine.processor.BirtDocumentProcessor.handleChangeParameter(BirtDocumentProcessor.java:100)</span><br><span style="color:rgb(0,0,0);font-family:monospace;font-size:10.6667px;background-color:rgb(255,255,239);">   at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)</span><br><span style="color:rgb(0,0,0);font-family:monospace;font-size:10.6667px;background-color:rgb(255,255,239);">   at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)</span><br><span style="color:rgb(0,0,0);font-family:monospace;font-size:10.6667px;background-color:rgb(255,255,239);">   at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)</span><br><span style="color:rgb(0,0,0);font-family:monospace;font-size:10.6667px;background-color:rgb(255,255,239);">   at java.lang.reflect.Method.invoke(Unknown Source)</span><br><span style="color:rgb(0,0,0);font-family:monospace;font-size:10.6667px;background-color:rgb(255,255,239);">   at org.eclipse.birt.report.soapengine.processor.AbstractBaseComponentProcessor.process(AbstractBaseComponentProcessor.java:112)</span><br><span style="color:rgb(0,0,0);font-family:monospace;font-size:10.6667px;background-color:rgb(255,255,239);">   at org.eclipse.birt.report.soapengine.endpoint.BirtSoapBindingImpl.getUpdatedObjects(BirtSoapBindingImpl.java:66)</span><br><span style="color:rgb(0,0,0);font-family:monospace;font-size:10.6667px;background-color:rgb(255,255,239);">   at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)</span><br><span style="color:rgb(0,0,0);font-family:monospace;font-size:10.6667px;background-color:rgb(255,255,239);">   at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)</span><br><span style="color:rgb(0,0,0);font-family:monospace;font-size:10.6667px;background-color:rgb(255,255,239);">   at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)</span><br><span style="color:rgb(0,0,0);font-family:monospace;font-size:10.6667px;background-color:rgb(255,255,239);">   at java.lang.reflect.Method.invoke(Unknown Source)</span><br><span style="color:rgb(0,0,0);font-family:monospace;font-size:10.6667px;background-color:rgb(255,255,239);">   at org.apache.axis.providers.java.RPCProvider.invokeMethod(RPCProvider.java:397)</span><br><span style="color:rgb(0,0,0);font-family:monospace;font-size:10.6667px;background-color:rgb(255,255,239);">   at org.apache.axis.providers.java.RPCProvider.processMessage(RPCProvider.java:186)</span><br><span style="color:rgb(0,0,0);font-family:monospace;font-size:10.6667px;background-color:rgb(255,255,239);">   at org.apache.axis.providers.java.JavaProvider.invoke(JavaProvider.java:323)</span><br><span style="color:rgb(0,0,0);font-family:monospace;font-size:10.6667px;background-color:rgb(255,255,239);">   at org.apache.axis.strategies.InvocationStrategy.visit(InvocationStrategy.java:32)</span><br><span style="color:rgb(0,0,0);font-family:monospace;font-size:10.6667px;background-color:rgb(255,255,239);">   at org.apache.axis.SimpleChain.doVisiting(SimpleChain.java:118)</span><br><span style="color:rgb(0,0,0);font-family:monospace;font-size:10.6667px;background-color:rgb(255,255,239);">   at org.apache.axis.SimpleChain.invoke(SimpleChain.java:83)</span><br><span style="color:rgb(0,0,0);font-family:monospace;font-size:10.6667px;background-color:rgb(255,255,239);">   at org.apache.axis.handlers.soap.SOAPService.invoke(SOAPService.java:454)</span><br><span style="color:rgb(0,0,0);font-family:monospace;font-size:10.6667px;background-color:rgb(255,255,239);">   at org.apache.axis.server.AxisServer.invoke(AxisServer.java:281)</span><br><span style="color:rgb(0,0,0);font-family:monospace;font-size:10.6667px;background-color:rgb(255,255,239);">   at org.apache.axis.transport.http.AxisServlet.doPost(AxisServlet.java:699)</span><br><span style="color:rgb(0,0,0);font-family:monospace;font-size:10.6667px;background-color:rgb(255,255,239);">   at org.eclipse.birt.report.servlet.BirtSoapMessageDispatcherServlet.doPost(BirtSoapMessageDispatcherServlet.java:265)</span><br><span style="color:rgb(0,0,0);font-family:monospace;font-size:10.6667px;background-color:rgb(255,255,239);">   at javax.servlet.http.HttpServlet.service(HttpServlet.java:646)</span><br><span style="color:rgb(0,0,0);font-family:monospace;font-size:10.6667px;background-color:rgb(255,255,239);">   at org.apache.axis.transport.http.AxisServletBase.service(AxisServletBase.java:327)</span><br><span style="color:rgb(0,0,0);font-family:monospace;font-size:10.6667px;background-color:rgb(255,255,239);">   at javax.servlet.http.HttpServlet.service(HttpServlet.java:727)</span><br><span style="color:rgb(0,0,0);font-family:monospace;font-size:10.6667px;background-color:rgb(255,255,239);">   at org.eclipse.birt.report.servlet.BirtSoapMessageDispatcherServlet.service(BirtSoapMessageDispatcherServlet.java:122)</span><br><span style="color:rgb(0,0,0);font-family:monospace;font-size:10.6667px;background-color:rgb(255,255,239);">   at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303)</span><br><span style="color:rgb(0,0,0);font-family:monospace;font-size:10.6667px;background-color:rgb(255,255,239);">   at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)</span><br><span style="color:rgb(0,0,0);font-family:monospace;font-size:10.6667px;background-color:rgb(255,255,239);">   at org.eclipse.birt.report.filter.ViewerFilter.doFilter(ViewerFilter.java:68)</span><br><span style="color:rgb(0,0,0);font-family:monospace;font-size:10.6667px;background-color:rgb(255,255,239);">   at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)</span><br><span style="color:rgb(0,0,0);font-family:monospace;font-size:10.6667px;background-color:rgb(255,255,239);">   at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)</span><br><span style="color:rgb(0,0,0);font-family:monospace;font-size:10.6667px;background-color:rgb(255,255,239);">   at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)</span><br><span style="color:rgb(0,0,0);font-family:monospace;font-size:10.6667px;background-color:rgb(255,255,239);">   at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)</span><br><span style="color:rgb(0,0,0);font-family:monospace;font-size:10.6667px;background-color:rgb(255,255,239);">   at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)</span><br><span style="color:rgb(0,0,0);font-family:monospace;font-size:10.6667px;background-color:rgb(255,255,239);">   at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:220)</span><br><span style="color:rgb(0,0,0);font-family:monospace;font-size:10.6667px;background-color:rgb(255,255,239);">   at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:122)</span><br><span style="color:rgb(0,0,0);font-family:monospace;font-size:10.6667px;background-color:rgb(255,255,239);">   at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:503)</span><br><span style="color:rgb(0,0,0);font-family:monospace;font-size:10.6667px;background-color:rgb(255,255,239);">   at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:170)</span><br><span style="color:rgb(0,0,0);font-family:monospace;font-size:10.6667px;background-color:rgb(255,255,239);">   at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)</span><br><span style="color:rgb(0,0,0);font-family:monospace;font-size:10.6667px;background-color:rgb(255,255,239);">   at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:950)</span><br><span style="color:rgb(0,0,0);font-family:monospace;font-size:10.6667px;background-color:rgb(255,255,239);">   at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116)</span><br><span style="color:rgb(0,0,0);font-family:monospace;font-size:10.6667px;background-color:rgb(255,255,239);">   at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:421)</span><br><span style="color:rgb(0,0,0);font-family:monospace;font-size:10.6667px;background-color:rgb(255,255,239);">   at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1070)</span><br><span style="color:rgb(0,0,0);font-family:monospace;font-size:10.6667px;background-color:rgb(255,255,239);">   at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:611)</span><br><span style="color:rgb(0,0,0);font-family:monospace;font-size:10.6667px;background-color:rgb(255,255,239);">   at org.apache.tomcat.util.net.AprEndpoint$SocketProcessor.doRun(AprEndpoint.java:2462)</span><br><span style="color:rgb(0,0,0);font-family:monospace;font-size:10.6667px;background-color:rgb(255,255,239);">   at org.apache.tomcat.util.net.AprEndpoint$SocketProcessor.run(AprEndpoint.java:2451)</span><br><span style="color:rgb(0,0,0);font-family:monospace;font-size:10.6667px;background-color:rgb(255,255,239);">   at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)</span><br><span style="color:rgb(0,0,0);font-family:monospace;font-size:10.6667px;background-color:rgb(255,255,239);">   at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)</span><br><span style="color:rgb(0,0,0);font-family:monospace;font-size:10.6667px;background-color:rgb(255,255,239);">   at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)</span><br><span style="color:rgb(0,0,0);font-family:monospace;font-size:10.6667px;background-color:rgb(255,255,239);">   at java.lang.Thread.run(Unknown Source)</span><br><span style="color:rgb(0,0,0);font-family:monospace;font-size:10.6667px;background-color:rgb(255,255,239);">Caused by: java.lang.SecurityException: class "org.eclipse.datatools.connectivity.oda.IBlob"'s signer information does not match signer information of other classes in the same package</span><br><span style="color:rgb(0,0,0);font-family:monospace;font-size:10.6667px;background-color:rgb(255,255,239);">   at java.lang.ClassLoader.checkCerts(Unknown Source)</span><br><span style="color:rgb(0,0,0);font-family:monospace;font-size:10.6667px;background-color:rgb(255,255,239);">   at java.lang.ClassLoader.preDefineClass(Unknown Source)</span><br><span style="color:rgb(0,0,0);font-family:monospace;font-size:10.6667px;background-color:rgb(255,255,239);">   at java.lang.ClassLoader.defineClass(Unknown Source)</span><br><span style="color:rgb(0,0,0);font-family:monospace;font-size:10.6667px;background-color:rgb(255,255,239);">   at java.security.SecureClassLoader.defineClass(Unknown Source)</span><br><span style="color:rgb(0,0,0);font-family:monospace;font-size:10.6667px;background-color:rgb(255,255,239);">   at org.apache.catalina.loader.WebappClassLoader.findClassInternal(WebappClassLoader.java:2957)</span><br><span style="color:rgb(0,0,0);font-family:monospace;font-size:10.6667px;background-color:rgb(255,255,239);">   at org.apache.catalina.loader.WebappClassLoader.findClass(WebappClassLoader.java:1210)</span><br><span style="color:rgb(0,0,0);font-family:monospace;font-size:10.6667px;background-color:rgb(255,255,239);">   at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1690)</span><br><span style="color:rgb(0,0,0);font-family:monospace;font-size:10.6667px;background-color:rgb(255,255,239);">   at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1571)</span><br><span style="color:rgb(0,0,0);font-family:monospace;font-size:10.6667px;background-color:rgb(255,255,239);">   at org.eclipse.birt.data.engine.odaconsumer.ParameterHint.setDataType(ParameterHint.java:161)</span><br><span style="color:rgb(0,0,0);font-family:monospace;font-size:10.6667px;background-color:rgb(255,255,239);">   at org.eclipse.birt.data.engine.impl.ParameterUtil.createParameterHint(ParameterUtil.java:378)</span><br><span style="color:rgb(0,0,0);font-family:monospace;font-size:10.6667px;background-color:rgb(255,255,239);">   at org.eclipse.birt.data.engine.impl.ParameterUtil.resolveDataSetParameters(ParameterUtil.java:98)</span><br><span style="color:rgb(0,0,0);font-family:monospace;font-size:10.6667px;background-color:rgb(255,255,239);">   at org.eclipse.birt.data.engine.impl.PreparedDataSourceQuery.configureDataSetCache(PreparedDataSourceQuery.java:237)</span><br><span style="color:rgb(0,0,0);font-family:monospace;font-size:10.6667px;background-color:rgb(255,255,239);">   at org.eclipse.birt.data.engine.impl.PreparedDataSourceQuery.execute(PreparedDataSourceQuery.java:171)</span><br><span style="color:rgb(0,0,0);font-family:monospace;font-size:10.6667px;background-color:rgb(255,255,239);">   at org.eclipse.birt.data.engine.impl.PreparedOdaDSQuery.execute(PreparedOdaDSQuery.java:179)</span><br><span style="color:rgb(0,0,0);font-family:monospace;font-size:10.6667px;background-color:rgb(255,255,239);">   at org.eclipse.birt.report.data.adapter.impl.DataRequestSessionImpl.execute(DataRequestSessionImpl.java:651)</span><br><span style="color:rgb(0,0,0);font-family:monospace;font-size:10.6667px;background-color:rgb(255,255,239);">   at org.eclipse.birt.report.engine.data.dte.DteDataEngine.doExecuteQuery(DteDataEngine.java:152)</span><br><span style="color:rgb(0,0,0);font-family:monospace;font-size:10.6667px;background-color:rgb(255,255,239);">   at org.eclipse.birt.report.engine.data.dte.DataGenerationEngine.doExecuteQuery(DataGenerationEngine.java:83)</span><br><span style="color:rgb(0,0,0);font-family:monospace;font-size:10.6667px;background-color:rgb(255,255,239);">   at org.eclipse.birt.report.engine.data.dte.AbstractDataEngine.execute(AbstractDataEngine.java:286)</span><br><span style="color:rgb(0,0,0);font-family:monospace;font-size:10.6667px;background-color:rgb(255,255,239);">   at org.eclipse.birt.report.engine.executor.ExecutionContext.executeQuery(ExecutionContext.java:1947)</span><br><span style="color:rgb(0,0,0);font-family:monospace;font-size:10.6667px;background-color:rgb(255,255,239);">   at org.eclipse.birt.report.engine.executor.QueryItemExecutor.executeQuery(QueryItemExecutor.java:80)</span><br><span style="color:rgb(0,0,0);font-family:monospace;font-size:10.6667px;background-color:rgb(255,255,239);">   at org.eclipse.birt.report.engine.executor.TableItemExecutor.execute(TableItemExecutor.java:62)</span><br><span style="color:rgb(0,0,0);font-family:monospace;font-size:10.6667px;background-color:rgb(255,255,239);">   at org.eclipse.birt.report.engine.internal.executor.wrap.WrappedReportItemExecutor.execute(WrappedReportItemExecutor.java:46)</span><br><span style="color:rgb(0,0,0);font-family:monospace;font-size:10.6667px;background-color:rgb(255,255,239);">   at org.eclipse.birt.report.engine.internal.executor.emitter.ReportItemEmitterExecutor.execute(ReportItemEmitterExecutor.java:46)</span><br><span style="color:rgb(0,0,0);font-family:monospace;font-size:10.6667px;background-color:rgb(255,255,239);">   at org.eclipse.birt.report.engine.internal.executor.dup.SuppressDuplicateItemExecutor.execute(SuppressDuplicateItemExecutor.java:43)</span><br><span style="color:rgb(0,0,0);font-family:monospace;font-size:10.6667px;background-color:rgb(255,255,239);">   at org.eclipse.birt.report.engine.layout.html.HTMLBlockStackingLM.layoutNodes(HTMLBlockStackingLM.java:65)</span><br><span style="color:rgb(0,0,0);font-family:monospace;font-size:10.6667px;background-color:rgb(255,255,239);">   at org.eclipse.birt.report.engine.layout.html.HTMLPageLM.layout(HTMLPageLM.java:92)</span><br><span style="color:rgb(0,0,0);font-family:monospace;font-size:10.6667px;background-color:rgb(255,255,239);">   at org.eclipse.birt.report.engine.layout.html.HTMLReportLayoutEngine.layout(HTMLReportLayoutEngine.java:100)</span><br><span style="color:rgb(0,0,0);font-family:monospace;font-size:10.6667px;background-color:rgb(255,255,239);">   at org.eclipse.birt.report.engine.presentation.ReportDocumentBuilder.build(ReportDocumentBuilder.java:258)</span><br><span style="color:rgb(0,0,0);font-family:monospace;font-size:10.6667px;background-color:rgb(255,255,239);">   at org.eclipse.birt.report.engine.api.impl.RunTask.doRun(RunTask.java:273)</span><br><span style="color:rgb(0,0,0);font-family:monospace;font-size:10.6667px;background-color:rgb(255,255,239);">... 58 more</span></p>
<p> </p>
<p><span style="color:rgb(0,0,0);font-family:monospace;font-size:10.6667px;background-color:rgb(255,255,239);">Where's my mistake?<br>
Any help is appreciated.</span><br>
 </p>

Comments

  • <p>To help troubleshoot this issue:</p>
    <p> </p>
    <p>1. Does this .rptdesign run in the Designer?</p>
    <p>2. What version of Java are you using with the Designer?</p>
    <p> </p>
    <p>3. Do the sample reports (test.rptdesign and test1.rptdesign) run for you:</p>
    <pre class="_prettyXprint _lang-">
    http://localhost:8080/birt/frameset?__report=test.rptdesign
    http://localhost:8080/birt/frameset?__report=test1.rptdesign
    </pre>
    <p>4. What version of Java are you using with Tomcat 7.0.56?</p>
    <p> </p>
    <p>5. Do you have a sample report that you can post?  Please remove any username/password or hostnames in the Data Source before posting.</p>
    Warning No formatter is installed for the format ipb