Sowmyasree2
Tera Contributor

Same issue with me as well, it worked well earlier till Apr 9 and i tried today Apr 19 , in these 2 weeks i started getting this error .

I have added the errors to ignored /warming list but nothing worked .

This step failed because the client error 'FAILED TRYING TO EXECUTE ON CONNECTION glide.16 (connpid=73044668): INSERT INTO task (`made_sla`,`upon_reject`,`sys_updated_on`,`a_str_28`,`task_effective_number`,`a_int_1`,`number`,`sys_updated_by`,`a_str_22`,`opened_by`,`a_bln_15`,`a_bln_6`,`a_bln_7`,`sys_created_on`,`sys_domain`,`a_ref_19`,`a_ref_8`,`state`,`sys_created_by`,`knowledge`,`a_num_27`,`a_ref_9`,`a_bln_9`,`a_ref_22`,`a_num_26`,`active`,`a_bln_16`,`sys_domain_path`,`priority`,`a_ref_21`,`a_bln_5`,`opened_at`,`approval_set`,`a_str_20`,`a_bln_14`,`a_ref_20`,`short_description`,`assignment_group`,`description`,`a_ref_17`,`calendar_duration`,`a_bln_3`,`sys_class_name`,`sys_id`,`contact_type`,`a_bln_1`,`company`,`reassignment_count`,`a_ref_5`,`variables`,`comments`,`approval`,`a_ref_13`,`sys_mod_count`,`a_bln_17`,`a_bln_2`,`a_num_18`,`a_bln_13`,`upon_approval`,`escalation`,`location`,`a_ref_18`,`a_bln_4`) VALUES(1,'cancel','2024-04-19 14:32:20','The following fields have been provided:<br /><br />Who is submitting this request (name of manager/director/EMG)? : Rebecca Marion (Director, Bank Agile Product Management)<br /><br />What is the name of the employee requesting an exception to borrow PTO days? : Rebecca Marion (Director, Bank Agile Product Management)<br /><br />What is the total number of PTO days you are approving your employee to borrow? (Note: must enter a whole number. Example: If your employee wants to borrow 14 days, enter 14):: 10<br /><br />What is the total number of PTO hours you are approving your employee to borrow (Note: must enter a whole number. Example: If your employee is borrowing 14 days and works 8 hours per day, then multiply 14 days X 8 hours per day and enter 112): 80<br /><br />Begnning Month: January<br /><br />Ending Month: February<br /><br />This exception requires EMG approval - Enter the name of the EMG who approved the request:: Caren Puckett (AVP, Compliance - Bank)<br /><br />','HRC0101373',0,'HRC0101373','PL4M836','{\"Total_Number_Of_PTO_Hours\":\"80\",\"begnning_month\":\"january\",\"ending_month\":\"february\",\"requester_person\":\"63b5c3b697416d506254bb98c253afc3\",\"subject_person\":\"63b5c3b697416d506254bb98c253afc3\",\"what_is_the_name_of_emg_who_approved_the_request\":\"1ec95688c33721d4a6783d1f0501314c\",\"what_is_the_total_number_of_pto_days_you_are_approving_your_employee_to_borrow_example_if_your_emplo\":\"10\"}','63b5c3b697416d506254bb98c253afc3',0,1,0,'2024-04-19 14:32:20','global','0001e208c3b721d4a6783d1f05013115','cb865e40c3f321d4a6783d1f050131a1',10,'PL4M836',0,0,'7f722f3d979e6990e3c372f11153af9b',0,'674d9779979a6990e3c372f11153afc0',0,1,0,'/',4,'b19cd375979a6990e3c372f11153af94',0,'2024-04-19 14:32:20',NULL,NULL,0,NULL,'Manage Time Off Inquiry case for Rebecca Marion (Director, Bank Agile Product Management)','d0369ff5c3b2e5d0d05930dc7a0131c2','The following fields have been provided:
 
Who is submitting this request (name of manager/director/EMG)? : Rebecca Marion (Director, Bank Agile Product Management)
 
What is the name of the employee requesting an exception to borrow PTO days? : Rebecca Marion (Director, Bank Agile Product Management)
 
What is the total number of PTO days you are approving your employee to borrow? (Note: must enter a whole number. Example: If your employee wants to borrow 14 days, enter 14):: 10
 
What is the total number of PTO hours you are approving your employee to borrow (Note: must enter a whole number. Example: If your employee is borrowing 14 days and works 8 hours per day, then multiply 14 days X 8 hours per day and enter 112): 80
 
Begnning Month: January
 
Ending Month: February
 
This exception requires EMG approval - Enter the name of the EMG who approved the request:: Caren Puckett (AVP, Compliance - Bank)
 
','63b5c3b697416d506254bb98c253afc3',NULL,0,'sn_hr_core_case','77697bd347e986141e1443a1026d4371','portal',0,'10402290979bb8d4506330f3a253af2e',0,'eedf9e2387625950b4f9a82d0ebb35c5',NULL,NULL,'not requested','63b5c3b697416d506254bb98c253afc3',0,0,0,0,0,'proceed',0,'1f0d681d978cb1506c01fbe0f053af09','cb865e40c3f321d4a6783d1f050131a1',0) /* devusaa023, gs:8E623317472D46141E1443A1026D4382, tx:0689ff13476586141e1443a1026d436a */ 
Unique Key violation detected by database ((conn=73044668) Duplicate entry '77697bd347e986141e1443a1026d4371' for key 'PRIMARY')
: java.sql.SQLIntegrityConstraintViolationException: (conn=73044668) Duplicate entry '77697bd347e986141e1443a1026d4371' 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:566)
com.glide.db.StatementWrapper.invoke(StatementWrapper.java:42)
com.glide.db.AConnectionWrapperProxy.invoke(AConnectionWrapperProxy.java:34)
com.glide.db.StatementWrapper.invoke(StatementWrapper.java:19)
com.sun.proxy.$Proxy7.execute(Unknown Source)
com.glide.db.DBI.executeStatement0(DBI.java:1513)
com.glide.db.DBI.executeStatement(DBI.java:1439)
com.glide.db.DBAction.executeAsResultSet(DBAction.java:442)
com.glide.db.DBCompositeAction.executeAsResultSet(DBCompositeAction.java:266)
com.glide.db.DBCompositeAction.executeChunk(DBCompositeAction.java:226)
com.glide.db.DBCompositeAction.executeAsResultSet0(DBCompositeAction.java:150)
com.glide.db.DBAction.executeAndReturnTable(DBAction.java:385)
com.glide.db.DBAction.executeNormal(DBAction.java:374)
com.glide.db.DBAction.executeAndReturnException(DBAction.java:328)
com.glide.script.GlideRecordITable.insert(GlideRecordITable.java:165)
com.glide.script.GlideRecord.insert(GlideRecord.java:5243)
com.glide.script.GlideRecord.insert(GlideRecord.java:5150)
com.glideapp.servicecatalog.valve.ProducerValve.insertOrUpdateRecord(ProducerValve.java:800)
com.glideapp.servicecatalog.valve.ProducerValve.produceItem(ProducerValve.java:538)
com.glideapp.servicecatalog.valve.DataProducer.produce(DataProducer.java:12)
com.glideapp.servicecatalog.valve.ProducerValve.produceItem(ProducerValve.java:430)
com.glideapp.servicecatalog.valve.ProducerValve.initProduceItem(ProducerValve.java:347)
com.glideapp.servicecatalog.valve.ProducerValve.produceItem(ProducerValve.java:356)
com.glideapp.servicecatalog.CatalogItem.submitProducer(CatalogItem.java:2224)
com.glideapp.servicecatalog.scoped.api.CatalogItemJS.jsFunction_submitProducer(CatalogItemJS.java:624)
java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
java.base/java.lang.reflect.Method.invoke(Method.java:566)
org.mozilla.javascript.MemberBox.invoke(MemberBox.java:138)
org.mozilla.javascript.FunctionObject.doInvoke(FunctionObject.java:677)
org.mozilla.javascript.FunctionObject.call(FunctionObject.java:614)
org.mozilla.javascript.ScriptRuntime.doCall(ScriptRuntime.java:2649)
org.mozilla.javascript.Interpreter.interpretLoop(Interpreter.java:1518)
org.mozilla.javascript.Interpreter.interpret(Interpreter.java:830)
org.mozilla.javascript.InterpretedFunction.lambda$call$0(InterpretedFunction.java:160)
com.glide.caller.gen.sys_ws_operation_4b9f0a8967101200d22b794717415a30_operation_script.call(Unknown Source)
com.glide.script.ScriptCaller.call(ScriptCaller.java:22)
org.mozilla.javascript.InterpretedFunction.call(InterpretedFunction.java:159)
org.mozilla.javascript.ScriptRuntime.doCall2(ScriptRuntime.java:2734)
org.mozilla.javascript.ScriptRuntime.doCall(ScriptRuntime.java:2657)
org.mozilla.javascript.Interpreter.interpretLoop(Interpreter.java:1518)
org.mozilla.javascript.Interpreter.interpret(Interpreter.java:830)
org.mozilla.javascript.InterpretedFunction.lambda$call$0(InterpretedFunction.java:160)
com.glide.caller.gen.sys_ws_operation_4b9f0a8967101200d22b794717415a30_operation_script.call(Unknown Source)
com.glide.script.ScriptCaller.call(ScriptCaller.java:22)
org.mozilla.javascript.InterpretedFunction.call(InterpretedFunction.java:159)
org.mozilla.javascript.ContextFactory.doTopCall(ContextFactory.java:597)
org.mozilla.javascript.ScriptRuntime.doTopCall(ScriptRuntime.java:3573)
org.mozilla.javascript.InterpretedFunction.exec(InterpretedFunction.java:172)
com.glide.script.ScriptEvaluator.execute(ScriptEvaluator.java:408)
com.glide.script.ScriptEvaluator.evaluateString(ScriptEvaluator.java:218)
com.glide.script.ScriptEvaluator.evaluateString(ScriptEvaluator.java:137)
com.glide.script.fencing.GlideScopedEvaluator.evaluateScript(GlideScopedEvaluator.java:363)
com.glide.script.fencing.GlideScopedEvaluator.evaluateScript(GlideScopedEvaluator.java:250)
com.glide.script.fencing.GlideScopedEvaluator.evaluateScript(GlideScopedEvaluator.java:229)
com.glide.rest.service.custom.CustomService.runScript(CustomService.java:90)
com.glide.rest.service.custom.CustomService.execute(CustomService.java:77)
com.glide.rest.handler.impl.ServiceHandlerImpl.invokeService(ServiceHandlerImpl.java:37)
com.glide.rest.processors.RESTAPIProcessor.process(RESTAPIProcessor.java:346)
com.glide.processors.AProcessor.runProcessor(AProcessor.java:734)
com.glide.processors.AProcessor.processTransaction(AProcessor.java:292)
com.glide.processors.ProcessorRegistry.process0(ProcessorRegistry.java:187)
com.glide.processors.ProcessorRegistry.lambda$processWithRollbackRecording$0(ProcessorRegistry.java:408)
com.glide.rollback.recording.RollbackRecorder.execute(RollbackRecorder.java:67)
com.glide.processors.ProcessorRegistry.processWithRollbackRecording(ProcessorRegistry.java:404)
com.glide.processors.ProcessorRegistry.process(ProcessorRegistry.java:173)
com.glide.ui.GlideServletTransaction.process(GlideServletTransaction.java:58)
com.glide.sys.Transaction.run(Transaction.java:2645)
com.glide.ui.HTTPTransaction.run(HTTPTransaction.java:30)
java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128)
java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628)
java.base/java.lang.Thread.run(Thread.java:829)
' was detected on the page being tested. See failing Test Logs. To ignore these errors in the next test run, use 'Add all client errors to warning/ignored list' links.