Former Member

March 22, 2010 1 minute read

Tips on Xcelsius and SAP NetWeaver BW connection : #2032 error

In this my first blog i explain a solution about a problem that can be appear during the creation of a SAP NetWeaver BW connection on Xcelsius.

First at all, I would remember the basis requirement’s for create a SAP BW connection on Xcelsius:·

on the client side : Xcelsius Enterprise Designer 2008 SP2 (trial or engage versions do not offer this connectivity) and SAP GUI patch 901 or above·
on the server side : NW 7.0 EhP1 SP5 with ABAP and Java stacks.

The problem that can be raised during the creation of SAP Netwever BW connection on Xcelsius is the popup window with the mysterious error message: #2032:

To find the cause of this error, i have monitored the HTTP request and HTTP response during the creation of a SAP BW connection on Xcelsius by freeware software Fiddler2 that it can download by this link: http://www.fiddler2.com/.
By this software, I finded the reason behind the error message #2032: Xcelsius wasn’t able to translate the host name of SAP BW application server to a valid IP address .

So as a workaround, i have written a map rule for the hostname used by Xcelsius ( that in the example image is server.ibi.it ) and the IP address of SAP BW application server in the hosts file.

The hosts file’s is a computer file used in an operating system to map hostnames to IP addresses and his location is: %SystemRoot%\system32\drivers\etc\.

Then i created a SAP Netweaver BW connection on Xcelsius with successful.

17 Comments

You must be Logged on to comment or reply to a post.

Former Member

March 23, 2010 at 3:10 am

Hi, great blog with an approach I've never seen before.

I had the same mysterious error and solved it through changing the default port of our SAP NetWeaver Portal in table RSPOR_T_PORTAL. I was accessing the queries through VPN and the port was internal only. I didn't know it used the Portal to retrieve the data structure as well as runtime.

Former Member

Blog Post Author

March 23, 2010 at 3:20 am

Hy Andrew,
Xcelius to retrieve data from a SAP BW connection use the BICS remote web service that it's publish on Java Application Server.
Thank's for your compliment's.

Regards
Andrea Maraviglia

Former Member

August 23, 2012 at 3:22 pm

I have the same problem and I would like to try your solution - I can not see the pictures of your post- would you mind posting them to my mail directly?

emaiaso@arcor.de

thanks again

Manu

Former Member

Blog Post Author

September 5, 2012 at 10:22 am

Hi Emanuela,

i'm sorry but there is some problems in the blog.

I suggest you to see the following SAP Note:

1408384

1686040

1612599

Andrea

Alexander Schuchman

March 23, 2010 at 5:24 am

Any concerns about performance of these dashboards hitting the BI Java directly with no ability to cache the result?
What about the additional load you are putting on the Java environment and it's impact to BI traditional reporting?

Just curious to hear your opionions on these questions.

Former Member

March 23, 2010 at 11:03 am

Thanks for a great blog!

OSS notes 1408354 and 1408384 has some tips on error 2032 in Xcelsius with SAP NW BI Connector.

Rajendrakumar Gaikwad

July 22, 2010 at 11:40 pm

Hi
My Portal is NW7 SP17.
Do i need to Upgrade the Portal to EHP1 SPS5
or i can just apply the BI Related Support Pack (BI-BASE-S ,BIWEBAPP) to the Portal to get the BICSRemote Service ?

Regards
Rajendra

Former Member

Blog Post Author

September 5, 2012 at 10:30 am

Hi,

i suggest you to read the SAP Note:

1650894

Andrea

Former Member

August 23, 2011 at 4:46 am

Hi All,

Well I am having this 2032 error on Xcelsius (Dashboard Design V 6.0 Build 14) when trying to setup a Neweaver BW Connection. I have added the crossdomain.xml in C:\Inetpub\wwwroot but stil getting the same error to enable security settings in flash player.

For me friddler shows this and it is really weird.
Result: 404
Host: bicsremotecrossdomain.xml
URL: /

and few days ago, I've seen a note concerning this error and the webservice bicsremote stuff.

Any help is really appreciated, because this error is blocking me.

Many thanks,
Amin.

Former Member

Blog Post Author

August 23, 2011 at 10:19 pm

Hi,
by fiddler, you can verified the messages flow with SAP BW.

I suggest you to follow the workround described in the blog.

Andrea

Avinash Verma

July 18, 2012 at 6:07 pm

Hi Andrea,

I am trying to connect BW 7.3 -> Xcelsius SP4 enterprise edition, but getting same error #2031 with SAP BW connectivity even after following all mentioned steps. (hostfile entries done)

Is there any other workaround to remove this error?

Can you please upload all the screenshots again, as it is not available now.

Regards,

Avinash

Former Member

September 4, 2012 at 2:47 pm

Hi Avinash,

Have you got your problem resolved. I would like to know the correct Java stack required for NetWeaver 7.3

Please do let me know if you got the answer.

Regards

Maruti

Former Member

Blog Post Author

September 5, 2012 at 10:18 am

Hi,

you can ckeck these SAP Note :

1408384

1686040

1612599

1650894

that describe the problem and suggest a solution.

Andrea

Former Member

Blog Post Author

September 5, 2012 at 10:20 am

i think that there is a problem on SAP BW about the portal configuration.

You can check the mentioned below.

Andrea

Former Member

September 5, 2012 at 11:20 am

Hi everybody

thanks for the replies

I passed the issue to the Basis colleagues and actually there was with the portal configuration.

They fixed it and it works

thanks again:-)

Manu

Former Member

March 5, 2013 at 8:26 am

Hi Andrea,

I got the error #2032 and here are the messages from Fiddler. Do you have any idea on this?

Response Header Tab

HTTP/1.1 500 Internal Server Error

Text View Tab

1e04

<SOAP-ENV:Envelope xmlns:SOAP-ENV="http://schemas.xmlsoap.org/soap/envelope/" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" ><SOAP-ENV:Body><SOAP-ENV:Fault><faultcode>SOAP-ENV:Client</faultcode><faultstring>com.sap.engine.services.ejb.exceptions.BaseRemoteException: Exception in method com.sap.ip.bi.bics.remote.BicsRemoteObjectImpl0_0.getDesignTimeInfo(com.sap.ip.bi.bics.remote.elements.connection.WsConnectionInfo).

at com.sap.ip.bi.bics.remote.BicsRemoteObjectImpl0_0.getDesignTimeInfo(BicsRemoteObjectImpl0_0.java:368)

at com.sap.ip.bi.bics.remote.BicsRemote_Stub.getDesignTimeInfo(BicsRemote_Stub.java:326)

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.engine.services.webservices.runtime.EJBImplementationContainer.invokeMethod(EJBImplementationContainer.java:126)

at com.sap.engine.services.webservices.runtime.RuntimeProcessor.process(RuntimeProcessor.java:157)

at com.sap.engine.services.webservices.runtime.RuntimeProcessor.process(RuntimeProcessor.java:79)

at com.sap.engine.services.webservices.runtime.servlet.ServletDispatcherImpl.doPost(ServletDispatcherImpl.java:92)

at SoapServlet.doPost(SoapServlet.java:51)

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

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

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

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

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

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

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

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

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

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

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

at com.sap.engine.core.cluster.impl6.session.MessageRunner.run(MessageRunner.java:41)

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:104)

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

Caused by: java.lang.RuntimeException: com.sap.ip.bi.bics.remote.impl.rmi.ApplicationCreationException: Could not to create the application. This is probably due to a misconfigured Abap/Java connection.

at com.sap.ip.bi.bics.remote.impl.rmi.cc.AbstractConnectionContext.cleanup(AbstractConnectionContext.java:340)

at com.sap.ip.bi.bics.remote.BicsRemoteImpl.getDesignTimeInfo(BicsRemoteImpl.java:194)

at com.sap.ip.bi.bics.remote.BicsRemoteBean.getDesignTimeInfo(BicsRemoteBean.java:109)

at com.sap.ip.bi.bics.remote.BicsRemoteObjectImpl0_0.getDesignTimeInfo(BicsRemoteObjectImpl0_0.java:359)

... 26 more

; nested exception is:

java.lang.RuntimeException: com.sap.ip.bi.bics.remote.impl.rmi.ApplicationCreationException: Could not to create the application. This is probably due to a misconfigured Abap/Java connection.</faultstring><detail><ns1:java.rmi.RemoteException xmlns:ns1='http://sap-j2ee-engine/client-runtime-error'>com.sap.engine.services.ejb.exceptions.BaseRemoteException: Exception in method com.sap.ip.bi.bics.remote.BicsRemoteObjectImpl0_0.getDesignTimeInfo(com.sap.ip.bi.bics.remote.elements.connection.WsConnectionInfo).