Error log - FAILED TRYING TO EXECUTE ON CONNECTION
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎05-15-2025 10:30 AM
Any ideas on how to fix this issue
FAILED TRYING TO EXECUTE ON CONNECTION glide.25 (connpid=24225035): INSERT INTO cmdb (`skip_sync`,`operational_status`,`sys_updated_on`,`last_discovered`,`can_print`,`sys_class_name`,`manufacturer`,`sys_id`,`discovery_source`,`first_discovered`,`sys_updated_by`,`a_int_12`,`sys_class_path`,`sys_created_on`,`sys_domain`,`sys_created_by`,`sys_mod_count`,`monitor`,`model_id`,`ip_address`,`sys_domain_path`,`cost_cc`,`install_status`,`name`,`unverified`,`category`,`fault_count`) VALUES(0,1,'2025-05-14 08:16:04','2025-05-14 08:16:04',0,'cmdb_ci_ip_address',NULL,'3c7f3af497656e1036aafe3bf253af39','SG-SCCM','2025-05-14 08:16:04','SGC-SCCM',4,'/!!/!V','2025-05-14 08:16:04','global','SGC-SCCM',0,0,'6a77d9694f063300070d04c85210c766','10.27.95.189','/','USD',1,'10.27.95.189',0,'Network',0),INSERT INTO cmdb$par1 (`operational_status`,`sys_updated_on`,`u_compliance_category`,`sys_class_name`,`sys_id`,`sys_updated_by`,`sys_class_path`,`sys_created_on`,`sys_domain`,`sys_created_by`,`attestation_status`,`sys_mod_count`,`sys_domain_path`,`install_status`,`u_l2_required`,`a_bln_7`,`name`,`attested`) VALUES(1,'2025-05-14 08:16:04','None','cmdb_ci_ip_address','3c7f3af497656e1036aafe3bf253af39','SGC-SCCM','/!!/!V','2025-05-14 08:16:04','global','SGC-SCCM','Not Yet Reviewed',0,'/',1,0,0,'10.27.95.189',0)
java.sql.BatchUpdateException: (conn=24225035) Duplicate entry '3c7f3af497656e1036aafe3bf253af39' for key 'PRIMARY'
: java.sql.SQLException: java.sql.BatchUpdateException: (conn=24225035) Duplicate entry '3c7f3af497656e1036aafe3bf253af39' for key 'PRIMARY': com.glide.db.StatementBatcher.getSQLException(StatementBatcher.java:805)
com.glide.db.StatementBatcher.commitBatch(StatementBatcher.java:710)
com.glide.db.StatementBatcher.commitAllOrNothing(StatementBatcher.java:523)
com.glide.db.DBCompositeAction.executeAsBatch(DBCompositeAction.java:423)
com.glide.db.DBCompositeAction.executeChunk(DBCompositeAction.java:242)
com.glide.db.DBCompositeAction.executeAsResultSet0(DBCompositeAction.java:168)
com.glide.db.DBAction.executeAndReturnTable(DBAction.java:425)
com.glide.db.DBAction.executeNormal(DBAction.java:414)
com.glide.db.DBAction.executeAndReturnException(DBAction.java:360)
com.glide.script.GlideRecordITable.insert(GlideRecordITable.java:191)
com.glide.script.NonCancelableAuditExecutor.doOperation(NonCancelableAuditExecutor.java:80)
com.glide.script.GlideRecord.insert(GlideRecord.java:5380)
com.glide.script.GlideRecord.insert(GlideRecord.java:5285)
com.snc.cmdb.identify_reconcile.RecordCommitter.commitInner(RecordCommitter.java:371)
com.snc.cmdb.identify_reconcile.RecordCommitter.commit(RecordCommitter.java:305)
com.snc.cmdb.identify_reconcile.IdentificationEngine.commitRecordsInBatches(IdentificationEngine.java:1070)
com.snc.cmdb.identify_reconcile.IdentificationEngine.process(IdentificationEngine.java:916)
com.snc.cmdb.identify_reconcile.IdentificationEngine.execute(IdentificationEngine.java:641)
com.snc.cmdb.identify_reconcile.IdentificationEngine.executeAndGenerateOutput(IdentificationEngine.java:563)
com.snc.cmdb.identify_reconcile.IdentificationEngine.execute(IdentificationEngine.java:520)
com.snc.cmdb.identify_reconcile.IdentificationEngine.createOrUpdateCI(IdentificationEngine.java:366)
com.snc.cmdb.identify_reconcile.PayloadMerger.execute(PayloadMerger.java:256)
com.snc.cmdb.identify_reconcile.PayloadMerger.mergeAndExecute0(PayloadMerger.java:324)
com.snc.cmdb.identify_reconcile.PayloadMerger.mergeAndExecute(PayloadMerger.java:66)
com.snc.cmdb.identify_reconcile.IdentificationEngine.createOrUpdateCI(IdentificationEngine.java:341)
com.snc.cmdb.identify_reconcile.listener.IREMessageListener.invokeIre(IREMessageListener.java:339)
com.snc.cmdb.identify_reconcile.listener.IREMessageListener.onMessages(IREMessageListener.java:154)
com.glide.db.impex.transformer.service.RobustImportSetTransformerDAO$ThrottlingListener.onMessages(RobustImportSetTransformerDAO.java:156)
com.glide.db.impex.transformer.service.RobustImportSetProcessor.processBatch(RobustImportSetProcessor.java:125)
com.glide.db.impex.transformer.service.RobustImportSetProcessor.transform(RobustImportSetProcessor.java:83)
com.glide.system_import_set.ImportSetTransformerImpl.doRobustImportSetTransform(ImportSetTransformerImpl.java:166)
com.glide.system_import_set.ImportSetTransformerImpl.transformAllMaps(ImportSetTransformerImpl.java:114)
com.glide.system_import_set.ImportSetTransformer.transformAllMaps(ImportSetTransformer.java:91)
com.snc.automation.ImportSetTransformerJob.runTransform(ImportSetTransformerJob.java:291)
com.snc.automation.ImportSetTransformerJob.execute(ImportSetTransformerJob.java:103)
com.glide.schedule.JobExecutor.lambda$executeJob$1(JobExecutor.java:195)
com.snc.db.data_replicate.replicator.DataReplicationAdvisors.runInOriginatorContext(DataReplicationAdvisors.java:74)
com.glide.schedule.JobExecutor.lambda$inDataReplicationContext$3(JobExecutor.java:225)
com.glide.schedule.JobExecutor.executeJob(JobExecutor.java:198)
com.glide.schedule.JobExecutor.execute(JobExecutor.java:178)
com.glide.schedule.JobExecutor.execute(JobExecutor.java:168)
com.glide.schedule_v2.SchedulerWorkerThread.executeJob(SchedulerWorkerThread.java:609)
com.glide.schedule_v2.SchedulerWorkerThread.lambda$process$2(SchedulerWorkerThread.java:402)
com.glide.worker.TransactionalWorkerThread.executeInTransaction(TransactionalWorkerThread.java:35)
com.glide.schedule_v2.SchedulerWorkerThread.process(SchedulerWorkerThread.java:402)
com.glide.schedule_v2.SchedulerWorkerThread.run(SchedulerWorkerThread.java:178)
0 REPLIES 0