Error #2032 when using SAP NetWeaver BI Connection

[lieven_vanherpe2]

Hi,

I'm trying to use to new SAP NetWeaver BI Connection in Xcelsius SP2, but when I try to connect to a BEx Query, I receive error #2032.

I have a crossdomain.xml file in the Tomcat root of the BO-server, and the Adobe Global Security Settings are also filled in with all directories of my BO-server.

Has someone an idea why this error occurs, and how to solve it?

I'm working on Sap NetWeaver 7.0.1 SP5.

Lieven

[Former Member · Accepted solution]

Hi All

We were also receiving the #2032 error when trying to open a BI query on Xcelsius 2008 using the SAP netweaver BI connection.

We have the following configuration:

Server 1:

Xcelsius 2008 SP2

SAP GUI 7.10 SP14

Bex 7.10 SP10

MS Office 2007

IE 7

Server 2:

BI ABAP with EHP1 SP5

Server 3:

EP 7 Portal with EHP1 SP5 (including BI Java components on EHP1 SP5)

Logged this with SAP and tried numerous things to resolve the error such as adding the crossdomain.xml file. Alter macro settings on Office 2007. Eventually i tried to access the Portal from the Xcelsius server (server 1) and it complained about IE7 security and i added the Portal URL to the trusted sites under the IE 7 security options.

This resolved the error #2032 and we can now open BI queries on Xcelsius 2008 using the SAP netweaver BI connection.

Regards,

Gavin Wiggill

[Former Member · Accepted solution]

Gavin

Thank you very much. This has solved my problem!

Johan du Plessis

[Former Member · Accepted solution]

Hello Gavin and all other experts

We also receive the #2032 error when trying to open the BI query on Xcelsius 2008 using the SAP netweaver BI connection.

Our configuration is

Xcelsius SP2

BW 7.01 SP5

Java Stack SP5

ABAP SP5

new auth object S_RS_XCLS assigned

0DASHBOARD_TEMPLATE active

SAP GUI 710

BEx 7.0 patch 1001

Office 2003, IE 6 Browser

BW System in a federated portal network

I modified the portal URL to producer portal as descibed in SAP Note Number: 1408354 Error 2032 - Federated Portal Network and Xcelsius

As advised from Gavin I also changed the macro settings on Office and added my prod. Portal URL to the trusted sites in the IE 6 security options.

We don't connect to the server via VPN.

But I cant resolve the problem.

Does anybody know other configuration steps to solve the error.

Thanks

Rene

[Former Member · Accepted solution]

hi Rene

r u able to solve this issue? i am having same issue. please guide me

[Former Member · Accepted solution]

Hy, you can find a solution on this blog:

/people/andrea.maraviglia/blog/2010/03/22/tips-on-xcelsius-and-sap-netweaver-bw-connection-2032-errorSDNWeblogs_BusinessIntelligencebi%2528SAPNetworkWeblogs%253ABusinessIntelligence+%2528BI%2529%2529

[Former Member]

Hi All,

We were getting the same issue (Error #2032, while connecting to Bex query from DashboardDesign tool, "The First Post"),

The issue got resolved by installing  "patch 14 for DashboardDesign 4.0 SP2".

You guys can try the same.

Thanks

Riyaz

[Former Member]

I just attended SAP TechEd09 and had a hands on session working with Xcelsius 2008 directly to a BW query. Obviously it was a canned scenario and worked fine but did highlight some prerequisites. It seems that all restrictions should be dealt with in the query and that the query should not require variables selected at run time. I thought this was the reason for my Error #2032 but after selecting an existing KPI query that requires no user selected variables at runtime I still get this error.

Please let us know the outcome of the OSS call in this thread.

[Former Member]

Hi

I am trying to connect Xcelsius2008 SP2 to BW 7.0 (EhP1 SPS5) using the SAP NetWeaver BI Connection. I have the right versions of Xcelsius and BW backend and frontend. I am able to connect to the BW system, see a list of queries from the BI NetWeaver connection from Xcelsius; however I get the same error mentioned in this thread 'error #2032' when I select one of the queries. Does anyone have a resolution to this error?

[hasba_younes]

Hello experts,

we're getting the same error when using the NetWeaver connection.

Xcelsius SP2

BW 7.1 SP5

Java Stack SP5

ABAP SP5

Does anyone have a resolution to this error?

thanks

[Former Member]

What is your BEx 710 front end patch level?

[hasba_younes]

Hi,

it's Patch level 15

[Former Member]

There is no patch 15 available for BEx 7.0 (based on SAP GUI 710). Are you using SAP GUI 710 or 640? Also do you have the BI Addon (BEx 7.0 tools)?

[hasba_younes]

Sorry!

Patch level 9 --> 710

[Former Member]

It should be 901 or higher.

[Former Member]

Deepu

I am using the latest patch (>9) but still getting the error. I wanted to see if others faced a similar issue and have no resolution before I raise a message with SAP.

- Hari

[hasba_younes]

Hi Sasidharan,

where can i get this latest patch, do you have direct link?

thanks,

Best regards,

Younes

[Former Member]

Do you have the required authorization to run the query? For Xcelsius there is a new auth object available Auth Object: S_RS_XCLS.

Also make sure you activate the BEx 7.0 web template 0DASHBOARD_TEMPLATE.

Does all your BEx tools run without any issues?

[Former Member]

You can download the latest front-end patch form Service Marketplace. Choose - Support Packages and Patches - Entry by Application Group" SAP Frontend Components" BI ADDON FOR SAP GUI" BI 7.0 ADDON FOR SAP GUI 7.10 and download and install bi710sp10p_1001-10004472.exe.

- Hari

[hasba_younes]

All my BEx suite tools are working fine.

is this auth. object needed in my profile?

i'll try to run the template.

any other ideas?

thank you

[Former Member]

I have full access in the system. I created a role with the Xcelsius authorization and assigned it to my user. The dashboard template is also active. However I get the same error. Anything I am missing?

- Hari

[Former Member]

Hi,

I also have the same problem.

System settings: BI JAVA/ ABAP SP5, BEX Frontend Patch 10.1 Xcelsius SP2 with FP1 and I have SAP_ALL?

Thx,

regards CH_P

[hasba_younes]

Anbody who opened a SAP Call already for this?

os there any log files on the client side we can check?

it seems that many have the same issue. wondering if this integration already working.

thank you,

[Former Member]

Integration works fine in our environment, see the config below which I have.

Server: NW BW 7.0 EHP1 SPS 5 (AbAP and Java)

Client:

Windows XP

Xcelcius 2008 SP2

SAP GUI 710

BEx 7.0 patch 1001

Bex 3.X

Office 2007 with all the latest patches

Internet Explorer 7.0

You could also check whether the connection with BW backend and Portal (Java) system is working. You could use OSS note 937697 for this.

Thanks.

[Former Member]

Hi all!

I am facing the same problem and running out of ideas. A SAP ticket was placed last week, waiting for some useful hints now...

As I saw your "Software List" I was wondering, if "Office 2007" and "IE 7" are mandatory requirements. Actually, my system completely fulfils the Xcelsius and SAP version requirements but I am using Office/Excel 2003 and IE 8...

Might this be the reason?

THX a lot in advance!

Micha

[Former Member]

Try applying the BI Java patch mentioned in the note below:

https://service.sap.com/sap/support/notes/1380059

I do not think it is related to IE 8 and Office 2003.

[evonah]

We are using in total 6 different clients with Xcelsius 2008 Enterprise SP2. With two of them we can use SAP NetWeaver BI Connection and do not receive any error. The rest is showing the error message #2032.

There is one difference between the systems which are working and the ones which are not:

After selecting the query in the BI NetWeaver Connection there is an additional popup "Windows security" appearing.

--> The server sapbw100.xxxx at BicsRemote/Config1 requires a username and password.

Filling in the username and password the data from the query appear in the xcelsius.

With the clients which provide an error there is no such popoup.

If we create on an existing installation an .xlf file and open it on one which is not working, the Data Managers show the correct connection. As soon as we click on refreshing data, error #2032 appears.

System configuration clients:

Windows XP and Windows 7

Office 2007

SAP Business Explorer Patch 1001

Regarding the working clients:

One is working on XP the other on Windows 7

Both on Xcelsius 5.2.0.0

Installing the FixPatch for SP2 is also not helping to solve the problem.

All the inputs in this thread have been tested but without sucess. Till now we could not install note 1380059 since related notes are not yet released.

[Former Member]

Are all these clients in the same domain?

Is the IE security level set to the same level on all the clients?

Is there a Windows Firewall or any other firewall software running on the clients where you have issues?

Thanks.

[evonah]

We checked the clients again and it seems that some of them were not able to access the Java on the Netweaver. So we were changing the host file and add the link to the Java server.

After all the error #2032 is no longer appearing.

[Former Member]

Hi, Erich & All,

as you might have seen we are facing the same error (#2032) as you. Only difference: Your error obviously vanished yesterday...

Your two entries call my attention to more client-speciific issues, and I would appreciate it if you could clarify some points I might not have seen yet:

What role does the Internet Explorer play in establishing the connection? I ignored IE completely (as always) but now I wonder if this was an error. Do I have to configure some security issues within IE?

What exactly did you do to the hosts file (I guess it is the hosts file underneath...WINDOWS\system32\drivers\etc, right?). Did you simply add a line with <IP number of Java stack> <hostname of Java stack>?

A BIG THX for you...!

Michael

[Former Member]

We saved the Error #2032 by switching the link in the table RSPOR_T_PORTAL from Consumer Portal TEP to Producer Portal for the giving system. Afterwards that error did not occur anymore.

You might wanna try this, maybe it helps.

Regards.

[Former Member]

Hi Agata,

we already did this...

...but the error is loyal to us!

Anyway, thanks & regards!

Michael

[evonah]

Hi Michael

Answering your questions:

Yes, we were able to solve the problem with error #2032.

I cannot tell you how the security settings of IE are related with the error 2032. The only thing I know is after when you published the xcelsius files and you are going to launch them, there is where IE gets into the game.

It seems definition are transferred via SAPGUI protocol and data is transferred via other protocol which needs a correct DNS resolution. Tricky to find out the error was because we filled the IP address and not the hostname into the SAPLOGON.

Maybe you can test the following to know if you have access to the Netweaver and the Java Stack.

Create an example without BI Connection and publish it on the SAP BI system. (Menu SAP, Publish)

This connection seems to work with SAPGUI protocol.

Afterwards try to launch the example you just published (Menu SAP, Launch). At this time the connection with JAVA-Stack and IE will take place. If I do not have the parameters in the Host file and the system is not able to do the DNS resolution you will get an error in the IE.

That's how I can reproduce the error #2032.

The enty we made in the host file looks like this (C:\WINDOWS\system32\drivers\etc\hosts)

10.101.x.xx sapbw100 sapbw100.xxxxx.com

[Former Member]

Good morning, Erich!

Thank you very much for this detailled description of your problem (and solution!!!) environment. It will give me some new useful hints, some other paths to try.

My #2032 directly appears when choosing a BW query, so I didn't even try to publish something to SAP until now. But of course I will try it now, cause it makes sense to divide the problems into pieces and check if there are parts that work.

Part of my problem is the environment as a whole: I only can see (and influence) the Xcelsius part, the SAP staff is more than 100 kilometers away at our customer's side. With VPN and Co no real show stopper but it doesn't make it easier...

Thanks again & regards!

Michael

[hai_murali_here]

Hi,

This Error#2032 is from Adobe Error.This will be thrown when the server is busy to respond and there are so many connections it has to respond.

You just retry after sometime.And also check your BICS version through http://<Server>...../bicsremotedebug

Rgds,

Murali

[hai_murali_here]

Hi,

This Error#2032 is from Adobe Error.This will be thrown when the server is busy to respond and there are so many connections it has to respond.

You just retry after sometime.And also check your BICS version through http://<Server>...../bicsremotedebug

Rgds,

Murali

[Former Member]

Hi,

we have the same problems with error #2032 after selecting a query in Xcelsius.

The error occurs because Xcelsius tries to call the follwoing URL:

http://myserver:serverport/BicsRemote/Config1?style=document

The page doesn't exists: "404 Not Found - The requested resource does not exist."

Any ideas what kind of page this is?

Could you please post the full URL for getting the BICS Version: (http://<Server>...../bicsremotedebug) What is "..."?

The entry in "RSPOR_T_PORTAL" in field "URL_PREFIX" is "http://myserver:serverport". Is this enough?

Thanks in advance!

[Former Member]

Hi, all!

I just want to tell you, that our #2032-problem is fixed as well...

The reason obviously was, that I was trying to connect to the SAP BW from outside my customer's network, i.e. I have to connect via VPN. Alhough we already had unlocked some VPN-related port numbers due to earlier error messages (which were a little bit more specific...), it obviously had not been enough. And when facing #2032 we didn't think that this still may have something to do with the VPN...

A visit at the customer, i.e. a connect from within the network, showed me, that there was everything okay! No need to adjust something at the SAP system or at my client...

Regards!

Michael

[lieven_vanherpe2]

Deepu,

I wasn't able to test it yet, but I have some questions concerning this topic:

1. You have to publish the dashboard in SAP NetWeaver BI (e.g. SAP Portal). But is it still possible to export these dashboards to PDF or powerpoint? Are they still working then?

2. Is a combination of a SAP NetWeaver BI Connection and QaaWS / Live Office connection possible?

3. Can a hierarchy node variable be used in the BEx Query?

Lieven

[Former Member]

Please see comments in the blog below:

/people/francois.imberton/blog/2009/07/08/new-xcelsius-2008--netweaver-70-integration-soon-available

You will be able to use hieracrhy variables but not hierarchy display within the dashboard.

[lieven_vanherpe2]

I have already activated the 0DASHBOARD_TEMPLATE in the BW system, but I receive this message the moment I select my BEx query in the Connection.

According to the infrastructure people, the problem occurs due to not having a Java stack on our system. The connection cannot be achieved. At this moment they are installing this Java stack on our system.

I'll come back after the installation.

Lieven

[Former Member]

Make sure they follow the steps mentioned in note 917950 for setting up Java stack connection and validate the connection running the tool mentioned in 937697.

Xcelsius direct connector uses the Java stack for runtime.

[former_member186358]

Lieven,

You will not be able to connect to SAP BI directly at this point of time, you may wish to refer the link below.

-Anil

[Former Member]

This connector was released mid Sept 09, I installed it and works great!

[former_member186358]

Thanks for the Info!! Deepu,

It will be of great help if you can share the links related to EHP...i will ask our basis team, to apply it.

-Anil

[Former Member]

From http://service.sap.com/patches you can follow the link for SAP Netweaver 7.0 EHP1.

[Former Member]

Hi Deepu

How can i know if i have my BI ABAP and BI JAVA stacks installed?

[lieven_vanherpe2]

No, I try to connect to a BEx Query directly with the new SAP NetWeaver BI Connection.

This is a new feature in Xcelsius 2008 SP2.

Lieven

[Former Member]

Are you deploying to BOE or the SAP BW system? For this new connection to work you will have to deploy to SAP BW system from the SAP menu option within Xcelsius 2008 SP2.

You will need both BI ABAP and Java on 7.01 SP 5 for this to work.

Also make sure you have the 0DASHBOARD_TEMPLATE activated in the BW backend system.

[Former Member]

hi,

which way you trying to connect Bi query with xcelsius. Through Live office, if yes. then go to Data Manager --> Live office connection --> change the Session URL

http://<webserver>:8080/dswsbobje/services/session

Give your Bo server name and port No.

Regards,

Senthil k