My Oracle Support Banner

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 JULY 13, 2023

Applies to:

Oracle Life Sciences 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

To view full details, sign in with your My Oracle Support account.

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

In this Document
Symptoms
Cause
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.