Skip to Content
0
Former Member
Nov 02, 2005 at 02:28 PM

Problem with XMLA and BI SDK

35 Views

Hello everyone,

I am experiencing a very strange issue with regards to the BW XMLA connector.

Background information:

I would like to use the BI SDK in an iView in order to retrieve BW information. I have already written a test application that is doing 2 things: 1) establishing a connection with the XMLA connector 2) get the list of cubes available in BW. It appears that the connection can be established but once any method is called, a null pointer exception is returned.

Error log:

Date Time Severity Message

11/2/2005 13:30:22:757 Error at com.sap.engine.core.thread.impl3.SingleThread.run(SingleThread.java:162)

11/2/2005 13:30:22:757 Error at com.sap.engine.core.thread.impl3.SingleThread.execute(SingleThread.java:94)

11/2/2005 13:30:22:757 Error at java.security.AccessController.doPrivileged(Native Method)

11/2/2005 13:30:22:757 Error at com.sap.engine.core.thread.impl3.ActionObject.run(ActionObject.java:37)

11/2/2005 13:30:22:757 Error at com.sap.engine.core.cluster.impl6.session.UnorderedChannel$MessageRunner.run(UnorderedChannel.java:71)

11/2/2005 13:30:22:757 Error at com.sap.engine.core.service630.context.cluster.session.ApplicationSessionMessageListener.process(ApplicationSessionMessageListener.java:37)

11/2/2005 13:30:22:757 Error at com.sap.engine.services.httpserver.server.Processor.request(Processor.java:147)

11/2/2005 13:30:22:757 Error at com.sap.engine.services.httpserver.server.Client.handle(Client.java:92)

11/2/2005 13:30:22:757 Error at com.sap.engine.services.httpserver.server.RequestAnalizer.handle(RequestAnalizer.java:239)

11/2/2005 13:30:22:757 Error at com.sap.engine.services.httpserver.server.RequestAnalizer.invokeWebContainer(RequestAnalizer.java:821)

11/2/2005 13:30:22:757 Error at com.sap.engine.services.httpserver.server.RequestAnalizer.startServlet(RequestAnalizer.java:318)

11/2/2005 13:30:22:757 Error at com.sap.engine.services.httpserver.server.RequestAnalizer.startServlet(RequestAnalizer.java:340)

11/2/2005 13:30:22:757 Error at com.sap.engine.services.servlets_jsp.server.HttpHandlerImpl.handleRequest(HttpHandlerImpl.java:263)

11/2/2005 13:30:22:757 Error at com.sap.engine.services.servlets_jsp.server.HttpHandlerImpl.runServlet(HttpHandlerImpl.java:385)

11/2/2005 13:30:22:757 Error at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)

11/2/2005 13:30:22:757 Error at com.sap.engine.services.servlets_jsp.server.servlet.InvokerServlet.service(InvokerServlet.java:153)

11/2/2005 13:30:22:757 Error at com.myCompany.experiment.TestXMLA2.doContent(TestXMLA2.java:48)

11/2/2005 13:30:22:757 Error at com.sap.ip.bi.sdk.dac.connector.xmla.XmlaOlap.getSchema(XmlaOlap.java:109)

11/2/2005 13:30:22:757 Error at com.sap.ip.bi.sdk.dac.connector.olap.CommonConnection.getSchema(CommonConnection.java:99)

11/2/2005 13:30:22:742 Error at com.sap.ip.bi.sdk.dac.connector.olap.CommonConnection.assertConnectedToMDR(CommonConnection.java:117)

11/2/2005 13:30:22:742 Error at com.sap.ip.bi.sdk.dac.connector.xmla.impl.Connection.connectMdr(Connection.java:203)

11/2/2005 13:30:22:742 Error at com.sap.ip.bi.sdk.dac.connector.xmla.impl.Connection.getDataSourceType(Connection.java:225)

11/2/2005 13:30:22:742 Error java.lang.NullPointerException

Connection Parameters:

Username: MyLoginName

Password: MyPassword

URL: http://mySys.MyCompany.com:1080/sap/bw/xml/soap/xmla

DataSource: (tried: local, server, default, analysis, among many others)

Statefulness: false

language: EN

logonmethod_uid: true

Important things I have noticed:

1) When I try to access the URL of the WSDL file on Firebird: http://mySys.MyCompany.com:1080/sap/bw/xml/soap/xmla it works.

2) When I try to access the URL of the WSDL file on IE: http://mySys.MyCompany.com:1080/sap/bw/xml/soap/xmla it works.

3) When I try to access the URL of the WSDL file on Firebird and automatic logon: http://myLoginName:myPasword@mySys.MyCompany.com:1080/sap/bw/xml/soap/xmla it works

4) When I try to access the URL of the WSDL file on IE and automatic logon: http://myLoginName:myPassword@mySys.MyCompany.com:1080/sap/bw/xml/soap/xmla it does NOT work

5) When I try to directly debug in Eclipse (Netweaver Developer Studio) using the WSDL file of the XMLA web service, I get the following error Message: "java.io.IOException: Server returned HTTP response code: 502 for URL: http://mySys.MyCompany.com:1080/sap/bw/xml/soap/xmla

6) When I use JPivot a web based OLAP client with a XMLA connector, I am able to browse cubes in BW. However it is important to note that this software does not seem to use the "Discover" methods of the XMLA web service... It directly accesses a Catalog and performs a MDX query to render the cube on the client side.

I hope I have described the problem in enough details.

Thanks everyone for your help,

Harry.