My Oracle Support Banner

Initial ETL is failing with an error after upgrading to Insight 7.0.5 (Doc ID 1995250.1)

Last updated on JULY 13, 2023

Applies to:

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

Symptoms

Initial ETL is failing with an error after upgrading to Insight 7.0.5

Steps to Repeat:
1. Upgrade Argus Safety and Insight from 7.0.3 to 7.0.5
2. Run Initial ETL
3. Initial ETL is failing with an error when it is populating the data into staging schema

errors in staging_data_insert_log:
1558855 f_check_primary_event Error in f_check_primary_event "ORA-00942: table or view does not exist
ORA-02063: preceding line from DB_LINK_ARGUS
ORA-06512: at ""APR_STAGE.PKG_PWR_STAGE_UTIL"", line 787
ORA-06512: at ""APR_STAGE.PKG_PWR_STAGE_UTIL"", line 1033" 20-MAR-15

1558856 f_incr_prereq_check Error in f_incr_prereq_check "ORA-20009: ORA-00942: table or view does not exist
ORA-02063: preceding line from DB_LINK_ARGUS
ORA-06512: at ""APR_STAGE.PKG_PWR_STAGE_UTIL"", line 787
ORA-06512: at ""APR_STAGE.PKG_PWR_STAGE_UTIL"", line 1033

-- ERROR while processing f_check_primary_event at 20-mar-2015 09:52:44
ORA-06512: at ""APR_STAGE.PKG_AIR_ATOS"", line 51
ORA-06512: at ""APR_STAGE.PKG_PWR_STAGE_UTIL"", line 1059
ORA-06512: at ""APR_STAGE.PKG_PWR_STAGE_UTIL"", line 1204" 20-MAR-15

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.