Getting com.glide.db.GlideSQLException after increasing max length of the field

[timofeevbog]

I have created an update set where max length of 2 fields (u_ip_address and u_ip_address2) of table cmdb_ci are increased from 40 to 80. When trying to edit ip address via form, u_ip_address2 is ok (it can be up to 80 signs), while u_ip_address field is still no longer than 40. I had checked logs and discovered that there is an error

Unable to change column length: ip_address: com.glide.db.GlideSQLException: FAILED TRYING TO EXECUTE ON CONNECTION 16: CREATE TRIGGER zdelcmdb_ci AFTER DELETE ON cmdb_ci FOR EACH ROW DELETE IGNORE FROM tmp_c576071758i WHERE tmp_c576071758i.sys_id = OLD.sys_id

Syntax Error or Access Rule Violation detected by database (This version of MySQL doesn't yet support 'multiple triggers with the same action time and event for one table')

for ip_address and ip_address2 (but u_ip_address2 length is checked fine).

This update set works ok fine on our other 2 instances.

How can I solve this?

Thanks.

[JC Moller]

Hi,

Can you trace the update set in the logs and see if you got any other error/warning messages?

Field length changes can last for a while and one issue you might run into are transaction quotas rules and timeouts. I have seen this happen on very large tables.

Are there any "transaction cancelled" text strings in your logs at the time of the update?

How many rows of data do you have in the cmdb_ci -table.

- Jan

[JC Moller]

Hi,

This is the KB-article I was refering to related to the quota rules.

"PRB597639: Creating or altering a field on a large table from the UI can be canceled by "UI Transactions" Quota Rule"

https://hi.service-now.com/kb_view.do?sysparm_article=KB0547328

We have applied this fix prior to saving field length changes to large tables in production.

If you are having this issue in production, I would recommend you to consult SN Customer support first. Just to be on the safe side.

- Jan Möller

[timofeevbog]

Thanks.

This link leads me to https://community.servicenow.com/welcome page(

[JC Moller]

Hi,

Sorry.

https://hi.service-now.com/kb_view.do?sysparm_article=KB0547328

- Jan