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

Document ID : KB000047610
Last Modified Date : 14/02/2018
Show Technical Document Details

Issue:

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:

This error can occur in environments using a Microsoft or Oracle SQL database for Task Persistence. 

 

Cause: 

The "[YOUR DB NAME]"."RUNTIMESTATUSDETAIL12"."DESCRIPTION" field in the database is set as an 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 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.