Previous Topic: Report Server is Down or UnreachableNext Topic: Cannot View Reports in CA Business Intelligence with an Oracle Database


Cannot View Reports in CA Business Intelligence with an MS SQL Database

Symptom:

I use an MS SQL database as my central database, and I cannot view reports in CA Business Intelligence. When I try to view a report, I receive the following error message:

Failed connect

Solution:

The following process helps you troubleshoot the problem with CA Business Intelligence:

  1. Verify the BusinessObjects version number, as follows:
    1. Open the following URL:
      http://hostname:8080/businessobjects/enterprise115/adminlaunch/launchpad.html
      
      hostname

      Defines the name of the Report Portal host.

      The Central Management Console log on page appears.

    2. Enter your username and password, and click Log On.

      The Central Management Console appears.

    3. Click Servers, hostname, Web_IntelligenceReportServer, Metrics.

      The BusinessObjects version number is displayed.

    4. Verify that the BusinessObjects version number is either 11.5.8.1061 or higher, or 11.5.10.1263 or higher.
  2. Verify the CA Business Intelligence version number, as follows:
    1. Open the following file on the Report Portal:
      • (Windows) C:\Program Files\CA\SC\CommonReporting\version.txt
      • (UNIX) /opt/CA/SC/CommonReporting/version.txt
    2. Verify that the CA Business Intelligence version is 2.1.13.
  3. Verify that the database credentials are correct, as follows:
    1. Click Start, Programs, Microsoft SQL Server 2005, SQL Server Management Studio.

      The SQL Server 2005 login page appears.

    2. Type the username and password for the RDBMS administrative user that you created when you prepared the database for CA ControlMinder Enterprise Management.
    3. Click Connect.

      You are logged in to the SQL Server Management Studio. If you cannot log in, the database credentials are incorrect.

  4. Verify that the import_biar_config.xml file has the correct values, as follows:
    1. Open the import_biar_config.xml file that you used to deploy the report package on the Report Portal.
    2. Verify that the values for the following properties correspond to the values that you specified in Step 3:
      • <username> is identical to the username that you entered.
      • <password> is identical to the password that you entered.
      • <datasource> is identical to the name of the database that you entered.
      • <server> is identical to the name of the Report Server computer.