You must have the correct database access permissions to run Cognos reports

Content

Problem:
Attempting to run a Cognos report using an Oracle database results in the following error message: An error occurred while performing operation 'sqlPrepareWithOptions' status='-9' 

Symptom:
When you run a report from your application, you see the following error on your Cognos viewer page:
UDA-SQL-0107 A general exception has occurred during the operation "prepare".ORA-00942: table or view does not exist RSV-SRV-0042 Trace back: RSReportService.cpp(826): QFException: CCL_CAUGHT: RSReportService::process() RSReportServiceMethod.cpp(259): QFException: CCL_RETHROW: RSReportServiceMethod::process(): reportEditQuerySpecification_Request RSASyncExecutionThread.cpp(789)  

Cause:
The user that is attempting to run the reports, from the IBM Atlas Policy Suite application, does not have the correct permissions on the database objects, such as table,view,procedures, and functions.

Resolving the problem:
Grant the user permissions on the required views, tables, procedure, and functions.

Example for IBM Atlas Policy Suite V6 and later with IBM Cognos 10.2:
Atlas report user: PSSRPTUSER
Cognos user: cognos_user

Ensure that cognos_user has an account that is unlocked and is not expired. If account is locked or expired, complete the following steps to resolve the issue:

1. Log into sqlplus as the system administrator.
2. Run the following command: C:\> sqlplus sys/admin@orcl as sysdba 
3. Enter the following command: sql> alter user cognos_user identified by cognos_user; 
4. Enter the following command: sql> alter user cognos_user account UNLOCK;