3 Replies Latest reply: Nov 5, 2014 11:21 AM by CarlYoungPhx

Character limit of Text Field

sudha shankar Nov 8, 2013 2:12 AM

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.

1. Re: Character limit of Text Field

TundraSteve Nov 8, 2013 4:55 AM (in response to sudha shankar)

Have you limited the length of ix_76?
Like Show 0 Likes (0)

Actions
2. Re: Character limit of Text Field

jasotastic81 Nov 8, 2013 3:04 PM (in response to sudha shankar)

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).
Like Show 0 Likes (0)

Actions
3. Re: Character limit of Text Field

CarlYoungPhx Nov 5, 2014 11:21 AM (in response to sudha shankar)

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.
Like Show 0 Likes (0)

Actions

Go to original post

Legend

Correct Answers - 10 points