Cannot View Reports in CA Business Intelligence with an Oracle Database

Troubleshooting Guide › Troubleshooting the Reporting Service › Cannot View Reports in CA Business Intelligence with an Oracle Database

Cannot View Reports in CA Business Intelligence with an Oracle Database

Symptom:

I use an Oracle 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:
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.
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.
Verify that the Oracle system environment variables are defined as follows, where Oracle_home is the directory in which you installed Oracle:
- ORACLE_HOME points to the Oracle_home directory
- PATH contains the Oracle_home/bin directory
- TNS_ADMIN points to the Oracle_home/network/admin directory
Verify that TNS is correctly defined, as follows:
1. Open a command prompt window.
2. Run the following command:
```
tnsping TNSname
```
  TNSname
  
  Defines the name of the TNS.
  
  If you receive an error message, TNS is not correctly defined.
Verify that you use the correct credentials to access the database, as follows:
1. Open a command prompt window.
2. Run the following command:
```
sqlplus user/password@TNSname
```
  user
  
  Defines the name of the RDBMS administrative user that you created when you prepared the database for CA ControlMinder Enterprise Management.
  
  password
  
  Defines the user password.
  
  If you cannot log on to the SQL Command Line, the database credentials are incorrect.
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 are identical to the values that you specified in Step 5:
  - <username> is identical to user
  - <password> is identical to password
  - <datasource> is identical to TNSname
(UNIX) Run the commands in Step 4 and Step 5 as the user that you specified when you installed CA Business Intelligence.
You specify this user in the CMS Database Settings page of the CA Business Intelligence installation wizard. This step verifies that the user has read and execute access to the entire Oracle_home directory.