Error log - FAILED TRYING TO EXECUTE ON CONNECTION

[Baskarank]

How to fix this issue - FAILED TRYING TO EXECUTE ON CONNECTION glide.2 (connpid=742058): INSERT INTO ua_defn_agg_data ("time_stamp","sys_mod_count","sys_updated_on","sys_domain_path","group1","agg_type","sys_id","definition_id","sys_updated_by","agg_col","sys_created_on","sys_domain","group_by","agg_val","sys_created_by") VALUES('2024-11-25',0,'2024-11-26 12:00:23+00','/','20231025','count(distinct','471edd663bc6521011da22aaa4e45a3a','DEFN2008520','system','indicator.name','2024-11-26 12:00:23+00','global','start_at',5,'system') /* rosendindev005, gs:glide.scheduler.worker.4, tx:550e59663bc6521011da22aaa4e45abb ➚ ➚ */
Unique Key violation detected by database (ERROR: duplicate key value violates unique constraint "ua_defn_agg_data_pkey"
Detail: Key (sys_id)=(471edd663bc6521011da22aaa4e45a3a) already exists.)
: com.glide.db.GlideSQLException: FAILED TRYING TO EXECUTE ON CONNECTION glide.2 (connpid=742058): INSERT INTO ua_defn_agg_data ("time_stamp","sys_mod_count","sys_updated_on","sys_domain_path","group1","agg_type","sys_id","definition_id","sys_updated_by","agg_col","sys_created_on","sys_domain","group_by","agg_val","sys_created_by") VALUES('2024-11-25',0,'2024-11-26 12:00:23+00','/','20231025','count(distinct','471edd663bc6521011da22aaa4e45a3a','DEFN2008520','system','indicator.name','2024-11-26 12:00:23+00','global','start_at',5,'system') /* rosendindev005, gs:glide.scheduler.worker.4, tx:550e59663bc6521011da22aaa4e45abb ➚ ➚ */
Unique Key violation detected by database (ERROR: duplicate key value violates unique constraint "ua_defn_agg_data_pkey"
Detail: Key (sys_id)=(471edd663bc6521011da22aaa4e45a3a) already exists.)
: com.glide.db.DBIError.wrapAndThrow(DBIError.java:171)
com.glide.db.DBIError.handleException(DBIError.java:104)
com.glide.db.DBI.executeStatement(DBI.java:1553)
com.glide.db.DBI.executeStatement(DBI.java:1435)

[Valmik Patil1]

Hello @Baskarank ,

This Issue is because, record with similar configuration is available in the table you are trying to insert and it is not allowing to insert record.

Please check the records of table you are trying to perform insert operation and delete existing record.

Mark ✅ Correct if this solves your issue and also mark 👍 Helpful if you find my response worthy based on the

impact.

Thanks,

Valmik Patil  

[Baskarank]

Thank you for Your reply

yes, I understand the issue already user record is there then again update any one feild (eg: termination_date) now it came that already exists  database error , and my side at a time bulk user data are mapped through the integration (FYI,attach that table transform map ) --   pls give me your suggestion  where to exact fix this issue for avoid the error log

[pmcain90]

Did you ever resolve the issue?