Issues to execute ETL

book

Article ID: 132101

calendar_today

Updated On:

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 

ORA-06512: at "REPORT_DB.I2_SP_DW2", line 12 

20:22:56,307 INFO [com.eurekify.businessflow.bb.i2.etl.RunEtlPhase] (taskExecutorServiceContainer-6) Starting SHADOW phase of ETL etl.rcm.flatRoleRole... 

20:22:58,977 INFO [com.eurekify.businessflow.bb.i2.etl.RunEtlPhase] (taskExecutorServiceContainer-6) Finished SHADOW phase of ETL etl.rcm.flatRoleRole(rcm_flatRoleRoleShadowDelta) took 2.648 sec 

20:23:05,670 WARN [com.eurekify.dal.businessflow.BusinessFlowDalImpl] (taskExecutorServiceContainer-1) The context is not archived as contextId = null; BBExecutionContext{jobId=6476:WPDS, activityId=94205:WPDS, Status=OPEN, properties=[universe:XXXXXXXX, className:com.eurekify.businessflow.bb.flowcontrol.CheckChildTasksWithResult, resultToCheck:result.etl.failed]} 

20:23:06,781 INFO [com.eurekify.businessflow.bb.i2.etl.RunDW2] (taskExecutorServiceContainer-4) Start DW2 for client id 920 ... 

20:30:02,666 INFO [com.ca.sec.ig.scheduler.OverdueTaskExpiryJob] (QuartzScheduler_Worker-4) Checking for expired tasks 

20:30:03,021 INFO [com.ca.sec.ig.scheduler.OverdueTaskExpiryJob] (QuartzScheduler_Worker-4) Finished checking for expired tasks @ 0:00:00.353 

20:41:38,882 INFO [stdout] (pool-7-thread-1) 2019-04-23 20:41:38,882 [pool-7-thread-1] INFO com.workpoint.server.ServerProperties - ServerProperties.setProperty() invoked for property= calculated.db.offset.millis, value=-905764 

20:45:02,675 INFO [com.ca.sec.ig.scheduler.OverdueTaskExpiryJob] (QuartzScheduler_Worker-4) Checking for expired tasks 

20:45:03,034 INFO [com.ca.sec.ig.scheduler.OverdueTaskExpiryJob] (QuartzScheduler_Worker-4) Finished checking for expired tasks @ 0:00:00.358 

20:56:56,826 ERROR [com.eurekify.businessflow.bb.i2.etl.RunDW2] (taskExecutorServiceContainer-4) Error running DW2 for client xxxx: com.eurekify.i2.core.etl.process.step.exception.EtlProcessStepExecutionException: Failed to execute DW2 operation: 

at com.eurekify.i2.etl.rcm_12_5.step.DW2Executer.execute(DW2Executer.java:42) [classes:] 

at com.eurekify.businessflow.bb.i2.etl.RunDW2$1.criticalSection(RunDW2.java:36) [classes:] 

at com.eurekify.lock.LockDecorator.<init>(LockDecorator.java:35) [classes:] 

at com.eurekify.lock.LockDW2Decorator.<init>(LockDW2Decorator.java:16) [classes:] 

at com.eurekify.businessflow.bb.i2.etl.RunDW2$1.<init>(RunDW2.java:25) [classes:] 

at com.eurekify.businessflow.bb.i2.etl.RunDW2.executeAndFinish(RunDW2.java:25) [classes:] 

at com.eurekify.businessflow.bb.i2.etl.AbstractEtlBuildingBlock.executeAndFinish(AbstractEtlBuildingBlock.java:22) [classes:] 

at com.eurekify.businessflow.bb.AutoResultBuildingBlock.execute(AutoResultBuildingBlock.java:15) [classes:] 

at com.eurekify.businessflow.bb.BuildingBlock.run(BuildingBlock.java:78) [eurekify-api-14.1.0-SNAPSHOT.jar:] 

at com.eurekify.services.BuildingBlockServiceImpl.execute(BuildingBlockServiceImpl.java:128) [classes:] 

at com.eurekify.tms.services.TaskExecutorServiceImpl.executeBuildingBlock(TaskExecutorServiceImpl.java:71) [classes:] 

at com.eurekify.tms.services.TaskExecutorServiceDefaultDecider.executeBuildingBlock(TaskExecutorServiceDefaultDecider.java:59) [classes:] 

at com.eurekify.tms.services.TaskExecutorServiceDefaultDecider.execute(TaskExecutorServiceDefaultDecider.java:40) [classes:] 

at sun.reflect.GeneratedMethodAccessor378.invoke(Unknown Source) [:1.8.0_71] 

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) [rt.jar:1.8.0_71] 

Caused by: com.eurekify.i2.core.etl.process.exception.EtlProcessException: Error during process of the I2_SP_DW2 stored procedure 

at com.eurekify.i2.core.etl.process.step.DW12Impl.DW2Execute(DW12Impl.java:75) [classes:] 

at com.eurekify.i2.etl.rcm_12_5.step.DW2Executer.execute(DW2Executer.java:37) [classes:] 

... 28 more 

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 

ORA-06512: at "REPORT_DB.I2_SP_DW2", line 12 

ORA-06512: at line 1 

at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:439) 

at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:395) 

at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:802)

Cause

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

Environment

Identity Governance 14.0

Resolution

Increasing the undo tablespace will resolve the issue.