Veridata 12C Repair Fails With ORA-00001: Unique Constraint (DEV_VERIDATA.PK_REPAIR_JOBS) Violated

(Doc ID 2059351.1)

Last updated on JULY 24, 2017

Applies to:

Oracle GoldenGate Veridata - Version 12.1.3.0.1 and later
Information in this document applies to any platform.

Goal

Why Veridata 12c repair job fails with
----------------
Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.5.2.v20140319-9ad6abd): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (DEV_VERIDATA.PK_REPAIR_JOBS) violated

Error Code: 1
Call: INSERT INTO REPAIR_JOBS (RUN_ID, BASE_RUN_ID, MODIFY_DATE, NUM_COMPARE_PAIRS_CANCELLED, NUM_COMPARE_PAIRS, NUM_COMPARE_PAIRS_FAILED, NUM_COMPARE_PAIRS_SUCCESSFUL, NUM_COMPARE_PAIRS_WARNING, REPAIR_STATE, STATUS, RPT_FILE_NAME, START_DATE, STOP_DATE, JOB_ID) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
  bind => [14 parameters bound]
Query: InsertObjectQuery(GG(1013,0,0))
  at org.eclipse.persistence.exceptions.DatabaseException.sqlException(DatabaseException.java:331)
--------------
errors?

VERIDATA_server1-diagnostic.log shows:
--------------------------------------------------
[2015-09-09T11:35:00.752+02:00] [VERIDATA_server1] [ERROR] [OGGV-00184] [oracle.veridata.ui] [tid: [ACTIVE].ExecuteThread: '1' for queue: 'weblogic.kernel.Default (self-tuning)'] [userId: admin] [ecid: 7e4588a0-a83f-4da4-bf8f-cdb06b73c95e-0004eee8,0] [APP: veridata#12.1.3.0.0] [DSID: 0000KylQlP8Fw0YFLrmJOA1Lvkkj000006] Error message: OGGV-00095: Profile 'default$' does not exist.
 

Solution

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