IBM Support

Error 'PLS-00201: identifier 'DBMS_LOCK' must be declared' when running USP_CHECKBATCHJOBSTATUS

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

Document Information

Modified date:
15 June 2018

UID

swg21347515