XML parser error when invoking BI-SDK XMLA connector from servlet to BW

[andrewsong]

Hi,

I have deployed BI Java SDK 3.5 onto SAP J2EE 6.4 SP8. I've built a simple servlet that attemps to connect to a BW 3.0B system using the XMLA connector. However, when the following code is called:

IBIConnection connection = (IBIConnection)cf.getConnectionEx(cs);

the following stack trace is observed:

CAUGHT EXCEPTIONCannot open the connection

com.sap.ip.bi.sdk.exception.BIConnectionFailedException: Cannot open the connection

at com.sap.ip.bi.sdk.dac.connector.xmla.XmlaConnectionFactory.getConnectionEx(XmlaConnectionFactory.java:154)

at com.acn.blabla.servlet.Crap.doGet(Crap.java:48)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:740)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)

at com.sap.engine.services.servlets_jsp.server.servlet.InvokerServlet.service(InvokerServlet.java:153)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)

at com.sap.engine.services.servlets_jsp.server.HttpHandlerImpl.runServlet(HttpHandlerImpl.java:385)

at com.sap.engine.services.servlets_jsp.server.HttpHandlerImpl.handleRequest(HttpHandlerImpl.java:263)

at com.sap.engine.services.httpserver.server.RequestAnalizer.startServlet(RequestAnalizer.java:339)

at com.sap.engine.services.httpserver.server.RequestAnalizer.startServlet(RequestAnalizer.java:317)

at com.sap.engine.services.httpserver.server.RequestAnalizer.invokeWebContainer(RequestAnalizer.java:810)

at com.sap.engine.services.httpserver.server.RequestAnalizer.handle(RequestAnalizer.java:238)

at com.sap.engine.services.httpserver.server.Client.handle(Client.java:92)

at com.sap.engine.services.httpserver.server.Processor.request(Processor.java:147)

at com.sap.engine.core.service630.context.cluster.session.ApplicationSessionMessageListener.process(ApplicationSessionMessageListener.java:37)

at com.sap.engine.core.cluster.impl6.session.UnorderedChannel$MessageRunner.run(UnorderedChannel.java:71)

at com.sap.engine.core.thread.impl3.ActionObject.run(ActionObject.java:37)

at java.security.AccessController.doPrivileged(Native Method)

at com.sap.engine.core.thread.impl3.SingleThread.execute(SingleThread.java:94)

at com.sap.engine.core.thread.impl3.SingleThread.run(SingleThread.java:162)

Caused by: com.sap.ip.bi.sdk.exception.BIResourceException: Connection is not currently open

at com.sap.ip.bi.sdk.dac.connector.xmla.XmlaManagedConnection.assertConnection(XmlaManagedConnection.java:418)

at com.sap.ip.bi.sdk.dac.connector.xmla.XmlaManagedConnection.getConnection(XmlaManagedConnection.java:290)

at com.sap.ip.bi.sdk.dac.connector.impl.BIConnectionManager.allocateConnection(BIConnectionManager.java:28)

at com.sap.ip.bi.sdk.dac.connector.xmla.XmlaConnectionFactory.getConnectionEx(XmlaConnectionFactory.java:145)

... 19 more

Caused by: com.sap.ip.bi.sdk.exception.BIResourceException: Discover call for request DISCOVER_PROPERTIES failed

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

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

at com.sap.ip.bi.sdk.dac.connector.xmla.XmlaManagedConnection.assertConnection(XmlaManagedConnection.java:409)

... 22 more

Caused by: com.sap.ip.bi.sdk.exception.BIResourceException: Cannot send SOAP request

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

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

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

... 24 more

Caused by: java.lang.reflect.InvocationTargetException

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

at java.lang.reflect.Method.invoke(Method.java:324)

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

... 26 more

Caused by: com.sap.engine.services.webservices.jaxm.soap.accessor.NestedSOAPException: Unable to create message from source.

at com.sap.engine.services.webservices.jaxm.soap.SOAPPartImpl.setContent(SOAPPartImpl.java:176)

at com.sap.engine.services.webservices.jaxm.soap.SOAPMessageImpl.(SOAPMessageImpl.java:76)

at com.sap.engine.services.webservices.jaxm.soap.MessageFactoryImpl.createMessage(MessageFactoryImpl.java:35)

at com.sap.engine.services.webservices.jaxm.soap.SOAPConnectionImpl.call(SOAPConnectionImpl.java:207)

at com.sap.engine.services.webservices.jaxm.soap.SOAPConnectionImpl.call(SOAPConnectionImpl.java:131)

... 31 more

Caused by: com.sap.engine.lib.xml.parser.NestedSAXParserException: com.sap.engine.lib.xml.parser.ParserException: Expected space in XML Declaration.(:main:, row:1, col:20)(:main:, row=1, col=20) -> com.sap.engine.lib.xml.parser.ParserException: Expected space in XML Declaration.(:main:, row:1, col:20)

at com.sap.engine.lib.xml.parser.DOMParser.parse(DOMParser.java:143)

at com.sap.engine.lib.xml.parser.DOMParser.parse(DOMParser.java:157)

at com.sap.engine.services.webservices.jaxm.soap.SOAPPartImpl.parseDocument(SOAPPartImpl.java:209)

at com.sap.engine.services.webservices.jaxm.soap.SOAPPartImpl.setContent(SOAPPartImpl.java:173)

... 35 more

Any ideas? Could it be due to incompatible SOAP/webservices library between the SAP J2EE 6.4 SP8 and the BW system?

Thanks

[Former Member]

Hi Tan,

I have deployed BI Java SDK 3.5 onto SAP J2EE 6.4 SP5. I've built a simple servlet that attemps to connect to a BW 3.5 system using the XMLA connector. However, the following error was called:

Exception in thread "main" java.lang.NoClassDefFoundError: Helpers (wrong name:

com/sap/ip/bi/sdk/samples/Helpers)

at java.lang.ClassLoader.defineClass0(Native Method)

at java.lang.ClassLoader.defineClass(ClassLoader.java:537)

at java.security.SecureClassLoader.defineClass(SecureClassLoader.java:12

3)

at java.net.URLClassLoader.defineClass(URLClassLoader.java:251)

at java.net.URLClassLoader.access$100(URLClassLoader.java:55)

at java.net.URLClassLoader$1.run(URLClassLoader.java:194)

at java.security.AccessController.doPrivileged(Native Method)

at java.net.URLClassLoader.findClass(URLClassLoader.java:187)

at java.lang.ClassLoader.loadClass(ClassLoader.java:289)

at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:274)

at java.lang.ClassLoader.loadClass(ClassLoader.java:235)

at java.lang.ClassLoader.loadClassInternal(ClassLoader.java:302)

Could you please reply me back whats the problem with the coding. I have an other query How u have executed the servlet? Thanks in advance.

best regards,

Srinu...

[andrewsong]

Found the problem. Was a bug in a vanilla install of BW 3.0B

[Former Member]

"Found the problem. Was a bug in a vanilla install of BW 3.0B "

Can you please explain what was that installation problem?

regs

Anoop