Errors Encountered During The Upgrade From 5.0 To 5.1 (Insight) (Doc ID 1352779.1)

Last updated on AUGUST 26, 2011

Applies to:

Oracle Argus Insight - Version: 5.0 to 5.1 - Release: 5.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

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