Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
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)
Birt Report Accessing XML Marklogic DataSource Deployed Viewer in Tomcat Application [message #547850] Mon, 19 July 2010 20:17 Go to next message
Sreedhar  is currently offline Sreedhar Friend
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



Re: Birt Report Accessing XML Marklogic DataSource Deployed Viewer in Tomcat Application [message #831256 is a reply to message #547850] Wed, 28 March 2012 17:17 Go to previous message
Ralph Soika is currently offline Ralph SoikaFriend
Messages: 38
Registered: July 2009
Member
I have the same problem.
Has anyboda found a solution for this?

====
Ralph
Previous Topic:Script Functions not in Category
Next Topic:Drill through feature issue in UNIX
Goto Forum:
  


Current Time: Mon Dec 22 18:01:00 GMT 2014

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

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