"ORA-00001: Unique Constraint Violated" Error while running the System Maintenance Task "Maintain Setup Data" in Data Management (Doc ID 2846641.1)

Last updated on JULY 31, 2023

Applies to:

Symptoms

Error while running the system maintenance task "Maintain Setup Data" in Data Management

Error from Process log
-------------------------
ERROR [AIF]: The script has failed to execute:
FATAL [AIF]: Error in Comm.executeJythonScript
Traceback (most recent call last):
  File "", line 580, in executeJythonScript
  File "/u01/test/PBCS_22.01.25/EPMSystem11R1/products/FinancialDataQuality/bin/system/MaintainSetupData.py", line 1097, in
  raise Exception(str(sys.exc_info()[1]).encode("utf-8"))
Exception: java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (LRAXTORWNRY.TPOVPARTITION_U2) violated


 DEBUG [AIF]:
  UPDATE AIF_PROCESS_DETAILS
  SET STATUS = 'FAILED'
  ,RECORDS_PROCESSED = CASE WHEN RECORDS_PROCESSED IS NULL THEN 0 ELSE RECORDS_PROCESSED END + NULL
  ,EXECUTION_END_TIME = CURRENT_TIMESTAMP
  ,LAST_UPDATED_BY = CASE WHEN ('' IS NULL) THEN LAST_UPDATED_BY ELSE '' END
  ,LAST_UPDATE_DATE = CURRENT_TIMESTAMP
  WHERE PROCESS_ID = 3768 AND ENTITY_TYPE = 'PROCESS_CUSTOM_SCRIPT' AND ENTITY_NAME = 'MaintainSetupData.py'
  
FATAL [AIF]: Error in CommProcess.executeCustomScript
Traceback (most recent call last):
  File "", line 190, in executeCustomScript
  File "", line 525, in executeCustomScript
  File "", line 580, in executeJythonScript
  File "/u01/test/PBCS_22.01.25/EPMSystem11R1/products/FinancialDataQuality/bin/system/MaintainSetupData.py", line 1097, in
  raise Exception(str(sys.exc_info()[1]).encode("utf-8"))
Exception: java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (LRAXTORWNRY.TPOVPARTITION_U2) violated


DEBUG [AIF]: The fdmAPI connection has been closed.
FATAL [AIF]: Error in COMM Execute Custom Script
INFO [AIF]: FDMEE Process End, Process ID: 3768

Changes

Diagnostics system has detected that the daily backup is not successfully completed on the environment.This is because you have some bad setup data in Data Management.

To resolve this issue, the user should run system maintenance task "Maintain Setup Data" in Data Management.

https://docs.oracle.com/en/cloud/saas/enterprise-performance-management-common/tsepm/8_troubleshoot_customer_alert.html

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.