Process fails in the node "Write To data store entity".

abishekk over 7 years ago

When entering exactly 255 characters for a field which has been configured in the sql server too as 255 characters the smart service "Write to data store entity" fails giving the error in log as :

Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Operation failed. The index entry of length 1044 bytes for the index 'UC_Data' exceeds the maximum length of 900 bytes.

Any help on this would be of great help.

Thanks in advance.

Discussion posts and replies are publicly visible

0 Navajith K over 7 years ago

Hi Abishek, I believe you will have to increase the field size in DB or you should restrict the user from entering morethan 255 characters in the field.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 abishekk over 7 years ago

the validation is there for 255 characters. It works fine for 254 characters. I guess its because of the (0,255) definition which gives 254 characters . Still not yet confirmed. But there is a validation for 255 characters
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 narasimhaadityac
A Score Level 2
over 7 years ago

Hi Abhishek, did you type in the field are copied from an external source and pasted in the field?
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 abishekk over 7 years ago

I copied from notepad
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 narasimhaadityac
A Score Level 2
over 7 years ago

We have seen similar issue when the information is copied as there are some special characters. When looking at the Appian side the length is coming different and when copy same content and copy to SQL editor the length is shown differently.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 abishekk over 7 years ago

S but this case is different I guess. Does any one know how much is the size limitation for data to be written to a data store ?
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 PhilB
Certified Lead Developer
over 7 years ago

You might want to refer to the link below; what you're seeing isn't a problem with appian, but with an index on one of the table's fields.

stackoverflow.com/.../900-byte-index-size-limit-in-character-length
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 abishekk over 7 years ago

got it philb thanks :)
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 PhilB
Certified Lead Developer
over 7 years ago

No worries! :)
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel