Why do I get MSSQL deadlocks when importing into Identity Governance Portal?

Products

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

Issue/Introduction

Why are there MS-SQL database deadlocks when running import in the Identity Governance portal?

 

Resolution

When using CA Identity Governance with Microsoft SQL, and making many updates at once, deadlock exceptions may be generated. To improve performance while making many updates, run the following query on the SQL database while the CA RCM server is down:

       ALTER DATABASE eurekify_sdb
        SET READ_COMMITTED_SNAPSHOT ON;
        GO
        ALTER DATABASE eurekify_sdb
        SET ALLOW_SNAPSHOT_ISOLATION ON;
        GO