Skip to Content

Crystal Report BO 4.2 The viewer could not process an event

After migrating Crystal Report BO 4.2 reports, when refreshed the reports the following errors appear:

"The viewer could not process an event. Failed to open the connection.
Details: Logon to underlying database failed [] "

"The viewer could not process an event. Error in File ps_xxxxxx.rpt:
The table could not be found. []
---- Error code: 0 [CRWEB00000119] "

"The viewer could not process an event. Business View error in Dynamic DataConnection.
"ReportName" []
---- Error code: 0 [CRWEB00000119] "

The migration was between environments that are in different domains, promoting the originals reports from Production environment of one domain to Development envirnomnet in the other domain.

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • Posted on Oct 21, 2019 at 07:34 PM

    What type of database connection do the reports use? If it's ODBC, then you need to make sure that you have the correct 32-bit ODBC connection set up in the environment you migrated to. The ODBC connections have to have the same name as in Production, but don't have to point to the same database, just a database that has the same structure.

    Are you using Crystal for Enterprise or "classic" Crystal? If it's CR for Enterprise, you'll need to migrate the connections, which can then be manually pointed to the correct database(s), and possibly the UNX universes from Prod as well.

    If it's classic Crystal, you'll probably have to update the Database Configuration for each report that you migrated.

    It also looks like you're using a Business View, which could either be from a UNX universe for CR for Enterprise or from the Business View Manager (BVM) for classic Crystal. If it's from the BVM, you need to make sure that you migrate the "Repository Objects" from Prod to Dev. Then you'll have to update the connection information in the "Data Connection" objects in the BVM. If it's CR for Enterprise, updating the universe connection(s) will resolve the issue.


    Add a comment
    10|10000 characters needed characters exceeded

    • It sounds like the repository objects from the BVM didn't get migrated. Based on the error that you received, your report is using one or more business views that were built in the BVM. When you promote the reports again (which you'll have to do), be sure to go to the dependencies after selecting the reports. You'll need to select all of the dependencies to make sure that the objects from the BVM are migrated.

      If there's still a problem after that, you'll need to run the BVM (which is part of the Client Tools install.) You'll need to look at a couple of things:

      1. For each Data Connection (object name should end in "_DC", but may be different), you need to make sure that it's set to automatically log in, that the database connection information is correct for the environment, and that the connection works. Depending on how security is configured in the BVM, you may need to login as Administrator to do this. The connection may be configured to be "dynamic", which means that it will point to a different database based on the response to a prompt. In this case you'll need to make sure that at least one of the connections is working correctly and then pick the appropriate parameter when you run the report.

      2. Check the security by right-clicking on the "Dynamic Cascading Parameters" folder and make sure that either Everyone or the appropriate user groups have access to use all of the objects in the BVM.

      NOTE: If you're not familiar with the BVM and dynamic parameters in Crystal, there are several pieces with similar names that go together to create a dynamic prompt:

      Data Connection - name ends in "_DC". This is the connection to the database.

      Data Foundation - name ends in "_DF". This is similar to the Database Expert in Crystal where you can join tables together or create a command to get data.

      Business Layer - name ends in "_BL". This is where the fields that are available for the prompt are defined.

      Business View - name ends in "_BV". This is like the Business Layer and contains the same information. Even though they basically duplicate each other, both must be configured for everything to work right. Business Views can be used to provide data in a report.

      List of Values - has no suffix. This is where the description and value fields for a dynamic parameter are defined. It's also where the hierarchy for cascading parameters is defined. Can be selected for dynamic prompts in Crystal.

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.