Skip to Content
0
Former Member
Apr 14, 2011 at 01:42 PM

Problems with consuming SAP BW WSDL in Crystal Reports 2008

20 Views

Hello,

I am trying to use the WSDL generated from the SAP BW in Crystal Reports 2008 using the XML and Web Services driver, but when I input the WSDL url Crystal does not interpret the url passed in as a WSDL url and the Services, Port and Method drop downs are blank.

If I manually input the values I get the error below from Crystal

"Logon failed.

Details: Web Service Location is invalid

WSDL Exception (at /wsdl:definitions/wsdl:portType/wsp:Policy): faultCode=INVALID_WSDL:Encountered unexpected element

'Policy'."

I know this is a valid WSDL as I have tested it with Xcelsius 2008 and I am able to get data back in Xcelsius. I found SAP note 1485601 that talks about Crystal Reports not being able to reading a WSDL generated by a SAP system.

https://websmp230.sap-ag.de/sap/support/notes/1485601

Based on the error message from Crystal above I feel that Crystal is unable to read the WSDL URL, has anyone else encountered this issue, if so is there a possible work around.

We are running Crystal Reports 2008 V1 SP3 FP 3 and the SAP Integration Kit is also on the same service pack and patch level.

Any help or insight into the issue will be very helpful.

Thanks,

Kumar