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
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...
Add a comment