Join the #BuildWithBuildAgent Challenge! Get recognized, earn exclusive swag, and inspire the ServiceNow Community with what you can build using Build Agent.  Join the Challenge.

Error while increasing Max Length

puneetgoels1
Tera Guru

I have a custom field in incident table which was initially created to 50 characters but we have a new requirement to change its length to 4000. When I am trying to do that I am getting the below error 

Syntax Error or Access Rule Violation detected by database (BLOB/TEXT column 'a_str_16' used in key specification without a key length)

 

however I have an import set table to incident with same field, when I am trying to update length there, It gets updated without any fuss. Not sure Why?

5 REPLIES 5

Doesn't work