Unique Key violation detected by database ((conn=112820) Duplicate entry

[Barathk]

Hi Team,
I am facing Unique Key violation detected by database issue.
can any one please help me to fix this issue.
log:
FAILED TRYING TO EXECUTE ON CONNECTION glide.3 (connpid=112795): INSERT INTO task (`made_sla`,`upon_reject`,`sys_updated_on`,`task_effective_number`,`a_int_1`,`number`,`sys_updated_by`,`opened_by`,`a_bln_6`,`sys_created_on`,`a_bln_7`,`sys_domain`,`a_bln_12`,`state`,`sys_created_by`,`knowledge`,`a_bln_17`,`a_num_13`,`a_bln_9`,`impact`,`active`,`a_num_12`,`a_bln_11`,`sys_domain_path`,`priority`,`a_bln_5`,`opened_at`,`a_str_15`,`approval_set`,`a_bln_14`,`a_bln_18`,`calendar_duration`,`a_bln_3`,`a_bln_21`,`sys_class_name`,`sys_id`,`a_bln_15`,`contact_type`,`a_bln_1`,`urgency`,`a_bln_20`,`reassignment_count`,`a_bln_13`,`a_str_41`,`approval`,`sys_mod_count`,`u_global_state`,`a_str_42`,`a_bln_10`,`a_bln_2`,`a_num_11`,`a_bln_8`,`a_bln_16`,`escalation`,`upon_approval`,`a_bln_19`,`a_int_9`,`a_bln_4`) VALUES(1,'cancel','2025-02-06 16:36:10','HRC001235',0,'HRC001235','bc','938e9072c064283cbb353b',1,'2025-02-06 16:36:10',0,'global',0,1,'bc',0,0,0,0,1,1,0,0,'/',4,0,'2025-02-06 16:36:10',NULL,NULL,0,0,NULL,0,0,'sn_hr_le_case','e4bfc7a6369d1dba1002',0,'self-service',0,3,0,0,0,'_ticket_option_1','not requested',0,'New','option_1',0,0,0,0,0,0,'proceed',0,0,0) /* dropboxtest005, gs:8779857193AB961047A6369D1DBA10B1, tx:a4bf093993ab961047a6369d1dba1021 */
Unique Key violation detected by database ((conn=112795) Duplicate entry 'e4bfc97993ab961047a6369d1dba1002' for key 'PRIMARY')
: java.sql.SQLIntegrityConstraintViolationException: (conn=112795) Duplicate entry 'e4bfc97993ab961047a6369d1dba1002' for key 'PRIMARY': org.mariadb.jdbc.internal.util.exceptions.ExceptionMapper.get(ExceptionMapper.java:229)
org.mariadb.jdbc.internal.util.exceptions.ExceptionMapper.getException(ExceptionMapper.java:165)
org.mariadb.jdbc.MariaDbStatement.executeExceptionEpilogue(MariaDbStatement.java:238)
org.mariadb.jdbc.MariaDbStatement.executeInternal(MariaDbStatement.java:355)
org.mariadb.jdbc.MariaDbStatement.execute(MariaDbStatement.java:406)
jdk.internal.reflect.GeneratedMethodAccessor4.invoke(Unknown Source)
java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
java.base/java.lang.reflect.Method.invoke(Method.java:569)
com.glide.db.StatementWrapper.invoke(StatementWrapper.java:42)
com.glide.db.AConnectionWrapperProxy.invoke(AConnectionWrapperProxy.java:34)
com.glide.db.StatementWrapper.invoke(StatementWrapper.java:19)
jdk.proxy4/jdk.proxy4.$Proxy8.execute(Unknown Source)
com.glide.db.DBI.executeStatement0(DBI.java:1605)
com.glide.db.DBI.executeStatement(DBI.java:1529)
com.glide.db.DBAction.executeAsResultSet(DBAction.java:450)
com.glide.db.DBCompositeAction.executeAsResultSet(DBCompositeAction.java:393)
com.glide.db.DBCompositeAction.executeChunk(DBCompositeAction.java:240)
com.glide.db.DBCompositeAction.executeAsResultSet0(DBCompositeAction.java:164)
com.glide.db.DBAction.executeAndReturnTable(DBAction.java:393)
com.glide.db.DBAction.executeNormal(DBAction.java:382)
com.glide.db.DBAction.executeAndReturnException(DBAction.java:330)
com.glide.script.GlideRecordITable.insert(GlideRecordITable.java:185)
com.glide.script.NonCancelableAuditExecutor.doOperation(NonCancelableAuditExecutor.java:72)
com.glide.script.GlideRecord.insert(GlideRecord.java:5319)
com.glide.script.GlideRecord.insert(GlideRecord.java:5224)
com.glide.script.GlideRecord.jsFunction_update(GlideRecord.java:4570)
com.glide.script.fencing.ScopedGlideRecord.jsFunction_update(ScopedGlideRecord.java:235)
java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:77)
java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
java.base/java.lang.reflect.Method.invoke(Method.java:569)
org.mozilla.javascript.MemberBox.invoke(MemberBox.java:151)
org.mozilla.javascript.FunctionObject.doInvoke(FunctionObject.java:717)
org.mozilla.javascript.FunctionObject.call(FunctionObject.java:654)
org.mozilla.javascript.ScriptRuntime.doCall(ScriptRuntime.java:2973)
org.mozilla.javascript.Interpreter.interpretLoop(Interpreter.java:1720)
org.mozilla.javascript.Interpreter.interpret(Interpreter.java:1030)
org.mozilla.javascript.InterpretedFunction.lambda$call$0(InterpretedFunction.java:161)
com.glide.caller.gen.sys_ui_page_497fe933625a9ed5c7b34_processing_script.call(Unknown Source)
com.glide.script.ScriptCaller.call(ScriptCaller.java:22)
org.mozilla.javascript.InterpretedFunction.call(InterpretedFunction.java:160)
org.mozilla.javascript.ScriptRuntime.doCall2(ScriptRuntime.java:3061)
org.mozilla.javascript.ScriptRuntime.doCall(ScriptRuntime.java:2981)
org.mozilla.javascript.Interpreter.interpretLoop(Interpreter.java:1720)
org.mozilla.javascript.Interpreter.interpret(Interpreter.java:1030)
org.mozilla.javascript.InterpretedFunction.lambda$call$0(InterpretedFunction.java:161)
com.glide.caller.gen.sys_ui_page_497fe933625a9ed5c7b34_processing_script.call(Unknown Source)
com.glide.script.ScriptCaller.call(ScriptCaller.java:22)
org.mozilla.javascript.InterpretedFunction.call(InterpretedFunction.java:160)
org.mozilla.javascript.ContextFactory.doTopCall(ContextFactory.java:731)
org.mozilla.javascript.ScriptRuntime.doTopCall(ScriptRuntime.java:4027)
org.mozilla.javascript.InterpretedFunction.exec(InterpretedFunction.java:173)
com.glide.script.ScriptEvaluator.execute(ScriptEvaluator.java:419)
com.glide.script.ScriptEvaluator.evaluateString(ScriptEvaluator.java:230)
com.glide.script.ScriptEvaluator.evaluateString(ScriptEvaluator.java:147)
com.glide.script.GlideRhinoHelper.evaluateAsString(GlideRhinoHelper.java:150)
com.glide.ui_page.UIPageProcessor.processPage(UIPageProcessor.java:139)
com.glide.ui_page.UIPageProcessor.process(UIPageProcessor.java:86)
com.glide.processors.AProcessor.runProcessor(AProcessor.java:759)
com.glide.processors.AProcessor.processTransaction(AProcessor.java:313)
com.glide.processors.ProcessorRegistry.process0(ProcessorRegistry.java:187)
com.glide.processors.ProcessorRegistry.process(ProcessorRegistry.java:175)
com.glide.ui.GlideServletTransaction.process(GlideServletTransaction.java:58)
com.glide.sys.Transaction.run(Transaction.java:2734)
com.glide.ui.HTTPTransaction.run(HTTPTransaction.java:35)
java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1136)
java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:635)
java.base/java.lang.Thread.run(Thread.java:840)

[Seema Hegde]

Looks like you are trying to create a record with a Sys ID that already exists in the system. What actions were you taking when this error was generated?

[Barathk]

Hi @Seema Hegde 
we have UI action called Transfer case ,once click the transfercase the we have to select which HR service need to be transfer. once selected and click submit the case is transferring but its getting the error also,

[Seema Hegde]

@Barathk  - sorry for the delay in responding. Do you know if the OOB Case transfer code has been customized? Transfer case UI action should create a new record without using the same Sys ID. If customized, check against baseline code. 

If you're unable to debug, I suggest you raise a support case with ServiceNow.