Skip to Content
May 28, 2013 at 12:30 PM

Migrating CR XI R2 reports based on Universe to BI 4.0


Has anyone had success doing this?

I migrated a bunch of CR XI R2 reports from an XI R2 system to a clean BI 4.0 SP6 system, and none of the reports work via the BI Launch Pad. After ensuring that the report's database credentials are correct, I get the following error when I try to view on demand:

The viewer could not process an event. The database logon information for this report is either incomplete or incorrect. [] ---- Error code:0 [CRWEB00000119]

In the BI 4.0 system, the Webi reports based off of the same Universe work fine, so it isn't a user rights issue I don't think. Moreover, the CUID of the Universe is the same in both source and target systems.

I installed Crystal Reports 2011 on the server machine, and when I open one of these Crystal Reports from the BI 4.0 system I get the error:

Failed to open the connection.

Details: Update of the SQL command from the Universe failed. This report cannot be refreshed unless the SQL command is update from the Universe.

However, same goes if I try to run the report, Verify Database, or attempt Show SQL Query.

It seems as though all of the migrated Crystal Reports have become decoupled from the Universe they were based on in the source system. Has anyone encountered this, and better yet found a solution?