Errors Encountered During The Upgrade From 5.0 To 5.1 (Insight)
(Doc ID 1352779.1)
Last updated on JULY 13, 2023
Applies to:
Oracle Life Sciences Argus Insight - Version 5.0.0 to 5.1 [Release 5.0.0 to 5.1]Information in this document applies to any platform.
Symptoms
The following errors observed when upgrading Insight database from 5.0 to 5.1:1. Opening File C:\Program Files\Relsys\ArgusInsight\Database\Upgrades\5_TO_51\SQL\ai_mart{pkg_based_grant}.sql File Open
GRANT SELECT ON APR_MART.V_RPT_CASE_CLOB to APR_MART;
SQL execution error, ORA-01749: you may not GRANT/REVOKE privileges to/from yourself
2. Opening File C:\Program Files\Relsys\ArgusInsight\Database\Upgrades\5_TO_51\SQL\ai_mart{grant}.sql
GRANT SELECT ON APR_MART.RPT_CASE to APR_MART;
SQL execution error, ORA-01749: you may not GRANT/REVOKE privileges to/from yourself
3. Opening File C:\Program Files\Relsys\ArgusInsight\Database\Upgrades\5_TO_51\SQL\ai_mart_read_only{views}.sql
CREATE OR REPLACE VIEW APR_MART.v_rpt_case_clob AS SELECT * FROM APR_MART.v_rpt_case_clob;
SQL execution error, ORA-01731: circular view definition encountered
4. Opening File C:\Program Files\Relsys\ArgusInsight\Database\Upgrades\5_TO_51\SQL\ai_mart_read_only{synonym}.sql
CREATE OR REPLACE SYNONYM APR_MART.rpt_case FOR APR_MART.v_rpt_case_clob;
SQL execution error, ORA-00955: name is already used by an existing object
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 |