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

38 Views

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.