Identity Governance - import from IM fails wth SQL error: String or binary data would be truncated.

Products

• CA Identity Suite

Issue/Introduction

Identity Governance import from Identity Manager fails.

The errors in eurekify.log:

16:49:23,441 WARN  [com.ca.rcm.services.trace.TraceMessage] (import-connector thread-1) TraceMessage param1 value is too long: 325 it will be truncated to 256 characters; value: org.springframework.dao.DataIntegrityViolationException: PreparedStatementCallback; SQL [ INSERT INTO ResourceFields (DatabaseID, ResourceID, FieldNumber, FieldValue) VALUES (?, ?, ?, ?) ]; String or binary data would be truncated.; nested exception is ...
16:49:23,450 ERROR [stderr] (import-connector thread-1) com.eurekify.command.CommandExecutionException: org.springframework.dao.DataIntegrityViolationException: PreparedStatementCallback; SQL [ INSERT INTO ResourceFields (DatabaseID, ResourceID, FieldNumber, FieldValue) VALUES (?, ?, ?, ?) ]; String or binary data would be truncated.; nested exception is java.sql.BatchUpdateException: String or binary data would be truncated.

Environment

Release : 14.3 CP2

Component : CA IDENTITY SUITE (VIRTUAL APPLIANCE)

Cause

Identity Governance database schema was not upgraded during the product upgrade.

Resolution

Please see the following document:

https://techdocs.broadcom.com/us/en/symantec-security-software/identity-security/identity-governance/14-3/release-notes/Cumulative-Patches/Previous-Cumulative-Patches.html

Under deployment instructions, the third point specified as the following. This was missed in customer env.

Identity Governance 14.3 CP2 has DATABASE SCHEMA changes. After deploying the patch, update the database schema by following the instructions provided in the  CP-IG-140300-0002_Instructions_On_How_To_Deploy  file of the extracted folder.