FAILED TRYING TO EXECUTE ON CONNECTION glide.29

John Spirko
ServiceNow Employee
ServiceNow Employee

I tried moving it to a different location. I query by sys_id and I don't find any other objects with that ID. Not matter what I try I can't get this one object to migrate from dev to stage.

Description: Every time I try to bring in a widget from dev to test I get this message in the update set for that widget:
FAILED TRYING TO EXECUTE ON CONNECTION glide.29 (connpid=1171568): INSERT INTO sys_metadata (`sys_updated_on`,`sys_class_name`,`sys_id`,`sys_updated_by`,`sys_created_on`,`sys_name`,`sys_scope`,`sys_created_by`,`sys_mod_count`,`sys_package`,`sys_update_name`,`sys_policy`) VALUES('2021-03-22 14:27:59','sp_widget','a7b322221b34e4108872b88e034bcb3a','John.Spirko','2020-12-03 16:28:04','ESRI Map Leaflet','global','jspirko',168,'global','sp_widget_a7b322221b34e4108872b88e034bcb3a',NULL),INSERT INTO sp_widget (`template`,`css`,`internal`,`link`,`description`,`sys_id`,`docs`,`public`,`client_script`,`id`,`field_list`,`demo_data`,`option_schema`,`script`,`has_preview`,`servicenow`,`data_table`,`name`,`category`,`controller_as`) VALUES('<div id=\"map\"></div>','#map { height: 100%; width: 100%; min-height: 350px; min-width: 300px; font-family: Arial, Helvetica, sans-serif; font-size: 14px; color: #323232; } If I try to import it via XML I get a key violation: java.sql.BatchUpdateException: (conn=1171551) Duplicate entry 'a7b322221b34e4108872b88e034bcb3a' for key 'PRIMARY'

 

1 ACCEPTED SOLUTION

John Spirko
ServiceNow Employee
ServiceNow Employee

I just cloned and relinked the widget and it went through.  No idea what the root cause was but the work around worked.

 

View solution in original post

1 REPLY 1

John Spirko
ServiceNow Employee
ServiceNow Employee

I just cloned and relinked the widget and it went through.  No idea what the root cause was but the work around worked.