Is there a way to avoid the max length check for the table?

[Yuki21]

Hello.
An error occurs when changing the maximum length of the table from 1000 to 160.
Is there a way to temporarily disable the check?

Which one should I deactivate?
UI action? business rules?
data policy?

[newhand]

@Yuki21 

It seems that "bytes count" is be checked ，not "Character count". 

Refer : https://support.servicenow.com/kb?id=kb_article_view&sysparm_article=KB0726986 

So try this.

var gr = new GlideRecord("incident")
gr.query()
while(gr.next()){
  if(gr.getValue("description") && encodeURIComponent(gr.getValue("description")).replace(/%../g,"x").length > 160 ){
    gs.info(gr.getValue("number"))
   
   }

}

[Yuki21]

Thank you.
I'll give it a try.

[Tony Chatfield1]

I am not sure if it is possible to bypass ServiceNow's data protection functionality, but I would not advise it - even if there was just simply deactivating a BR.
Doing so would not be best practice and learning to work within the platforms constraints is one of the most important things a ServiceNow developer should learn.

The fix would be to run a background script and truncate impacted records or all records, then update the field.

[RaghavSh]

You cannot change the length of a column if the column has some value in it. In fact you cannot change anything on dictionary level (type or length) of a column on table if that column stores any value.

Refer : https://support.servicenow.com/kb?id=kb_article_view&sysparm_article=KB0726986