[Saint_77]

Hi

I have quite a few webservices i need use as my Datasources for the reports i have generate. I did the 1st one and it worked fine....no problems but ever since then i do not seem to be able to get Birt to use a webservice as its datasource. It seems as if the dataset never gets a result, or it gets an empty result.

I can also never preview the PDF in RAD and when u deploy the report and try it thru Tomcat, i get the following error in the Tomcat console. I can however call that same service thru soapUI and i get a response back, with no problems.

Tomcat Console Output when calling the Birt report
SEVERE: Cannot execute statement.
org.eclipse.datatools.connectivity.oda.OdaException: Server returned HTTP response code: 500 for URL: http://10.5.25.200
:9080/PaymentsAppService_WAR/BeneficiaryWebService
at org.eclipse.datatools.enablement.oda.ws.util.RawMessageSender.getSOAPResponse(RawMessageSender.java:107)
at org.eclipse.datatools.enablement.oda.ws.impl.Query.getInputStream(Query.java:184)
at org.eclipse.datatools.enablement.oda.ws.impl.Query.initXMLQuery(Query.java:136)
at org.eclipse.datatools.enablement.oda.ws.impl.Query.executeQuery(Query.java:128)
at org.eclipse.datatools.connectivity.oda.consumer.helper.OdaQuery.doExecuteQuery(OdaQuery.java:464)
at org.eclipse.datatools.connectivity.oda.consumer.helper.OdaQuery.executeQuery(OdaQuery.java:428)
at org.eclipse.birt.data.engine.odaconsumer.PreparedStatement.execute(PreparedStatement.java:599)
at org.eclipse.birt.data.engine.executor.DataSourceQuery.execute(DataSourceQuery.java:771)
at org.eclipse.birt.data.engine.impl.PreparedOdaDSQuery$OdaDSQueryExecutor.executeOdiQuery(PreparedOdaDSQuery.ja
va:399)
at org.eclipse.birt.data.engine.impl.QueryExecutor.execute(QueryExecutor.java:1045)
at org.eclipse.birt.data.engine.impl.ServiceForQueryResults.executeQuery(ServiceForQueryResults.java:232)
at org.eclipse.birt.data.engine.impl.QueryResults.getResultIterator(QueryResults.java:158)
at org.eclipse.birt.report.engine.data.dte.QueryResultSet.<init>(QueryResultSet.java:98)
at org.eclipse.birt.report.engine.data.dte.DteDataEngine.doExecuteQuery(DteDataEngine.java:168)
at org.eclipse.birt.report.engine.data.dte.AbstractDataEngine.execute(AbstractDataEngine.java:265)
at org.eclipse.birt.report.engine.executor.ExecutionContext.executeQuery(ExecutionContext.java:1875)
at org.eclipse.birt.report.engine.executor.QueryItemExecutor.executeQuery(QueryItemExecutor.java:80)
at org.eclipse.birt.report.engine.executor.TableItemExecutor.execute(TableItemExecutor.java:62)
at org.eclipse.birt.report.engine.internal.executor.dup.SuppressDuplicateItemExecutor.execute(SuppressDuplicateI
temExecutor.java:43)
at org.eclipse.birt.report.engine.internal.executor.wrap.WrappedReportItemExecutor.execute(WrappedReportItemExec
utor.java:46)
at org.eclipse.birt.report.engine.internal.executor.l18n.LocalizedReportItemExecutor.execute(LocalizedReportItem
Executor.java:34)
at org.eclipse.birt.report.engine.layout.html.HTMLBlockStackingLM.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.HTMLReportLayoutEngine.layout(HTMLReportLayoutEngine.java:99)
at org.eclipse.birt.report.engine.api.impl.RunAndRenderTask.doRun(RunAndRenderTask.java:170)
at org.eclipse.birt.report.engine.api.impl.RunAndRenderTask.run(RunAndRenderTask.java:75)
at za.co.absa.online.reports.handler.BirtReportHandler.generateReport(BirtReportHandler.java:82)
at za.co.absa.online.reports.ReportFilter.doFilter(ReportFilter.java:59)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)
at org.apache.coyote.http11.Http11AprProcessor.process(Http11AprProcessor.java:859)
at org.apache.coyote.http11.Http11AprProtocol$Http11ConnectionHandler.process(Http11AprProtocol.java:579)
at org.apache.tomcat.util.net.AprEndpoint$Worker.run(AprEndpoint.java:1555)
at java.lang.Thread.run(Thread.java:619)




PS: I have also tried running in it debug mode in RAD but then i still get a blank PDF with no results returned and the following error in the RAD console.

RAD Debug Console when running report in Debug mode
Nov 15, 2010 5:55:41 PM org.eclipse.birt.report.debug.internal.core.vm.ReportVMServer start
INFO: [Server] client accepted
Nov 15, 2010 5:55:41 PM org.eclipse.birt.report.debug.internal.core.vm.ReportVMServer$1 run
INFO: [Server] enter request dispatching
Nov 15, 2010 5:55:41 PM org.eclipse.birt.report.debug.internal.core.launcher.ReportLauncher configEngine
INFO: User class path received:
Retrieving document at 'http://10.5.25.200:9080/PaymentsAppService_WAR/BeneficiaryWebService/BeneficiaryWebService.wsdl'.
Retrieving document at 'BeneficiaryServiceDelegate.wsdl', relative to 'http://10.5.25.200:9080/PaymentsAppService_WAR/BeneficiaryWebService/BeneficiaryWebService.wsdl'.
Nov 15, 2010 5:55:45 PM org.eclipse.birt.data.engine.odaconsumer.PreparedStatement execute
SEVERE: Cannot execute statement.
Throwable occurred: org.eclipse.datatools.connectivity.oda.OdaException: Server returned HTTP response code: 500 for URL: http://10.5.25.200:9...ciaryWebService
at org.eclipse.datatools.enablement.oda.ws.util.RawMessageSender.getSOAPResponse(RawMessageSender.java:107)
at org.eclipse.datatools.enablement.oda.ws.impl.Query.getInputStream(Query.java:183)
at org.eclipse.datatools.enablement.oda.ws.impl.Query.initXMLQuery(Query.java:135)
at org.eclipse.datatools.enablement.oda.ws.impl.Query.executeQuery(Query.java:127)
at org.eclipse.datatools.connectivity.oda.consumer.helper.OdaQuery.doExecuteQuery(OdaQuery.java:443)
at org.eclipse.datatools.connectivity.oda.consumer.helper.OdaQuery.executeQuery(OdaQuery.java:408)
at org.eclipse.birt.data.engine.odaconsumer.PreparedStatement.execute(PreparedStatement.java:546)
at org.eclipse.birt.data.engine.executor.DataSourceQuery$OdaQueryExecutor.run(DataSourceQuery.java:929)
at java.lang.Thread.run(Thread.java:736)
Nov 15, 2010 5:55:51 PM org.eclipse.birt.report.debug.internal.core.vm.ReportVMServer$1 run
WARNING: [Server] client disconnected


I have taken the SOAP Request i use in my dataset and paste that directly in soapUI to call the service....and it works fine....i always get a response.
I have put System.out's in the service to see what is being passed in from the birt soap request and also what i am returning to birt and i can see the correct vals are coming in and that i return data back to birt...it just seems as if birt never displays the results returned....as if it does not know how.

I have googled the above errors now for a few days but with no luck. Please anybody that can shed some light on this issue please help.

I am running the follwoing:
- RAD 7.5.5.1
- Birt v.2.3.2
- 64Bit operating system if it matters (Win XP)

Regards

[Virgil]

One option if you can't get the web service data source to work as expected is to use the Scripted data source instead which can get data from a Java wrapper making your SOAP calls.