CA Identity Governance 15.0-Importing data process from IM fails while merging the configuration

Products

• CA Identity Governance

Issue/Introduction

In Identity Governance, In a few instance while executing multiple imports,the process is failing while merging the configuration.

WARN  [com.ca.rcm.multiimport.services.ConfigurationManipulationServiceImpl] (Merge thread-24) Failed addOrUpdateResourcesToDatabase, trying addBatchResourcesToDatabase.
org.springframework.dao.CannotAcquireLockException: PreparedStatementCallback; SQL [update Resources set ResName1=?, ResName2=?, ResName3=? where ResourceID=? and DatabaseID=?]; Transaction (Process ID 54) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
 
ERROR [com.eurekify.businessflow.bb.multiimport.MergeAsAccounts] (Merge thread-24) Exception was thrown executing MergeAsAccounts building blockorg.springframework.dao.CannotAcquireLockException: PreparedStatementCallback; SQL [SELECT 1 AS Result FROM Resources WITH (UPDLOCK,PAGLOCK) WHERE DatabaseID = ? AND ResName1 = ? AND ResName2 = ? AND ResName3 = ? ]; An error occurred during the current command (Done status 0). Transaction (Process ID 54) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
 at deployment.eurekify.war//org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.doTranslate(SQLStateSQLExceptionTranslator.java:144)
 

Environment

IGA 15.0

Cause

In IGA 15.0, the Exception handling is changed compared to earlier version 14.5, the old spring framework handles Deadlock exceptions differently.

 At present, the 15.0 code is not able to retry the transaction is a deadlock exception.

Resolution

In the latest version, the retry logic is not working properly. So the Enigneering team resolved the issue and included in 15.0.1 Fixpack1 release. 

You can download it from the product document