Issues to execute ETL
Article ID: 132101
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)
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)
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.
Feedback
Yes
No
Powered by
