Byte Error Message while creating a Change Request

[JS_10513698]

I am trying to create a Change Request.

When I reach the character limit with more than one paragraph on Description, Comments, Proposed Solutions and Status attribute fields, I see the bytes error message.

The number of bytes in this attribute value can be no more than 4000. The number of bytes currently entered is 4014.

Does anyone know how to resolve this problem? does it have to do anything with OOTB file? are there any articles on PTC support which I can refer to?

[avillanueva]

You've blown out the table column size in the database. This is a hard limit on text fields. One of your text fields has a novel in it. Try to shorten it or attach a document with the text you want in it.  

[JS_10513698]

is there a way not to see this error and it just gives only the character limit error? because normal user can not understand this error message.

[avillanueva]

Here are some articles:

https://www.ptc.com/en/support/article/CS324817?source=search

https://www.ptc.com/en/support/article/cs360416?source=ArticleViewerRelated

If you are looking to suppress the message, possible with extensive customization but I do not recommend. Easier to train users to write less in text fields and if they get too big, put it in a file attachment.

[d_graham]

@JS_10513698 If it stated:

The number of characters in this attribute value can be no more than 4000. The number of characters currently entered is 4014.

Could they understand that?

Also, it's not difficult to change the size limit for table columns in the database, but I wouldn't do that unless there's an overwhelming need for more characters.

But if you change Description from plain text to formatted text the data will be stored in a different column as a BLOB and you will no longer have the 4000 character limit.  That's probably the easiest solution.

BTW, PTC themselves increase expression robot character limit from the original 2000 to 4000. Times do change.

[SWeiler_9940261]

Probably not related, but have you seen this?
https://www.ptc.com/en/support/article/CS384293