Eclipse Community Forums: BIRT » Birt Report Accessing XML Marklogic DataSource Deployed Viewer in Tomcat Application

Home » Eclipse Projects » BIRT » Birt Report Accessing XML Marklogic DataSource Deployed Viewer in Tomcat Application(Birt Report Accessing XML Marklogic DataSource Deployed Viewer in Tomcat Application)

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

Birt Report Accessing XML Marklogic DataSource Deployed Viewer in Tomcat Application [message #547850]

Mon, 19 July 2010 20:17

Sreedhar

Messages: 3
Registered: July 2010

Junior Member

When I access the report with in Birt eclipse, it is prompting a small window which developer has to provide UserId, Password and serverName fields, and it query against XML Marklogic datasource, and report data populated.

URL for XML Source:

http://192.168.4.144:8008/TEST/getTransJobStatus.xquery?http Jobid=params["httpJobid"]

When Birt Report Accessing the XML Marklogic DataSource and Deployed Viewer in Tomcat Application, It is not prompting the UserName, Password and ServerName. I got the following exception.

Rolling Eyes

http://localhost:8080/birt-viewer/run__report=Report\BIRTXML Report.rptdesign

Demonstration of Birt Reporting Data with MarkLogic
OrderPerson Count Title Note Quantity Price Name

Copy Right of Lockheed Martin Corporation

------------------------------------------------------------ --------------------

The following items have errors:

Table (id = 36):
- Cannot fetch the next data row.
org.eclipse.datatools.connectivity.oda.OdaException ;
java.io.IOException: Server returned HTTP response code: 401 for URL: http://192.168.4.144:8008/TEST/getTransJobStatus.xquery?http Jobid=0.1-9-201004.3336
odaconsumer.CannotFetchNextRow ( 1 time(s) )
detail : org.eclipse.birt.report.engine.api.EngineException: Cannot fetch the next data row.
org.eclipse.datatools.connectivity.oda.OdaException ;
java.io.IOException: Server returned HTTP response code: 401 for URL: http://192.168.4.144:8008/TEST/getTransJobStatus.xquery?http Jobid=0.1-9-201004.3336
at org.eclipse.birt.report.engine.executor.ExecutionContext.add Exception(ExecutionContext.java:1210)
at org.eclipse.birt.report.engine.executor.ExecutionContext.add Exception(ExecutionContext.java:1174)
at org.eclipse.birt.report.engine.executor.QueryItemExecutor.ex ecuteQuery(QueryItemExecutor.java:96)
at org.eclipse.birt.report.engine.executor.TableItemExecutor.ex ecute(TableItemExecutor.java:62)
at org.eclipse.birt.report.engine.internal.executor.dup.Suppres sDuplicateItemExecutor.execute(SuppressDuplicateItemExecutor .java:43)
at org.eclipse.birt.report.engine.internal.executor.wrap.Wrappe dReportItemExecutor.execute(WrappedReportItemExecutor.java:4 6)
at org.eclipse.birt.report.engine.internal.executor.l18n.Locali zedReportItemExecutor.execute(LocalizedReportItemExecutor.ja va:34)
at org.eclipse.birt.report.engine.layout.html.HTMLBlockStacking LM.layoutNodes(HTMLBlockStackingLM.java:65)
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.RunAndRenderTask.doR un(RunAndRenderTask.java:172)
at org.eclipse.birt.report.engine.api.impl.RunAndRenderTask.run (RunAndRenderTask.java:75)
at org.eclipse.birt.report.service.ReportEngineService.runAndRe nderReport(ReportEngineService.java:920)
at org.eclipse.birt.report.service.BirtViewerReportService.runA ndRenderReport(BirtViewerReportService.java:973)
at org.eclipse.birt.report.service.actionhandler.BirtGetPageAll ActionHandler.__execute(BirtGetPageAllActionHandler.java:131 )
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.handleGetPageAll(BirtDocumentProcessor.java:183)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAcce ssorImpl.java:39)
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.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAcce ssorImpl.java:39)
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 org.apache.catalina.core.StandardWrapperValve.invoke(Standar dWrapperValve.java:233)
at org.apache.catalina.core.StandardContextValve.invoke(Standar dContextValve.java:191)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHo stValve.java:127)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorRepo rtValve.java:102)
at org.apache.catalina.core.StandardEngineValve.invoke(Standard EngineValve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAd apter.java:298)
at org.apache.coyote.http11.Http11Processor.process(Http11Proce ssor.java:852)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHand ler.process(Http11Protocol.java:588)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoin t.java:489)
at java.lang.Thread.run(Thread.java:619)
Caused by: org.eclipse.birt.data.engine.odaconsumer.OdaDataException: Cannot fetch the next data row.
org.eclipse.datatools.connectivity.oda.OdaException ;
java.io.IOException: Server returned HTTP response code: 401 for URL: http://192.168.4.144:8008/TEST/getTransJobStatus.xquery?http Jobid=0.1-9-201004.3336
at org.eclipse.birt.data.engine.odaconsumer.ExceptionHandler.ne wException(ExceptionHandler.java:52)
at org.eclipse.birt.data.engine.odaconsumer.ExceptionHandler.th rowException(ExceptionHandler.java:108)
at org.eclipse.birt.data.engine.odaconsumer.ExceptionHandler.th rowException(ExceptionHandler.java:84)
at org.eclipse.birt.data.engine.odaconsumer.ResultSet.fetch(Res ultSet.java:143)
at org.eclipse.birt.data.engine.executor.cache.OdiAdapter.fetch (OdiAdapter.java:153)
at org.eclipse.birt.data.engine.executor.cache.RowResultSet.nex t(RowResultSet.java:105)
at org.eclipse.birt.data.engine.executor.transform.SimpleResult Set. <init>(SimpleResultSet.java:82)
at org.eclipse.birt.data.engine.executor.DataSourceQuery.execut e(DataSourceQuery.java:833)
at org.eclipse.birt.data.engine.impl.PreparedOdaDSQuery$OdaDSQu eryExecutor.executeOdiQuery(PreparedOdaDSQuery.java:427)
at org.eclipse.birt.data.engine.impl.QueryExecutor.execute(Quer yExecutor.java:1045)
at org.eclipse.birt.data.engine.impl.ServiceForQueryResults.exe cuteQuery(ServiceForQueryResults.java:232)
at org.eclipse.birt.data.engine.impl.QueryResults.getResultIter ator(QueryResults.java:159)
at org.eclipse.birt.report.engine.data.dte.QueryResultSet.<init >(QueryResultSet.java:98)
at org.eclipse.birt.report.engine.data.dte.DteDataEngine.doExec uteQuery(DteDataEngine.java:168)
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:1875)
at org.eclipse.birt.report.engine.executor.QueryItemExecutor.ex ecuteQuery(QueryItemExecutor.java:80)
... 55 more
Caused by: org.eclipse.datatools.connectivity.oda.OdaException ;
java.io.IOException: Server returned HTTP response code: 401 for URL: http://192.168.4.144:8008/TEST/getTransJobStatus.xquery?http Jobid=0.1-9-201004.3336
at org.eclipse.datatools.enablement.oda.xml.util.XMLSourceFromP ath.openInputStream(XMLSourceFromPath.java:74)
at org.eclipse.datatools.enablement.oda.xml.util.SaxParser.<init >(SaxParser.java:81)
at org.eclipse.datatools.enablement.oda.xml.util.SaxParserNeste dQueryHelper. <init>(SaxParserNestedQueryHelper.java:65)
at org.eclipse.datatools.enablement.oda.xml.util.SaxParserConsu mer. <init>(SaxParserConsumer.java:105)
at org.eclipse.datatools.enablement.oda.xml.impl.ResultSet.next (ResultSet.java:142)
at org.eclipse.datatools.connectivity.oda.consumer.helper.OdaRe sultSet.next(OdaResultSet.java:180)
at org.eclipse.birt.data.engine.odaconsumer.ResultSet.fetch(Res ultSet.java:138)
... 68 more
Caused by: java.io.IOException: Server returned HTTP response code: 401 for URL: http://192.168.4.144:8008/TEST/getTransJobStatus.xquery?http Jobid=0.1-9-201004.3336
at sun.net.www.protocol.http.HttpURLConnection.getInputStream(H ttpURLConnection.java:1313)
at java.net.URL.openStream(URL.java:1010)
at org.eclipse.datatools.enablement.oda.xml.util.XMLSourceFromP ath.openInputStream(XMLSourceFromPath.java:66)
... 74 more

Any Help would be apprciated.

Thanks,
Sreedhar

Report message to a moderator