connection error when viewing crystal report on SAP BO BI4.0

[Former Member]

We have issue when trying to view crystal report on BO BI4.0 server.

Our working step:

1. install oracle10gR2, BO BI 4.0 & client tools in Windows 2008 server.

2. configure Oracle ODBC 64 bit data source with successful test connection (do we need config ODBC 32 bit?).

3. run CMC from url: http://xxxxx:8080/BOE/CMC

4. create test folder & upload testWithoutDatabase.rpt and

testWithDatabase.rpt (both working well in BOE XI R2)

5. setting database configuration for testWithDatabase.rpt

6. click mouse right button & view it,

7. successful to view testWithoutDatabase.rpt; but failed to view testWithDatabase.rpt with error message popup:

The viewer could not process an event. Failed to open the

connection.

---- Error code:0 [CRWEB00000119]

I am wondering what is wrong or some configuration missing.

[Former Member]

You have to make sure that you have configured 32bit ODBC driver on client side and server side with 32 bit data source administration. You can find the 32 bit data source administration under folder C:\Windows\SysWOW64\odbcad32.exe. ( the data source name on server side and client side should be the same). The one under start-->adminstration tool is 64bit data source administration. I have encounterd the problem before.

[Former Member]

We are having the same issue:

• I have configured both the 32 bit and the 64 bit ODBC connections on the servers and have tested them all and they are all successful.
• I have updated the Database Configuration page with the correct credentials.

However, when I run the report I get the "Error code:0 [CRWEB00000119]" error. The report uses 2 data sources; one is SQL, and the other is MySQL. When the report is run locally on a desktop, it completes successfully. In the system, it does not. This is not happening with other Crystal reports in the system. Is anyone else experiencing anything similar, or does anyone know of a fix?

[ian_scott3]

Any update on this issue?

[Former Member]

May be it's not your issue, but I got this error message with a CR and it was a lack of authorization on the BO univers...

[Former Member]

Update the Data Source location from server to server

[Former Member]

We are experiencing the same issue when going from 3.1 to 4.0. Was it simply a matter of installing only the 32-bit ODBC driver?

Thanks,

Dave

[Former Member]

install Oracle Database 10g Release 2 (10.2.0.5) client odbc 32 only & fixed

[former_member744955]

We have now moved to Crystal Reports 2011 (as the browser for CR XI won't work with windows server 2008)

I installed CR Server 2011 on the server machine. I installed CR 2011 on my local machine.

I created a new report in CR 2011

When I publish (now called "report upload wizard") a report to the BI launch pad & then login via browser and click on the report I get an error:

The viewer could not process an event. Failed to open the connection. Error code CRWEB00000119

[former_member744955]

Did this work?

[Former Member]

Hello Everyone,

We are also facing the same issue. The crystal Reports migrated from BOBJ Dev XI 3.1 version to SBOP 4.0 version work fine. Where as the crystal reports migrated from BOBJ QA XI 3.1 version tp SBOP 4.0 version gives me "CRWEB00000119" error.

I checked the Database Configuration as given in SAP Note 1558691, I checked the config of QA system against Dev system where the CR's are working and everything is same, except for Dev CR is pointing to BW Dev system and QA CR is pointing to BW QA system.

So I am not sure why I am getting this connectivity error ("The viewer could not process an event. The database logon information for this report is either incomplete or incorrect. []

---- Error code:0 [CRWEB00000119]").

One more interesting point is, it gets the variables screen and allows us to select from the list of values so it is able to talk to BW system to get the list of values so I am not sure why it is throwing connectivity error while executing the report.

If anyone was able to solve this problem, please let me know.

Any comments will be greatly appreciated.

Thanks & Regards,

SRV

[Former Member]

install Oracle Database 10g Release 2 (10.2.0.5) client odbc 32 only & fixed

[Former Member]

We have the same issue.

[Former Member]

Hi Steven,

Improper database credentials for the report leads to this error. Kindly refer:

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

Regards,

Nakul

[Former Member]

Hi Nakul,

We tried using the suggested steps:

1.Log in to CMC.

2.Locate the report.

3.Right click on the report, select 'Database Configuration'.

4.Provide correct database connection details and click on 'Update'.

5. Re-run the report from Infoview

and got same error message.

After we configured 32 bit ODBC, we got different error message:

The viewer could not process an event. Your request could not be completed because a failure occurred while the report was being processed. Please contact your system administrator. [RCIRAS0546]

-

---

Error code:0 [CRWEB00000119]

Thanks,

Steven

Edited by: Steven Sun on Sep 23, 2011 9:08 PM

[Former Member]

Hi Steven, Were you able to resolve this issue? If so, what steps did you take to get there. I'm having the same problem with our installation.

Regards,

-Tim