com.sap.ip.bi.sdk.exception.BIResourceException: Cannot get data set

[Former Member]

Hi all,

I've created an MDX statement :

[code]SELECT

{[Measures].[ZACTAMTLC],[Measures].[ZPLNAMTLC]} ON COLUMNS

NON EMPTY [0NETWORK].MEMBERS ON ROWS

FROM [$ZMPSCOST]

WHERE [0NETWORK].[30000266][/code]

and it yielded the error mentioned in the title when I tried running it as a webservice. Below lists further exception messages :

<b>Caused by: com.sap.ip.bi.sdk.exception.BIResourceException: SOAP request failed with return code 2147483653 ( Value 30000266 for characteristic 0NETWORK unknown)

at com.sap.ip.bi.sdk.dac.connector.xmla.impl.Connection.sendSOAPRequest(Connection.java:1023)

at com.sap.ip.bi.sdk.dac.connector.xmla.impl.Connection.execute(Connection.java:779)

at com.sap.ip.bi.sdk.dac.connector.xmla.impl.Connection.getDataSet(Connection.java:539)

at com.sap.ip.bi.sdk.dac.connector.xmla.XmlaOlap.execute(XmlaOlap.java:186)</b>

What does the error message mean? I've run the same query using Query Designer and tried running it using the same value 30000266 as input for Network and it returned some results.

Is there anything that I'm missing that I'm not aware of?

Any advice is appreciated.

Thanks, regards.

[Former Member]

Hi,

Have you tried executing the MDX statement using transaction code MDXTEST?

Regards,

Oliver

[Former Member]

Thanks Oliver! That helped a lot.