KB38916: Connectivity Error being displayed when attempting to connect to an endpoint of an SAP Web Service using XQuery in MicroStrategy 9.4.x and 10.x

• Strategy

Connectivity Error being displayed when attempting to connect to an endpoint of an SAP Web Service using XQuery in MicroStrategy 9.4.x and 10.x

SYMPTOM:
In this particular scenario, an SAP Query is being executed using XQuery. When attempting to run the query from the XQuery Editor and Generator, the error message that is shown is “OTHER ERROR” as depicted in the screenshot below:


OTHER ERROR

In the DSSError.log,however, the following error message is seen:


2012-01-04 09:44:55.820+01:00 axis2_svc_client_send_receive failed. Unable to either send a request or receive a response.

Error type: XQuery Engine error. Invalid response from SOAP Endpoint (http://test.biserver.com:8020/sap/bc/srt/rfc/sap/zxcel_exe_query_ws2/001/zxcel_exe_query_ws2/zxcel_exe_query_ws2); Error occurred in transport. Connection String: XQUERY;UID=guest;. Connection String: XQUERY;UID=guest;.

ACTION:
In this scenario, the XQuery contains an incorrect port number. An extract of the XQuery is shown below:


let $uri := ('http://test.biserver.com:8020/sap/bc/srt/rfc/sap/zxcel_exe_query_ws2/001/zxcel_exe_query_ws2/zxcel_exe_query_ws2')

(: SOAP Action if any :)

let $soap-version := element SOAPInfo {element SOAPVersion { 'SOAP12' }, element SOAPAction { ' ' }}

let $ws-secu := (' ')

let $soap-custom-header := (' ')

...

By modifying the URL to remove the port number, the query runs correctly:


let $uri := ('http://test.biserver.com/sap/bc/srt/rfc/sap/zxcel_exe_query_ws2/001/zxcel_exe_query_ws2/zxcel_exe_query_ws2')

(: SOAP Action if any :)

let $soap-version := element SOAPInfo {element SOAPVersion { 'SOAP12' }, element SOAPAction { ' ' }}

let $ws-secu := (' ')

let $soap-custom-header := (' ')

...

Comment

0 comments

Details

Knowledge Article

Published:

May 16, 2017

Last Updated:

January 31, 2018

2012-01-04 09:44:55.820+01:00 axis2_svc_client_send_receive failed. Unable to either send a request or receive a response. Error type: XQuery Engine error. Invalid response from SOAP Endpoint (http://test.biserver.com:8020/sap/bc/srt/rfc/sap/zxcel_exe_query_ws2/001/zxcel_exe_query_ws2/zxcel_exe_query_ws2); Error occurred in transport. Connection String: XQUERY;UID=guest;. Connection String: XQUERY;UID=guest;.

let $uri := ('http://test.biserver.com:8020/sap/bc/srt/rfc/sap/zxcel_exe_query_ws2/001/zxcel_exe_query_ws2/zxcel_exe_query_ws2') (: SOAP Action if any :) let $soap-version := element SOAPInfo {element SOAPVersion { 'SOAP12' }, element SOAPAction { ' ' }} let $ws-secu := (' ') let $soap-custom-header := (' ') ...

let $uri := ('http://test.biserver.com/sap/bc/srt/rfc/sap/zxcel_exe_query_ws2/001/zxcel_exe_query_ws2/zxcel_exe_query_ws2') (: SOAP Action if any :) let $soap-version := element SOAPInfo {element SOAPVersion { 'SOAP12' }, element SOAPAction { ' ' }} let $ws-secu := (' ') let $soap-custom-header := (' ') ...