000035737 - RSA Identity Governance and Lifecycle - 702 Migration fails with ORA-01720: grant option does not exist for 'SYS.DUAL'

Document created by RSA Customer Support Employee on Dec 15, 2017
Version 1Show Document
  • View in full screen mode

Article Content

Article Number000035737
Applies ToRSA Product Set: RSA Identity Governance and Lifecycle
RSA Version/Condition: 7.0.2
 
IssueMigrating a database from a previous version to 7.0.2 fails with the following error in the migrate.log:
 

SQL/line#: /home/oracle/wildfly/domain/servers/server-one/tmp/vfs/temp/tempd214140fae9fc9c9/content-526bdb5a5591db16/contents/aveksa.war/WEB-INF/database/Views/v_av_db_timezone.sql(1):
Start time [Thu Nov 09 13:35:04 EST 2017]
CREATE OR REPLACE FORCE VIEW  V_AV_DB_TIMEZONE
AS
SELECT UTILITIES_PKG.GET_DBTIMEZONE_VALUE FROM DUAL
java.sql.SQLSyntaxErrorException: ORA-01720: grant option does not exist for 'SYS.DUAL'

 
CauseThe cause of this issue is not confirmed but looks to be an Oracle bug. See the following Oracle note for more information:
Post Upgrade To 11.2.0.4, "create or replace view" execution fails with "ORA-01720: Grant Option Does Not Exist" (Doc ID 1628033.1)
ResolutionDrop and recreate the view and restart the migration.
1. As 'avuser' run this SQL:
 

drop view v_av_db_timezone;
  CREATE OR REPLACE FORCE EDITIONABLE VIEW "AVUSER"."V_AV_DB_TIMEZONE" ("GET_DBTIMEZONE_VALUE") AS
  SELECT UTILITIES_PKG.GET_DBTIMEZONE_VALUE FROM DUAL;

2. Enter the migration password in the Initialization Status screen to restart the migration.

Attachments

    Outcomes