We're reclaiming inactive PDIs to keep them available for active builders. Learn what's changing, who's affected, and how to protect your work. Read More

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.