Oracle Error SQLException: ORA-12899 encountered when performing actions in Identity Manager

Products

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

Issue/Introduction

When trying to perform actions in Identity Manager, the following error occurs in the server log:

saveRuntimeStatusDetail: exception in saving the runtimestatusdetail: ORA-12899: value too large for column "[YOUR DB NAME]"."RUNTIMESTATUSDETAIL12"."DESCRIPTION" (actual: [OVER 2000], maximum: 2000) 

Exception while writing to the DB: java.sql.SQLException: ORA-12899: value too large for column "[YOUR DB NAME]"."RUNTIMESTATUSDETAIL12"."DESCRIPTION" (actual: [OVER 2000], maximum: 2000) 

Environment

Identity Manager 14.x

Cause

The "[YOUR DB NAME]"."RUNTIMESTATUSDETAIL12"."DESCRIPTION" field in the database is set as a nvarchar(2000) field which has a limit of 2000 characters. Sometimes, depending on your use cases the description field may need to exceed that number of characters. 

 

Resolution

The Description field can be safely increased to a max of nvarchar(4000) to accommodate environments with large descriptions. In addition to increasing the description field, the archive DB description field must also be increased otherwise errors will occur while attempting to archive data. The value that you choose for the description field must be the same for the archive description field. For example, if you increase the description to nvarchar(3000), then the archive description must also be nvarchar(3000). 

 

The full names of the fields are as follows: 

[YOUR DB NAME].runtimeStatusDetail12.Description 

[YOUR DB NAME].archive_runtimeStatusDetail12.Description 

 

To increase the size of these fields, you may need to engage your Database Administrator.