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.