Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » BIRT » Cryptic Error Message when Running Report on Oracle
Cryptic Error Message when Running Report on Oracle [message #663007] Fri, 01 April 2011 23:09 Go to next message
Raishad is currently offline RaishadFriend
Messages: 77
Registered: July 2009
Member
I'm running a report originally created in 2.3.2 on 2.6.1 against an
Oracle database. If I run this report on a MS SQL database, it runs fine.

I'm getting this error. What do I need to look at to fix this error?


Table (id = 671):
- Can not load the report query: 671. Errors occurred when generating
the report document for the report element with ID 671.
Error.ReportQueryLoadingError2 ( 1 time(s) )
detail : org.eclipse.birt.report.engine.api.EngineException: Can not
load the report query: 671. Errors occurred when generating the report
document for the report element with ID 671.
at
org.eclipse.birt.report.engine.data.dte.DataPresentationEngi ne.doExecuteQuery(DataPresentationEngine.java:160)
at
org.eclipse.birt.report.engine.data.dte.AbstractDataEngine.e xecute(AbstractDataEngine.java:265)
at
org.eclipse.birt.report.engine.executor.ExecutionContext.exe cuteQuery(ExecutionContext.java:1876)
at
org.eclipse.birt.report.engine.internal.document.v4.ReportIt emExecutor.executeQuery(ReportItemExecutor.java:412)
at
org.eclipse.birt.report.engine.internal.document.v4.TableIte mExecutor.doExecute(TableItemExecutor.java:72)
at
org.eclipse.birt.report.engine.internal.document.v4.ReportIt emExecutor.execute(ReportItemExecutor.java:294)
at
org.eclipse.birt.report.engine.internal.document.v4.Containe rExecutor.prepareChildExecutor(ContainerExecutor.java:226)
at
org.eclipse.birt.report.engine.internal.document.v4.Containe rExecutor.hasNextChild(ContainerExecutor.java:110)
at
org.eclipse.birt.report.engine.internal.executor.wrap.Wrappe dReportItemExecutor.hasNextChild(WrappedReportItemExecutor.j ava:86)
at
org.eclipse.birt.report.engine.internal.executor.wrap.Wrappe dReportItemExecutor.hasNextChild(WrappedReportItemExecutor.j ava:86)
at
org.eclipse.birt.report.engine.api.impl.RenderTask$ReportExe cutorWrapper.hasNextChild(RenderTask.java:782)
at
org.eclipse.birt.report.engine.layout.html.HTMLPageLM$1.hasN extChild(HTMLPageLM.java:68)
at
org.eclipse.birt.report.engine.layout.html.HTMLBlockStacking LM.layoutNodes(HTMLBlockStackingLM.java:62)
at
org.eclipse.birt.report.engine.layout.html.HTMLPageLM.layout (HTMLPageLM.java:90)
at
org.eclipse.birt.report.engine.layout.html.HTMLReportLayoutE ngine.layout(HTMLReportLayoutEngine.java:99)
at
org.eclipse.birt.report.engine.api.impl.RenderTask$PageRange Render.render(RenderTask.java:662)
at
org.eclipse.birt.report.engine.api.impl.RenderTask.render(Re nderTask.java:284)
at
org.eclipse.birt.report.service.ReportEngineService.renderRe port(ReportEngineService.java:1537)
at
org.eclipse.birt.report.service.BirtViewerReportService.getP age(BirtViewerReportService.java:204)
at
org.eclipse.birt.report.service.actionhandler.BirtChangePara meterActionHandler.doRenderPage(BirtChangeParameterActionHan dler.java:82)
at
org.eclipse.birt.report.service.actionhandler.AbstractChange ParameterActionHandler.__execute(AbstractChangeParameterActi onHandler.java:103)
at
org.eclipse.birt.report.service.actionhandler.AbstractBaseAc tionHandler.execute(AbstractBaseActionHandler.java:90)
at
org.eclipse.birt.report.soapengine.processor.AbstractBaseDoc umentProcessor.__executeAction(AbstractBaseDocumentProcessor .java:47)
at
org.eclipse.birt.report.soapengine.processor.AbstractBaseCom ponentProcessor.executeAction(AbstractBaseComponentProcessor .java:143)
at
org.eclipse.birt.report.soapengine.processor.BirtDocumentPro cessor.handleChangeParameter(BirtDocumentProcessor.java:100)
at sun.reflect.GeneratedMethodAccessor347.invoke(Unknown Source)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMe thodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at
org.eclipse.birt.report.soapengine.processor.AbstractBaseCom ponentProcessor.process(AbstractBaseComponentProcessor.java: 112)
at
org.eclipse.birt.report.soapengine.endpoint.BirtSoapBindingI mpl.getUpdatedObjects(BirtSoapBindingImpl.java:66)
at sun.reflect.GeneratedMethodAccessor346.invoke(Unknown Source)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMe thodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at
org.apache.axis.providers.java.RPCProvider.invokeMethod(RPCP rovider.java:397)
at
org.apache.axis.providers.java.RPCProvider.processMessage(RP CProvider.java:186)
at
org.apache.axis.providers.java.JavaProvider.invoke(JavaProvi der.java:323)
at
org.apache.axis.strategies.InvocationStrategy.visit(Invocati onStrategy.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(AxisServle t.java:699)
at
org.eclipse.birt.report.servlet.BirtSoapMessageDispatcherSer vlet.doPost(BirtSoapMessageDispatcherServlet.java:265)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
at
org.apache.axis.transport.http.AxisServletBase.service(AxisS ervletBase.java:327)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at
org.eclipse.birt.report.servlet.BirtSoapMessageDispatcherSer vlet.service(BirtSoapMessageDispatcherServlet.java:122)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFi lter(ApplicationFilterChain.java:290)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(App licationFilterChain.java:206)
at
org.eclipse.birt.report.filter.ViewerFilter.doFilter(ViewerF ilter.java:68)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFi lter(ApplicationFilterChain.java:235)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(App licationFilterChain.java:206)
at
com.infor.scm.wms.birt.security.SCMSecurityFilter.doFilter(S CMSecurityFilter.java:94)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFi lter(ApplicationFilterChain.java:235)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(App licationFilterChain.java:206)
at
org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(Repl yHeaderFilter.java:96)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFi lter(ApplicationFilterChain.java:235)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(App licationFilterChain.java:206)
at
org.apache.catalina.core.StandardWrapperValve.invoke(Standar dWrapperValve.java:235)
at
org.apache.catalina.core.StandardContextValve.invoke(Standar dContextValve.java:191)
at
org.jboss.web.tomcat.security.SecurityAssociationValve.invok e(SecurityAssociationValve.java:190)
at
org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccCo ntextValve.java:92)
at
org.jboss.web.tomcat.security.SecurityContextEstablishmentVa lve.process(SecurityContextEstablishmentValve.java:126)
at
org.jboss.web.tomcat.security.SecurityContextEstablishmentVa lve.invoke(SecurityContextEstablishmentValve.java:70)
at
org.apache.catalina.core.StandardHostValve.invoke(StandardHo stValve.java:127)
at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorRepo rtValve.java:102)
at
org.jboss.web.tomcat.service.jca.CachedConnectionValve.invok e(CachedConnectionValve.java:158)
at
org.apache.catalina.core.StandardEngineValve.invoke(Standard EngineValve.java:109)
at
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAd apter.java:330)
at
org.apache.coyote.http11.Http11Processor.process(Http11Proce ssor.java:829)
at
org.apache.coyote.http11.Http11Protocol$Http11ConnectionHand ler.process(Http11Protocol.java:598)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoin t.java:447)
at java.lang.Thread.run(Thread.java:619)
Re: Cryptic Error Message when Running Report on Oracle [message #663029 is a reply to message #663007] Sat, 02 April 2011 13:00 Go to previous message
Richard A. Polunsky is currently offline Richard A. PolunskyFriend
Messages: 199
Registered: July 2009
Location: Houston TX
Senior Member

When you originally wrote the report, was it running against an ORACLE or MS SQL SERVER database?

If you open the report with a text editor, you should be able to scan the XML structure and find the entry with ID = 671. That will probably be a table, in which case you would look at the supporting data set query.

Have you gone through in the designer and verified that all of the dataset queries work against ORACLE?

Richard
Previous Topic:Computed column: email
Next Topic:Preview errors [SOLVED]
Goto Forum:
  


Current Time: Sun Nov 23 14:43:20 GMT 2014

Powered by FUDForum. Page generated in 0.03541 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software