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