Import stuck at "0% in progress" and "ORA-00001: unique constraint" in the eurekify.log

Products

• CA Identity Suite
• CA Identity Governance

Issue/Introduction

In the Identity Governance after starting an import against Identity Manager, the import stuck at 0%

 

In the eurekify.log file the following error 

14:23:37,269 WARN  [com.eurekify.businessflow.bb.flowcontrol.StartChildren] (taskExecutorServiceContainer-1) The Signal Counter already exists for flow: NAME_OF_THE_UNIVERSE

 It could happen when this BB is run twice due to failover retry org.springframework.dao.DuplicateKeyException: PreparedStatementCallback; SQL [INSERT INTO SignalCounters  (BusinessFlowId, SignalCounterId, TaskId, MaxCount, CurrentCount)  VALUES (?, ?, ?, ?, ?)]; ORA-00001: unique constraint (XXXX.PK_SIGNALCOUNTERS) violated

; nested exception is java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (XXXX.PK_SIGNALCOUNTERS) violated

Caused by: java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (XXXX.PK_SIGNALCOUNTERS) violated

Environment

Identity Governance 14.x

Cause

The problem was the property tms.workflow.url which was set with the Identity Governance hostname.

Resolution

Instead of set the tms.workflow.url to the Identity Governance hostname, change it to localhost

Additional Information

If this is not related to your issue, see also the KB article below

Workpoint adapter not responding