SAP Knowledge Base Article - Public

1685743 - The viewer could not process an event , the database information is either incomplete or incorrect [CRWEB00000119] ERROR when tried to view crystal report on ODBC/OLEDB connection

Symptom

  • Create a ODBC/OLEDB 64 bit connection
  • Able to refresh the Crystal Report from CR 2011 designer.
  • Publish the report in Crystal Report Server 2011 , gives error

The viewer could not process the event, the database information is either incomplete or incorrect.[CRWEB00000119]

 

Environment

  • Crystal Reports Server 2011(4.0 Sp02)
  • Windows Server 2008 R2
  • Tomcat Application server
  • MS SQL Server 2005 Reporting database

Reproducing the Issue

  1. Create an 64 bit ODBC Data Source Name(DSN) on the BOE server.
  2. Open a Crystal Report in CR 2011 designer.
  3. Set the data source connection.
  4. View and Refresh the report in designer.
  5. Save the report in enterprise.
  6. Browse to the report in CMC and view it.
  7. The report gives error.
  8. Repeat the same steps for OLEDB connection.

Cause

  • The ODBC/OLEDB 32 bit connection was not created as the reporting database is installed on 32 bit server operating system

Resolution

  1. On the BOE server browse to the location C:/windows/syswow64/odbcad32.exe
  2. Launch the odbcad32.exe.
  3. Click on the system tab.
  4. Add the new system DSN.

For the 32 bit OLEDB connection.

  1. Open the Internet Explorer (32 bit) on the Server .
  2. Browse to C:/Windows/syswow64/
  3. Paste the .udl file on the above location
  4. Once the above necessary connections are created , the reports are successfully viewed in CMC/BILaunchpad

NOTE: .udl file is the connection file to create OLEDB connection

 

Keywords

CRWEB00000119 , ODBC , Crystal reports , BI launchpad, 4.0 , KBA , BI-BIP-CRS , SAP Crystal Server , Problem

Product

SAP Crystal Server 2011, feature pack 3