Troubleshooting Guide › Troubleshooting the Reporting Service › How to Troubleshoot the Reporting Service › Test the CA Access Control Universe Connection

Test the CA Access Control Universe Connection

The CA Access Control Universe is provided by CA to simplify the creation of reports from the CA Access Control reporting service central database.

Note: For more information about the CA Access Control Universe, see the Enterprise Administration Guide.

If after you install the standard CA Access Control reports you experience issues with the reporting service connection, you should test and modify the connection as required.

To test the CA Access Control Universe Connection

1. Select Start, Programs, Business Objects XI Release 2, BusinessObjects Enterprise, Designer.

   The User Identification dialog appears, letting you log in to BusinessObjects Designer.

2. Enter your credentials and click OK.

   The welcome screen of the Quick Design wizard appears.

3. Clear the Run this Wizard at Startup check box, and click Cancel

   An empty Designer session opens. The user name and repository name appear in the title bar.

4. Click File, Import, browse to the directory that contains the CA Access Control Universe, select the CA Access Control universe, then click OK.

   The CA Access Control Universe imports successfully and opens in the current Designer window.

   Note: The CA Access Control Universe is stored under CA Universe\CA Access Control in the directory designated as the default universe file store.

5. Click Tools, Connections

   The Wizard Connection dialog appears.

6. Select the Access_Control1 connection that you want to test, then click Test.

   A message confirms that the connection is responding. If the connection is not responding you receive an error message.

7. If you received an error, click Edit to modify connection settings:
   • Database Middleware Selection—Oracle\Oracle 10\Oracle Client
   • Type—Secured
   • Name—Access_Control1
   • User name—Oracle_adminUserName
   • Password—Oracle_adminUserPass
   • Service—Oracle_TNS_Name

   Repeat step 6 as required to test the connection.