Built something you're proud of? Tell the story. A quick G2 review of App Engine or Build Agent helps other developers see what's possible on ServiceNow. Share your experience.

FAILED TRYING TO EXECUTE ON CONNECTION glide.29

John Spirko
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

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

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