Identity Governance import process generates the error "ORA-01401: inserted value too large for column"

Products

• CA Identity Suite
• CA Identity Governance

Issue/Introduction

While running an Identity Governance import process the import stuck and in the Identity Governance log file we can see the error:

 

INFO  [stdout] (taskExecutorServiceContainer-1) org.springframework.dao.DataIntegrityViolationException: PreparedStatementCallback; SQL [INSERT INTO ContextPropertiesDST (BusinessFlowId, ContextId, PropertyNameId, PropertyValue) VALUES (?, ?, ?, ?)]; ORA-01401: inserted value too large for column
INFO  [stdout] (taskExecutorServiceContainer-1) ; nested exception is java.sql.BatchUpdateException: ORA-01401: inserted value too large for column

Environment

Identity Governance 14.x

Cause

This is an Oracle limitation where the column has a limit of 2000 characters

Resolution

This is working as designed but it was generated a HotFix to change the value of what is being stored in the table.

 

Open a support case to ask the patch "HF_IG-14.5.1-20250425143139-DE627939_36081871_001.tgz.gpg"

After applying the patch follow the below steps to deploy the patch.

1. Download and apply the attached patch on 14.5.1 CHF1 in your vApp environment.
2. Login to Identity Governance and navigate to Home > Administration > Settings > Property Settings.
3. In the properties text box at the bottom type the value 'short.endpoint.template.field.names'  and click on Add new.
4. Set the property value to true and click on save.
5. Now go to the connector configuration page and make any change to the connector configuration such as adding or deleting and endpoint or changing the endpoint template attributes and click on save.
6. Now the import should run as the names are made short.

Please test on a lower environment before deploying the patch in production.