Eclipse Community Forums: BIRT » Cryptic Error Message when Running Report on Oracle

Help

Home

Home » Archived » BIRT » Cryptic Error Message when Running Report on Oracle

Show: Today's Messages :: Show Polls :: Message Navigator

Cryptic Error Message when Running Report on Oracle [message #663007]

Fri, 01 April 2011 23:09

Raishad

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)

Report message to a moderator

Re: Cryptic Error Message when Running Report on Oracle [message #663029 is a reply to message #663007]

Sat, 02 April 2011 13:00

Richard A. Polunsky

Messages: 212
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

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 19 19:01:03 GMT 2024

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter