SQL Exception - WP_ACTI_DATA

Products

• CA Identity Manager

Issue/Introduction

We are seeing failed tasks due to SQL exception. WP_ACTI_DATA table has a column var_value. The size of this column is set to 1024 and the data we have is greater than the max value. 

Can we increase the size of the column var_value?

Resolution

Workpoint Support advises against making database schema changes.

But to suffice client requirements, we have successfully tested, without problems, an increase of nVarchar VALUE_VAR to 4000 (MAX) nVarchar MAX.

If needed, you may increase the size to no larger than 4000. You are responsible for maintaining that change should an upgrade, patch, or hotfix reset the original value.