Error when trying to perform Identity Manager tasks "value too large for column" ORA-12899

book

Article ID: 6028

calendar_today

Updated On:

Products

CA Identity Manager CA Identity Governance CA Identity Portal CA Risk Analytics CA Secure Cloud SaaS - Arcot A-OK (WebFort) CLOUDMINDER ADVANCED AUTHENTICATION CA Secure Cloud SaaS - Advanced Authentication CA Secure Cloud SaaS - Identity Management CA Secure Cloud SaaS - Single Sign On

Issue/Introduction

When actions are performed in Identity Manager, data relating to these actions is stored in your Task Persistence Database. This database has default column sizes for all string characters, but sometimes the strings generated by Identity Manager are too large to fit in the default columns. When this happens you'll see an error such as this:

[YOUR TASK NAME]: ORA-12899: value too large for column "[DB NAME]"."[TABLE NAME]"."[COLUMN NAME]" (actual: 247, maximum: 240) 

 

Cause

This is caused by the value being too large to fit in the database column. 

Environment

The above error message, ORA-12899 is specific to Oracle DBs however this problem may occur in other database types with different messages.

Resolution

Increasing the size of a database column is supported for the Task Persistence Database. Your database administrator can increase the size of your field using either a script or a database table editor. 

For example: 

varchar(50) can be increased to varchar(200) and your database will remain supported.