Webservice problem

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: <a class='bbc_url' href='http://10.5.25.200'>http://10.5.25.200</a> 
: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 '<a class='bbc_url' href='http://10.5.25.200:9080/PaymentsAppService_WAR/BeneficiaryWebService/BeneficiaryWebService.wsdl'.'>http://10.5.25.200:9080/PaymentsAppService_WAR/BeneficiaryWebService/BeneficiaryWebService.wsdl'.</a> 
Retrieving document at 'BeneficiaryServiceDelegate.wsdl', relative to '<a class='bbc_url' href='http://10.5.25.200:9080/PaymentsAppService_WAR/BeneficiaryWebService/BeneficiaryWebService.wsdl'.'>http://10.5.25.200:9080/PaymentsAppService_WAR/BeneficiaryWebService/BeneficiaryWebService.wsdl'.</a> 
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: <a class='bbc_url' href='http://10.5.25.200:9...ciaryWebService'>http://10.5.25.200:9...ciaryWebService</a> 
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

Find more posts tagged with

Comments

mwilliams

Hi,

Is that the entire error stack? Is there any more to it?

Saint_77

<blockquote class='ipsBlockquote' data-author="'mwilliams'" data-cid="70366" data-time="1289939992" data-date="16 November 2010 - 01:39 PM">
Hi, 
Is that the entire error stack? Is there any more to it? </blockquote>
It is the entire stack.

mwilliams

It appears that there is a server connection issue with the URL you're trying to connect to. Are you sure you have access to the webservice? If you use just a single webservice rather than the "quite a few" you have, does it work?

Saint_77

<blockquote class='ipsBlockquote' data-author="'mwilliams'" data-cid="70392" data-time="1290009165" data-date="17 November 2010 - 08:52 AM">
It appears that there is a server connection issue with the URL you're trying to connect to. Are you sure you have access to the webservice? If you use just a single webservice rather than the "quite a few" you have, does it work? </blockquote>
I can at the same time as getting this error in Birt, do a call to the same service using the soapUI application - and i will get a resultset back.

mwilliams

Do you control the webservice? Or is it an external webservice? Could it possibly be blocking certain applications? That's really the only instance I've seen for this error in a quick search.

Are you using BIRT within RAD or separately?

Saint_77

No i do not control the webservice but i do have access to that servers logs. I can see my request coming in with the parameters i am passing it...the developer of this service then also prints out the amount of records he is returning in the log, so i can see that there is a response.....but here is where i get stuck.

From the server returning the response and Birt rendering the pdf is where the issue occurs...but i dont see any real helpfull errors in the console. I just get that useless 500 - Server error, so i dont know if its the Websphere server or the Birt 'server' that has an issue. I am assuming its the Birt side cause there is no stacktrace on the Websphere server - and again when i call that same service using soapUI there is a response with no errors on the Websphere server side.

I have 5 Birt reports that do exactly the same thing now, and 7 (6 calling sharepoint services, 1 calling Axis2 services on Websphere) that works. I have noticed that if i pass parameters (SOAP Request) and my syntax is wrong i also get some non descriptive error - for example, in one of them i by mistake passed my parameters like this,
?&param_1&?
instead of the correct way - like this
&?param_1?&

But i have since checked all others to make sure that i am passing them correctly...also i can see in the webservice server logs that the parameters are getting there.

Apart from setting up a proxy between Birt and the webservice to see what is going and coming back (which will help but not tell me why Birt cant render it) is there anywhere else that i can find better descriptions of what the errors are - or maybe see the full stacktrace ?

At the moment i am only looking at the RAD (eclipse) console and also tried the DEBUG option in RAD but either one does not really hint at what the issue is.

What i have also noticed is that this issue seems to only occur on some of the Axis2 webservices i am calling (1 working, 5 not working). All the sharepoint services i call work fine.

Then this funny, 3 of the 5 come back with that useless error 500 and display nothing.
Then 2 of the 5 do not error at all but also do not display anything on the report ???

Please, any ideas or suggestions will be welcomed ?

mwilliams

You might try downloading BIRT separately to try with just BIRT alone and see if you still have the issue. This will help narrow it down to a BIRT issue for sure if it doesn't work with just the BIRT designer.

ReneG

Hi, 
 
We also had a problem with a BIRT report in combination with a WSDL. 
The message was 
... org.eclipse.birt.report.engine.api.EngineException: Cannot execute the statement. 
Server returned HTTP response code: 500 for URL: <a class='bbc_url' href='http://pc-070:8080/wsa/wsa1...'>http://pc-070:8080/wsa/wsa1...</a> 
 
The problem was that some SOAP information in the BIRT rptdesign file was missing or incorrect compared with the WSDL. In SOAP UI, I saw the SOAP envelope for my WSDL started with 
<soapenv:Envelope xmlns:soapenv="<a class='bbc_url' href='http://schemas.xmlsoap.org/soap/envelope/'>http://schemas.xmlsoap.org/soap/envelope/"</a> xmlns:urn="urn:openremscontract:OpenREMSContract"> 
.... 
 
I compared that with the rptdesign (xml) file. 
In that rptdesign file didn't contain the text xmlns:urn="urn:openremscontract:OpenREMSContract". I added it to the rptdesign as you can see below (the final goed one). 
...... 
<SOAP-ENV:Envelope 
xmlns:xsd="<a class='bbc_url' href='http://www.w3.org/2001/XMLSchema'>http://www.w3.org/2001/XMLSchema"</a> 
xmlns:SOAP-ENC="<a class='bbc_url' href='http://schemas.xmlsoap.org/soap/encoding/'>http://schemas.xmlsoap.org/soap/encoding/"</a> 
xmlns:xsi="<a class='bbc_url' href='http://www.w3.org/2001/XMLSchema-instance'>http://www.w3.org/2001/XMLSchema-instance"</a> 
xmlns:SOAP-ENV="<a class='bbc_url' href='http://schemas.xmlsoap.org/soap/envelope/'>http://schemas.xmlsoap.org/soap/envelope/"</a> 
xmlns:urn="urn:openremscontract:OpenREMSContract"> 
<SOAP-ENV:Body> 
<urn:remsgetvhe> 
<urn:ipiHuurder xsi:type="xsd:int">&?ipiHuurder?&</urn:ipiHuurder> 
</urn:remsgetvhe> 
</SOAP-ENV:Body> 
</SOAP-ENV:Envelope> 
.... 
It was also a problem that BIRT default made another SOAP-ENV:Body. It came up with 
<SOAP-ENV:Body> 
<m:remsgetvhe xmlns:m="urn:soap-fault:details"> 
<m:ipiHuurder xsi:type="xsd:int">&?ipiHuurder?&</m:ipiHuurder> 
</m:remsgetvhe> 
</SOAP-ENV:Body> 
Look at the m: text, it should be urn: as you can see above in the right version. 
 
After I changed that, it worked fine. 
 
So my advise is to check with SOAP UI how your SOAP-ENV and SOAP-Body should be and edit it in the rptdesign or use the edit dataset in the BIRT Designer and edit the SOAP Request. 
 
I hope this helps. 
 
With regards, 
 
Rene

mwilliams

Hi Rene,

Thanks for the info!