WP_ACTI_DATA Table var_value Column Size Increase for Identity Manager Tasks

Products

• CA Identity Manager
• CA Identity Suite

Issue/Introduction

Tasks within CA Identity Manager may fail when data inserts into the Workpoint WP_ACTI_DATA table exceed the default column width. This typically occurs in scenarios such as assigning a large number of activity administrators (e.g., ~300) to a workflow activity, which causes the SQL insert to fail and breaks the assignment process.

Environment

Identity Manager 14.x

Cause

The var_value column in the WP_ACTI_DATA table has a default size of 1024. When the activity data or number of administrators assigned to a task exceeds this character limit, a SQL exception occurs during the insert operation.

Resolution

Workpoint Support generally advises against making manual database schema changes. However, to meet specific client requirements for large datasets, an increase of the VALUE_VAR (mapped to var_value) size has been successfully tested.

1. Validate Data Size: Review logs to confirm the var_value data exceeds 1024 characters.
2. Schema Adjustment:
   • The column size for nVarchar VALUE_VAR can be increased up to 4000.
   • Do not exceed the 4000-character limit.
3. Maintenance: Note that you are responsible for maintaining this change, as upgrades, patches, or hotfixes may reset the column to its original value.