ORA-12899 "Value Too Large for Column" Error in Task Persistence Database - Identity Manager

Products

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

Issue/Introduction

When performing tasks in Identity Manager, you may encounter an ORA-12899 error indicating that a value is too large for a database column. This occurs when the data being stored in the Task Persistence Database exceeds the character limits defined in the schema for a specific column.

Environment

Identity Manager 14.5

Cause

This error is triggered when the length of the string generated by an Identity Manager task (such as a custom attribute or task name) exceeds the maximum length configured for the corresponding column in the Task Persistence Database. While this error is specific to Oracle databases, similar overflow errors may occur in other database types.

Resolution

To resolve this issue, increase the storage capacity of the affected database column. Coordinate with your Database Administrator (DBA) to perform the following steps:

1. Examine the error message in the application logs to identify the exact Table Name and Column Name that triggered the error (e.g., ORA-12899: value too large for column "[TABLE NAME]"."[COLUMN NAME]").
2. Verify that the current data being submitted is expected behavior and not a result of invalid input.
3. Use a database table editor or an ALTER TABLE SQL script to increase the maximum size of the identified column (e.g., increasing varchar(50) to varchar(200)).
4. Confirm that the application server services have access to the modified database schema.
5. Restart the Identity Manager services to ensure all changes take effect.

Additional Information

To speak with a customer representative or a Support Engineer see Contact Support. Scroll to the bottom of the page and click on your respective region.