Hi,
We recently started working on Actuate version 11.0.3 and trying to create a web services based data source. ow.The data source is successfully created but the data set is throwing an error as below when trying to preview the results.
1. Are there any pre-requisites to be followed before creating a data source based on a Web Services Data Source?
2. The web service get the data out when tried to run from the web services explorer or a SOAP UI.
3. Does Actuate 11.0.3 work with only SOAP12 and SOAP?
org.eclipse.birt.data.engine.odaconsumer.OdaDataException: Cannot execute the statement.
org.eclipse.datatools.connectivity.oda.OdaException: Server returned HTTP response code: 500 for URL:
http://ilch-45843.ent.ad.ntrs.com/WcfServiceLibrary1.Service1.svc
at org.eclipse.birt.data.engine.odaconsumer.ExceptionHandler.newException(ExceptionHandler.java:52)
at org.eclipse.birt.data.engine.odaconsumer.ExceptionHandler.throwException(ExceptionHandler.java:108)
at org.eclipse.birt.data.engine.odaconsumer.ExceptionHandler.throwException(ExceptionHandler.java:84)
at org.eclipse.birt.data.engine.odaconsumer.PreparedStatement.execute(PreparedStatement.java:586)
at org.eclipse.birt.data.engine.executor.DataSourceQuery.execute(DataSourceQuery.java:927)
at org.eclipse.birt.data.engine.impl.PreparedOdaDSQuery$OdaDSQueryExecutor.executeOdiQuery(PreparedOdaDSQuery.java:441)
at org.eclipse.birt.data.engine.impl.QueryExecutor.execute(QueryExecutor.java:1124)
at org.eclipse.birt.data.engine.impl.ServiceForQueryResults.executeQuery(ServiceForQueryResults.java:232)
at org.eclipse.birt.data.engine.impl.QueryResults.getResultIterator(QueryResults.java:173)
at org.eclipse.birt.report.engine.api.impl.ExtractionResults.nextResultIterator(ExtractionResults.java:74)
at org.eclipse.birt.report.designer.data.ui.dataset.DataSetPreviewer.preview(DataSetPreviewer.java:75)
at org.eclipse.birt.report.designer.data.ui.dataset.ResultSetPreviewPage$5.run(ResultSetPreviewPage.java:337)
at org.eclipse.jface.operation.ModalContext$ModalContextThread.run(ModalContext.java:121)
Caused by: org.eclipse.datatools.connectivity.oda.OdaException: Server returned HTTP response code: 500 for URL:
http://ilch-45843.ent.ad.ntrs.com/WcfServiceLibrary1.Service1.svc
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:469)
at org.eclipse.datatools.connectivity.oda.consumer.helper.OdaQuery.executeQuery(OdaQuery.java:433)
at org.eclipse.birt.data.engine.odaconsumer.PreparedStatement.execute(PreparedStatement.java:575)
... 9 more
