Character limit of Text Field

[Former Community Member]

Hi,

we are facing the below stall in our project. If we give more number of characters in a multi line text field, this stall happens. However it does not happen with every text field. Is there any character limit for the number of characters for text field?? or is it the problem related to ntext datatype in sql server?

A non-retryable Exception has occured: Operation failed. The index entry of length 1114 bytes for the index 'ix_76' exceeds the maximum length of 900 bytes.

StackTrace:

com.adobe.idp.taskmanager.dsc.client.task.TaskManagerRuntimeException: A non-retryable Exception has occured: Operation failed. The index entry of length 1114 bytes for the index 'ix_76' exceeds the maximum length of 900 bytes.

please help me if you have any idea regarding this issue.

[TundraSteve]

Have you limited the length of ix_76?

[jasotastic81]

There may be a character limit, but It's past 900, for sure. I just made a sample file in LCD-ES3, and I copy/pasted 2100 characters in a field. It kept all of them. Windows says that's 2,198 bytes (4,096 bytes on disk).

[CarlYoungPhx]

ix_76 is the index record pointing to the Instructions field in the yourdeployment.tb_task table in the LiveCycle database. A customer using LiveCycle Process Management (Workspace) had the identical issue. This field holds the data from the "Task Instructions" user action in Workspace. The LiveCycle database limits this field to 900 bytes. My customer was using a variable to populate Task Instructions that pulled data from a form. If the data was less than 900 characters the form would go through. If it was exceeded the process would stall. The resolution is to limit data to fewer than 900 characters.