Initial ETL is Failing With The Error 'ORA-06512: at ""APR_MART.PKG_COMPILE"", line 171' After 7.0.2 Upgrade (Doc ID 1538069.1)

Last updated on MARCH 18, 2013

Applies to:

Oracle Argus Insight - Version 7.0.1 and later
Information in this document applies to any platform.

Symptoms

Initial ETL is failing with the following error after upgrading from 7.0.1 to 7.0.2:

Checked the staging_data_insert_log file and observed the following errors:

2189961 p_compile_objects_and_log Error occured during compilation of invalid objects for schema - APR_MART "ORA-24344: success with compilation error
ORA-06512: at ""APR_MART.PKG_COMPILE"", line 171
ORA-24344: success with compilation error"

2189962 p_compile_objects_with_log Error while executing initial etl procedure - p_compile_objects_with_log "ORA-20010: ORA-24344: success with compilation error
ORA-06512: at ""APR_MART.PKG_COMPILE"", line 171
ORA-24344: success with compilation error
-- ERROR while compiling PROCEDURE - display_clob
At 11-MAR-13"

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms