EGRC New Installation DA Synchronizing Job Fails

(Doc ID 1508263.1)

Last updated on JANUARY 22, 2016

Applies to:

Oracle Enterprise Governance, Risk, and Compliance Manager - Version 8.6.4 to 8.6.4 [Release 8]
Information in this document applies to any platform.


DA Sync Fails while running the Synchronizing Job.

The grc.log file (Middleware)/grc864/grc/log/grc.log shows this error:

ODI-1226: Step GRI_RUN_INTR_HIST_PROC_STAGE fails after 1 attempt(s).
Caused by: ODI-1232: Procedure GRI_RUN_INTR_HIST_PROC_STAGE execution fails.
Caused by: ODI-1228: Task GRI_RUN_INTR_HIST_PROC_STAGE (Procedure) fails on the target ORACLE connection physical_schema_tgt.
Caused by: java.sql.SQLException: ORA-06550: line 1, column 303:
PL/SQL: ORA-00942: table or view does not exist
ORA-06550: line 1, column 36:
PL/SQL: SQL Statement ignored
ORA-06550: line 1, column 814:
PL/SQL: ORA-00942: table or view does not exist
ORA-06550: line 1, column 648:
PL/SQL: SQL Statement ignored

  at com.sunopsis.dwg.dbobj.SnpSessStep.treatStepTaskError(
  at com.sunopsis.dwg.dbobj.SnpSessStep.treatAttachedTasks(
  at com.sunopsis.dwg.dbobj.SnpSessStep.treatSessStep(
  at com.sunopsis.dwg.dbobj.SnpSession.treatSession(
  at com.sunopsis.dwg.dbobj.SnpSession.treatSession(



 New installation.


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