My Oracle Support Banner

Errors Encountered During The Database Upgrade From Insight 5.1 To 6.0 (Doc ID 1352774.1)

Last updated on AUGUST 14, 2019

Applies to:

Oracle Argus Insight - Version 5.1 to 6.0 [Release 5.1 to 6.0]
Information in this document applies to any platform.

Symptoms


The following errors observed when upgrading Insight Database from 5.1 to 6.0:

1. Opening File E:\Program Files\Oracle\ArgusInsight\Database\Upgrades\51_TO_60\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


2. Opening File E:\Program Files\Oracle\ArgusInsight\Database\Upgrades\51_TO_60\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

3. Opening File E:\Program Files\Oracle\ArgusInsight\Database\Upgrades\51_TO_60\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


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