EGRC 8.6.4.5000: New Install Failed with "ORA-00942: Table or View Does not Exist: DataMigrationManager:1015 Exception Occurred while Executing Stored Procedure"

(Doc ID 1567110.1)

Last updated on AUGUST 02, 2017

Applies to:

Oracle Transaction Controls Governor - Version 8.6.4 to 8.6.4 [Release 8]
Oracle Application Access Controls Governor - Version 8.6.4 to 8.6.4 [Release 8]
Information in this document applies to any platform.

Symptoms

On : In Application Access Controls Governor (AACG)GRC 8.6.4.5259 version:

AACG is used to report segregation of duties(SOD) in the business applications. When attempting to do a new install of the GRC product, the application initialization is failing. The application database upgrade is failing with the errors below:

ERROR
-----------------------
grc.log

 

2013-06-07 06:51:05,200 DEBUG [Thread-33] DataMigrationManager:1009 Executing stored procedure: grc_update_who_columns_8645
2013-06-07 06:51:05,299 ERROR [Thread-33] DataMigrationManager:1015 Exception occured while executing stored procedure grc_update_who_columns_8645
java.sql.SQLSyntaxErrorException: ORA-01031: insufficient privileges
ORA-06512: at "XXGRC.GRC_UPDATE_WHO_COLUMNS_8645", line 48
ORA-06512: at line 1

    at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:462)
    at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:405)
    at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:931)
    at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:481)
    at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:205)
    at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:548)
    at oracle.jdbc.driver.T4CCallableStatement.doOall8(T4CCallableStatement.java:213)
    at oracle.jdbc.driver.T4CCallableStatement.executeForRows(T4CCallableStatement.java:1111)

2013-06-06 07:07:17,968 INFO  [Thread-33] DBConfigUtil:257 <== End  of the createObjects
2013-06-06 07:07:18,151 WARN  [Thread-33] DBConfigManager:1552 Database is not initialized yet.
2013-06-06 07:07:18,160 DEBUG [Thread-33] DataMigrationManager:172 Driver oracle.jdbc.driver.OracleDriver loaded.
2013-06-06 07:07:18,266 ERROR [Thread-33] DataMigrationManager:893 Exception occured while updating failed_patch_id for patch data migration.
java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist

at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:462)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:405)
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:931)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:481)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:205)
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:548)
at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:202)
at oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:1110)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1488)
at oracle.jdbc.driver.OracleStatement.executeUpdateInternal(OracleStatement.java:2147)
at oracle.jdbc.driver.OracleStatement.executeUpdate(OracleStatement.java:2091)
at oracle.jdbc.driver.OracleStatementWrapper.executeUpdate(OracleStatementWrapper.java:320)
at oracle.apps.grc.dataservices.dbconfig.DataMigrationManager.updateFailedDataMigrationPatchId(DataMigrationManager.java:891)
at oracle.apps.grc.dataservices.dbconfig.DataMigrationManager.executeDataMigration(DataMigrationManager.java:422)
at oracle.apps.grc.dataservices.dbconfig.DataMigrationManager.executeDataMigration(DataMigrationManager.java:212)
at oracle.apps.grc.dataservices.dbconfig.DBConfigManager.executeSchemaScripts(DBConfigManager.java:826)
at oracle.apps.grc.dataservices.dbconfig.DBConfigManager.initializeSchema(DBConfigManager.java:339)
at oracle.apps.grc.dataservices.dbconfig.DBConfigManager.initializeSchema(DBConfigManager.java:135)
at oracle.apps.grc.dataaccessfacade.impl.DBConfigService.upgrade(DBConfigService.java:353)
at oracle.apps.grc.dataaccessfacade.impl.DBConfigService.upgrade(DBConfigService.java:291)
at oracle.apps.grc.dataaccessfacade.impl.DBConfigService.upgrade(DBConfigService.java:276)
at oracle.apps.grc.appservices.initialization.GrcUpgradeService.upgrade(SourceFile:139)
at oracle.apps.grc.appservices.initialization.GrcInitializationService$a.run(SourceFile:174)
at java.lang.Thread.run(Thread.java:722)
2013-06-06 07:07:18,440 INFO  [Thread-33] DBConfigManager:2385 *************************************
2013-06-06 07:07:18,440 INFO  [Thread-33] DBConfigManager:2386 Overall summary of schema updates:
2013-06-06 07:07:18,441 INFO  [Thread-33] DBConfigManager:2387 *************************************
2013-06-06 07:07:18,441 INFO  [Thread-33] DBConfigManager:2392 Status of Schema Creation: Failed
2013-06-06 07:07:18,441 INFO  [Thread-33] DBConfigManager:2404 Status of Data Migration Updates: Success
2013-06-06 07:07:18,441 INFO  [Thread-33] DBConfigManager:2425 *************************************
2013-06-06 07:07:18,441 INFO  [Thread-33] DBConfigManager:2431 Overall Status of updates: FAILED
2013-06-06 07:07:18,442 INFO  [Thread-33] DBConfigManager:2432 *************************************

 


Application:
The grc upgrade has failed


-- Steps To Reproduce:
The issue can be reproduced at will with the following steps:
1. Create new Schema
2. Deploy the 864_5000 GRC
3. go to http://host:port/grc and access the application configuration page
4. Enter all the required information save
5. Restart the application, the upgrade fails within minutes at each of the reinstall attempts

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, the instance is inaccessible to users.

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