Troubleshooting
Problem
Error 'PLS-00201: identifier 'DBMS_LOCK' must be declared' when running USP_CHECKBATCHJOBSTATUS.
Symptom
English:
PLS-00201: identifier 'DBMS_LOCK' must be declared
German:
FUNCTION schemaname.USP_CHECKBATCHJOBSTATUS
On line: 14
PLS-00201: Bezeichner 'DBMS_LOCK' muss deklariert werden
Cause
The Oracle schema (the user used by the Controller application server to connect to the Oracle database) does not have access to the DBMS_LOCK package.
- In other words, the Oracle schema was not created with the required permissions (as per Cognos recommendations).
TIP: For full details of the permissions/script for how to create a new schema, see separate IBM Technote #.
Environment
Oracle database.
Resolving The Problem
Grant Execute permission to the Oracle user/schema used for the Controller application repository, by running the following script:
- GRANT execute ON DBMS_LOCK TO <schema_name>;
Steps:
1. Launch an Oracle tool (for example "SQL Plus Worksheet")
2. Connect/logon to the database, using administrative credentials
3. Run the following script:
- GRANT execute ON DBMS_LOCK TO <schema_name>;
Related Information
[{"Product":{"code":"SS9S6B","label":"IBM Cognos Controller"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"Controller","Platform":[{"code":"PF033","label":"Windows"}],"Version":"8.3","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Historical Number
1037350
Was this topic helpful?
Document Information
Modified date:
15 June 2018
UID
swg21347515