What' does this error mean? (Length change not allowed ~)

[Yuya Hayase]

hi experts!!

I am trying to shorten the max length via update set.

Howevver, this error messsage appered.

"Length change not allowed. The field 'Culum Name' on table 'Table Nmae' contains existing data records (163) that exceed the new length of 30."

Actually, I've shortened the max length from 60 to 30.
I've checked data before updata-set migration, but no data is longer than 30 length(These data type is string).

Furthermore, what is  (163) ?

So I don't know what should I do.

[Mahendra RC]

Hello @Yuya Hayase 

So that mean that 163 records have value whose length is greater than 30 in the column or field for which your are reducing the max length from 60 to 30.

Please check the Child table table or the Parent actual table where you are updating this field. Suppose you updating the max length of the field that exist on task table. so in that case you may need to check in task table and not on incident table.

[Yuya Hayase]

Thank you @Mahendra RC 

I've checked the table again, but I couldn't find longer data.

Do you know how can I find the data (via error messagge)?

[Mahendra RC · Accepted solution]

Hello @Yuya Hayase 

If that is the case please once check the below KB article published by ServiceNow for the possible Root cause for this issue.

Can't decrease length of a field, even though there isn't any data exceeding new max length

[Yuya Hayase]

Thank you!!!