Calling QAAWS from MII - Context was null

[Former Member]

I'm having trouble invoking a Query As A Web Service call into BW. If I call the service using SOAPUI, the call goes through successfully and returns 1800+ rows. If I use the MII Web Service Action to call the Convert Temperature WS used in the training classes, it returns the expected results. When I try and call QAAWS via the MII Web Service, the call returns no data and I see an error message in the logs "Error Invoking Web Service Action: Context Was Null".

I haven't seen this error message described in the forums so far. We're using MII v12.0

Thanks,

Adam Doyle

[Former Member · Accepted solution]

FWIW you could try getting the SOAP xml/envelope out of soap ui and posting it with the http post action.

[Former Member · Accepted solution]

We're currently trying to get this working with the HttpPost action, but I'm running into trouble getting the results. Using the sample XML below, I'm not able to get at the nodes under runQueryAsAServiceResponse. My Repeater (INV_HttpPost_TRX_0.OutputXml{/soap:Envelope/soap:Body/runQueryAsAServiceResponse/table/row}) can't find them.

<soap:Envelope xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/" xmlns:xsd="http://www.w3.org/2001/XMLSchema"><soap:Body><runQueryAsAServiceResponse xmlns="MII_Dashboard"><table><row><L01_Plant>PLANT</L01_Plant><L01_Material>GASKETS/RINGS</L01_Material><L01_Calendar_Year_Month>09.1999</L01_Calendar_Year_Month><L01_Base_Unit>Each</L01_Base_Unit><Value>28</Value></row>

</table><message></message><creatorname>CREATORy</creatorname><creationdate>2010-06-09T20:22:33.284</creationdate><creationdateformated>06/09/2010 8:22:33 PM </creationdateformated><description></description><universe>SAP_MII_POC</universe><queryruntime>1</queryruntime><fetchedrows>1884</fetchedrows></runQueryAsAServiceResponse></soap:Body></soap:Envelope>

I'm very confused.

Adam

[Former Member · Accepted solution]

If you look at the returned XML, you'll see that a "default namespace" ("MII_Dashboard") is being assigned to the result. To XPath this properly in your repeater, try one of the following:

{/soap:Envelope/soap:Body/MII_Dashboard:runQueryAsAServiceResponse/MII_Dashboard:table/MII_Dashboard:row}

{/soap:Envelope/soap:Body/MII_Dashboard:runQueryAsAServiceResponse/table/row}

{/soap:Envelope/soap:Body/ns0:runQueryAsAServiceResponse/ns0:table/ns0:row}

{/soap:Envelope/soap:Body/ns0:runQueryAsAServiceResponse/table/row}

{/soap:Envelope/soap:Body/ns1:runQueryAsAServiceResponse/ns1:table/ns1:row}

{/soap:Envelope/soap:Body/ns1:runQueryAsAServiceResponse/table/row}

I don't have time to try it to determine which one will work, but I'm fairly certain one of them will.

Rick

[Former Member]

We are using the HttpPost Action and parsing its output. Not clean, but functional.