Troubleshooting Guide › Troubleshooting the Reporting Service › Cannot View Reports in CA Business Intelligence with an MS SQL 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:
- Verify the BusinessObjects version number, as follows:
- 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.
- Enter your username and password, and click Log On.
The Central Management Console appears.
- Click Servers, hostname, Web_IntelligenceReportServer, Metrics.
The BusinessObjects version number is displayed.
- Verify that the BusinessObjects version number is either 11.5.8.1061 or higher, or 11.5.10.1263 or higher.
- Verify the CA Business Intelligence version number, as follows:
- Open the following file on the Report Portal:
- (Windows) C:\Program Files\CA\SC\CommonReporting\version.txt
- (UNIX) /opt/CA/SC/CommonReporting/version.txt
- Verify that the CA Business Intelligence version is 2.1.13.
- Verify that the database credentials are correct, as follows:
- Click Start, Programs, Microsoft SQL Server 2005, SQL Server Management Studio.
The SQL Server 2005 login page appears.
- Type the username and password for the RDBMS administrative user that you created when you prepared the database for CA ControlMinder Enterprise Management.
- Click Connect.
You are logged in to the SQL Server Management Studio. If you cannot log in, the database credentials are incorrect.
- Verify that the import_biar_config.xml file has the correct values, as follows:
- Open the import_biar_config.xml file that you used to deploy the report package on the Report Portal.
- 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.
Copyright © 2013 CA Technologies.
All rights reserved.
|
|