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.

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.