Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Problem with executing mdx query through XMLA

I'm trying to execute simple mdx statement from my WD application and use XMLA for this purposes, code is the same simple as from sdk_bi tutorial. And I get strange error. Maybe someone have some ideas about it. Any help will be rewarded.

Warning ! Protocol Implementation [com.sap.engine.services.webservices.jaxrpc.wsdl2java.features.builtin.MessageIdProtocol] could not be loaded (NoClassDefFoundError) !

Error Message is :com/sap/guid/GUIDGeneratorFactory

Nov 20, 2007 9:46:52 PM ...dk.dac.connector.xmla.impl.Connection [Thread[main,5,main]] Error: Service call exception; nested exception is:

java.lang.NullPointerException

Nov 20, 2007 9:46:52 PM ...dk.dac.connector.xmla.impl.Connection [Thread[main,5,main]] Error: Cannot execute command SELECT NON EMPTY [TS_PROJ].[LEVEL01].MEMBERS * [TS_RESRC].[LEVEL01].MEMBERS ON AXIS(1) FROM [TS_C01/TS_C01_NW001]

Nov 20, 2007 9:46:52 PM ...dk.dac.connector.xmla.impl.Connection [Thread[main,5,main]] Error: Exception com.sap.ip.bi.sdk.exception.BIResourceException: Cannot execute command SELECT NON EMPTY [TS_PROJ].[LEVEL01].MEMBERS * [TS_RESRC].[LEVEL01].MEMBERS ON AXIS(1) FROM [TS_C01/TS_C01_NW001]

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

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

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

at com.sap.ip.bi.sdk.samples.Huy.main(Huy.java:33)

Caused by: java.rmi.RemoteException: Service call exception; nested exception is:

java.lang.NullPointerException

at com.sap.ip.bi.sdk.dac.connector.xmla.standalone.MsXmlAnalysisSoapStub.execute(MsXmlAnalysisSoapStub.java:147)

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

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

... 3 more

Caused by: java.lang.NullPointerException

at com.sap.ip.bi.sdk.dac.connector.xmla.impl.DatasetContentHandler.endElement(DatasetContentHandler.java:729)

at com.sap.engine.lib.xml.parser.handlers.SAXDocHandler.endElement(SAXDocHandler.java:156)

at com.sap.engine.lib.xml.parser.XMLParser.scanEndTag(XMLParser.java:1951)

at com.sap.engine.lib.xml.parser.XMLParser.scanElement(XMLParser.java:1844)

at com.sap.engine.lib.xml.parser.XMLParser.scanContent(XMLParser.java:2440)

at com.sap.engine.lib.xml.parser.XMLParser.scanElement(XMLParser.java:1841)

at com.sap.engine.lib.xml.parser.XMLParser.scanContent(XMLParser.java:2440)

at com.sap.engine.lib.xml.parser.XMLParser.scanElement(XMLParser.java:1841)

at com.sap.engine.lib.xml.parser.XMLParser.scanContent(XMLParser.java:2440)

at com.sap.engine.lib.xml.parser.XMLParser.scanElement(XMLParser.java:1841)

at com.sap.engine.lib.xml.parser.XMLParser.scanContent(XMLParser.java:2440)

at com.sap.engine.lib.xml.parser.XMLParser.scanElement(XMLParser.java:1841)

at com.sap.engine.lib.xml.parser.XMLParser.scanDocument(XMLParser.java:2843)

at com.sap.engine.lib.xml.parser.XMLParser.parse0(XMLParser.java:229)

at com.sap.engine.lib.xml.parser.AbstractXMLParser.parseAndCatchException(AbstractXMLParser.java:145)

at com.sap.engine.lib.xml.parser.AbstractXMLParser.parse(AbstractXMLParser.java:160)

at com.sap.engine.lib.xml.parser.AbstractXMLParser.parse(AbstractXMLParser.java:261)

at com.sap.engine.lib.xml.parser.Parser.parseWithoutSchemaValidationProcessing(Parser.java:280)

at com.sap.engine.lib.xml.parser.Parser.parse(Parser.java:342)

at com.sap.engine.lib.xml.parser.SAXParser.parse(SAXParser.java:125)

at com.sap.engine.services.webservices.jaxrpc.wsdl2java.soapbinding.MimeHttpBinding.handlerSAXMessage(MimeHttpBinding.java:1570)

at com.sap.engine.services.webservices.jaxrpc.wsdl2java.soapbinding.MimeHttpBinding.call(MimeHttpBinding.java:1449)

at com.sap.ip.bi.sdk.dac.connector.xmla.standalone.MsXmlAnalysisSoapStub.execute(MsXmlAnalysisSoapStub.java:140)

... 5 more

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

at com.sap.ip.bi.sdk.dac.connector.xmla.XmlaOlap.execute(XmlaOlap.java:189)

at com.sap.ip.bi.sdk.samples.Huy.main(Huy.java:33)

Caused by: com.sap.ip.bi.sdk.exception.BIResourceException: Cannot execute command SELECT NON EMPTY [TS_PROJ].[LEVEL01].MEMBERS * [TS_RESRC].[LEVEL01].MEMBERS ON AXIS(1) FROM [TS_C01/TS_C01_NW001]

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

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

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

... 1 more

Caused by: java.rmi.RemoteException: Service call exception; nested exception is:

java.lang.NullPointerException

at com.sap.ip.bi.sdk.dac.connector.xmla.standalone.MsXmlAnalysisSoapStub.execute(MsXmlAnalysisSoapStub.java:147)

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

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

... 3 more

Caused by: java.lang.NullPointerException

at com.sap.ip.bi.sdk.dac.connector.xmla.impl.DatasetContentHandler.endElement(DatasetContentHandler.java:729)

at com.sap.engine.lib.xml.parser.handlers.SAXDocHandler.endElement(SAXDocHandler.java:156)

at com.sap.engine.lib.xml.parser.XMLParser.scanEndTag(XMLParser.java:1951)

at com.sap.engine.lib.xml.parser.XMLParser.scanElement(XMLParser.java:1844)

at com.sap.engine.lib.xml.parser.XMLParser.scanContent(XMLParser.java:2440)

at com.sap.engine.lib.xml.parser.XMLParser.scanElement(XMLParser.java:1841)

at com.sap.engine.lib.xml.parser.XMLParser.scanContent(XMLParser.java:2440)

at com.sap.engine.lib.xml.parser.XMLParser.scanElement(XMLParser.java:1841)

at com.sap.engine.lib.xml.parser.XMLParser.scanContent(XMLParser.java:2440)

at com.sap.engine.lib.xml.parser.XMLParser.scanElement(XMLParser.java:1841)

at com.sap.engine.lib.xml.parser.XMLParser.scanContent(XMLParser.java:2440)

at com.sap.engine.lib.xml.parser.XMLParser.scanElement(XMLParser.java:1841)

at com.sap.engine.lib.xml.parser.XMLParser.scanDocument(XMLParser.java:2843)

at com.sap.engine.lib.xml.parser.XMLParser.parse0(XMLParser.java:229)

at com.sap.engine.lib.xml.parser.AbstractXMLParser.parseAndCatchException(AbstractXMLParser.java:145)

at com.sap.engine.lib.xml.parser.AbstractXMLParser.parse(AbstractXMLParser.java:160)

at com.sap.engine.lib.xml.parser.AbstractXMLParser.parse(AbstractXMLParser.java:261)

at com.sap.engine.lib.xml.parser.Parser.parseWithoutSchemaValidationProcessing(Parser.java:280)

at com.sap.engine.lib.xml.parser.Parser.parse(Parser.java:342)

at com.sap.engine.lib.xml.parser.SAXParser.parse(SAXParser.java:125)

at com.sap.engine.services.webservices.jaxrpc.wsdl2java.soapbinding.MimeHttpBinding.handlerSAXMessage(MimeHttpBinding.java:1570)

at com.sap.engine.services.webservices.jaxrpc.wsdl2java.soapbinding.MimeHttpBinding.call(MimeHttpBinding.java:1449)

at com.sap.ip.bi.sdk.dac.connector.xmla.standalone.MsXmlAnalysisSoapStub.execute(MsXmlAnalysisSoapStub.java:140)

... 5 more

Former Member

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question