RSA Identity Governance and Lifecycle - 702 Migration fails with ORA-01720: grant option does not exist for 'SYS.DUAL'
3 years ago
Originally Published: 2017-11-14
Article Number
000041583
Applies To
RSA Product Set: RSA Identity Governance and Lifecycle
RSA Version/Condition: 7.0.2
 
Issue
Migrating 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'


 
Cause
The 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)
Resolution
Drop 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.

Related Articles

Trending Articles

Don't see what you're looking for?