Error ARJUNA016053: Could not commit transaction while requesting access to group in Identity Portal

Products

• CA Identity Suite

Issue/Introduction

We got the below error while submitting the task in portal in IAM we can see the request in placed all IAM admin tasks triggered but no request id was generated in Identity Portal also not able to see the request in Identity Portal.

"JTA transaction unexpectedly rolled back (maybe due to a timeout); nested exception is javax.transaciton.RollbackException: ARJUNA016053: Could not commit transaction"

"Error ARJUNA016053: Could not commit transaction"

Environment

Release : 14.3, 14.4, 14.5

Cause

The customer experienced an issue with the error "ARJUNA016053 - could not commit transaction (...) String or binary data would be truncated" when requesting groups from Identity Portal.

The main issue is in the string with the full group name. It is too long for the available column in the database: Table: request_account, columns: entitlement_name or entitlement_id.

The limit for these columns in 14.3 version of IP is 255 characters.

The preferred solution is to upgrade to 14.4 version where the same limit is set to 2048 characters.

You may still experience this issue if the full group name is longer than 2048 characters.

Resolution

Upgrade to the latest version if Identity Manager

For 14.4 systems if the group name is longer than 2048 characters please contact Broadcom support.