iConsole search fails with Oracle error ORA-04063.
Article ID: 6528
Updated On:
Products
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 .
Environment
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.
Feedback
