Data Protection - iConsole search fails with Oracle error ORA-04063.

Document ID : KB000006528
Last Modified Date : 14/02/2018
Show Technical Document Details
Issue:

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 .

Environment:
CA Data Protection (DataMinder)
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. 

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.