Issues to execute ETL

Products

• CA Identity Manager
• CA Identity Governance
• CA Identity Portal

Issue/Introduction

Running ETL results with an error:
Caused by: java.sql.SQLException: ORA-20001: ERROR WHILE EXECUTING THE I2_SP_DW2 STORED PROCEDURE -20001 -ERROR- ORA-20001: ERROR WHILE EXECUTING THE I2_SP_CREATEDWCONSTRAINTS STORED PROCEDURE -2437 -ERROR- ORA-02437: cannot validate (REPORT_DB.XPKI2_PENTITY_PENTITY_REL) - primary key violated 

Environment

Identity Governance 

Cause

The issue is due to lack of space in the undo tablespace.
 

Resolution

Increasing the undo tablespace will resolve the issue.