iConsole search fails with Oracle error ORA-04063.

book

Article ID: 6528

calendar_today

Updated On:

Products

CA Data Protection (DataMinder)

Issue/Introduction

When running the out of the box standard search (i.e. the unmodified Standard Search that ships with CA Data Protection iConsole as default) an error similar to the following example is returned.

Message: The query with ID=b3pqrrrdgybziv45pkqhr555:Results:00000003 failed to run successfully:

Database Error: Exception calling stored procedure : java.sql.SQLException: [CA DataMinder][Oracle JDBC Driver][Oracle]ORA-04063: package body "WGNUSER.WGNWC_STDSEARCH2" has errors ORA-06508: PL/SQL: could not find program unit being called: "WGNUSER.WGNWC_STDSEARCH2" ORA-06512: at "WGNUSER.WGN_ICONSOLE", line 1435 ORA-06512: at line 1 : [CA DataMinder][Oracle JDBC Driver][Oracle]ORA-04063: package body "WGNUSER.WGNWC_STDSEARCH2" has errors ORA-06508: PL/SQL: could not find program unit being called: "WGNUSER.WGNWC_STDSEARCH2" ORA-06512: at "WGNUSER.WGN_ICONSOLE", line 1435 ORA-06512: at line 1 .

Cause

This issue is caused by a missing Oracle privilege. DBMS_RANDOM is an Oracle supplied package which should have public synonym with execute privileges. 

Environment

CA Data Protection (DataMinder)

Resolution

Granting Execute rights to DBMS_RANDOM for the primary data protection user allows the reports execute correctly.  For example;

Grant execute on DBMS_RANDOM to WGNUSER; 

Additional Information

Orchestria, CA DLP and DataMinder are previous brand names for the product now known as CA Data Protection.