My Oracle Support Banner

"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 FEBRUARY 28, 2022

Applies to:

Oracle Planning and Budgeting Cloud Service - Version N/A and later
Oracle Financial Consolidation and Close Cloud Service - Version N/A and later
Oracle Enterprise Planning and Budgeting Cloud Service - Version N/A and later
Information in this document applies to any platform.

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

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
References


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