How to handle errors insert multiple REST API call - Exception during batch statement commit

[VaranAwesomenow]

This article covers troubleshooting steps for below error

Error in inserting data as a batch

When a 3rd party system consumes ServiceNow REST API  Glide insert multiple below error occurs for following reason

If 3rd party system is trying to map sys_id of sys_import_set_row as part of API call and if the value is not unique then ServiceNow will fail to insert data to import set table that contains the import set row.

Fix : Update mappings in source system to not map sys_id field of sys_import_set_row table.

Full details of error : Error in inserting data as a batch","detail":"

[Exception during batch statement commit to glide:client_1:clientedge:jdbc:mysql://xxx1111.xq1121.service-now.com:3409/, f

alling back to single commits: (conn=1641109) Duplicate entry '95e7c9d31b78d510964085d5624bcb9d' for key 'PRIMARY',

Exceptionduringstatementtoclient_1: INSERTINTOsys_import_set_row

(`sys_mod_count`,`sys_updated_on`,`sys_class_name`,`sys_import_state`,`sys_id`,`sys_updated_by`,`sys_created_on`,`sys_import_set`,`sys_created_by`,`sys_import_row`)

VALUES(0,'2022-08-02 06:21:38','u_staging_table','pending','95XXX9d31b78d510964085d5624bcb9d','IntUser','2022-08-02 06:21:38','79f5dXXX7819190779714900153af5a','IntUser',975)