HELP: FAILED TRYING TO EXECUTE ON CONNECTION glide.14 (connpid=4504338): UPDATE core_company SET

[Borsay Suah]

Hello community,

I am running normalization and get this error in the system log:  what does this mean?

FAILED TRYING TO EXECUTE ON CONNECTION glide.14 (connpid=4504338): UPDATE core_company SET `sys_updated_by` = 'system', `name` = 'Asia', `sys_mod_count` = 1, `sys_updated_on` = '2020-04-30 13:54:03', `hash` = 'R32SalA4lsZQQCGOagQ+GQ==' WHERE core_company.`sys_id` = '5dc818b0db641c10b037ee71ca9619f2' /* aegondev006, gs:glide.scheduler.worker.7, tx:327f90b4dba41c10b037ee71ca961964 */
Unique Key violation detected by database ((conn=4504338) Duplicate entry 'R32SalA4lsZQQCGOagQ+GQ==' for key 'jasmgddx_canonical_hash_inde')
: java.sql.SQLIntegrityConstraintViolationException: (conn=4504338) Duplicate entry 'R32SalA4lsZQQCGOagQ+GQ==' for key 'jasmgddx_canonical_hash_inde': 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:239)
org.mariadb.jdbc.MariaDbStatement.executeInternal(MariaDbStatement.java:361)
org.mariadb.jdbc.MariaDbStatement.execute(MariaDbStatement.java:412)
sun.reflect.GeneratedMethodAccessor20.invoke(Unknown Source)
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
java.lang.reflect.Method.invoke(Method.java:498)
com.glide.db.StatementWrapper.invoke(StatementWrapper.java:44)
com.sun.proxy.$Proxy7.execute(Unknown Source)
com.glide.db.DBI.executeStatement0(DBI.java:1131)
com.glide.db.DBI.executeStatement(DBI.java:1087)
com.glide.db.DBI.executeStatement(DBI.java:1040)
com.glide.db.DBAction.executeAsResultSet(DBAction.java:289)
com.glide.db.DBCompositeAction.executeAsResultSet(DBCompositeAction.java:178)
com.glide.db.DBCompositeAction.executeChunk(DBCompositeAction.java:138)
com.glide.db.DBCompositeAction.executeAsResultSet0(DBCompositeAction.java:100)
com.glide.db.DBAction.executeAndReturnTable(DBAction.java:252)
com.glide.db.DBAction.executeNormal(DBAction.java:241)
com.glide.db.DBAction.executeAndReturnException(DBAction.java:195)
com.glide.script.GlideRecordITable.update(GlideRecordITable.java:193)
com.glide.script.GlideRecord.updateWithoutResettingOperation(GlideRecord.java:4552)
com.glide.script.GlideRecord.update(GlideRecord.java:4458)
com.glide.script.GlideRecord.update(GlideRecord.java:4377)
com.snc.field_normalization.AExtantDataJobRunner.safeUpdate(AExtantDataJobRunner.java:124)
com.snc.field_normalization.RuleApplier.runImpl(RuleApplier.java:54)
com.snc.field_normalization.AExtantDataJobRunner.lambda$run$0(AExtantDataJobRunner.java:54)
com.glide.rollback.recording.RollbackRecorder.execute(RollbackRecorder.java:67)
com.snc.field_normalization.AExtantDataJobRunner.run(AExtantDataJobRunner.java:52)
com.snc.field_normalization.ExtantDataJobRunner.execute(ExtantDataJobRunner.java:70)
com.glide.schedule.JobExecutor.lambda$executeJob$0(JobExecutor.java:108)
com.glide.schedule.JobExecutor.executeJob(JobExecutor.java:111)
com.glide.schedule.JobExecutor.execute(JobExecutor.java:95)
com.glide.schedule_v2.SchedulerWorkerThread.executeJob(SchedulerWorkerThread.java:329)
com.glide.schedule_v2.SchedulerWorkerThread.lambda$process$0(SchedulerWorkerThread.java:192)
com.glide.worker.TransactionalWorkerThread.executeInTransaction(TransactionalWorkerThread.java:35)
com.glide.schedule_v2.SchedulerWorkerThread.process(SchedulerWorkerThread.java:192)
com.glide.schedule_v2.SchedulerWorkerThread.run(SchedulerWorkerThread.java:100)

[Naveen20]

The hash has to be unique. Looks like you are trying to update a record with a hash already there -> R32SalA4lsZQQCGOagQ+GQ==

Please check the table(core_company) record having this hash already.

[Borsay Suah]

Hi Naveen, thank you for your help.  I checked the company table and there are no duplicate hash for R32SalA4lsZQQCGOagQ+GQ==.  

Is it best practice to modify the hash to make it unique since I keep getting this message?

Regards,

Suah

[Naveen20]

The hash has to be unique (always a best practice). 

Generally it is generated. Not sure how it is being generated here. The underlying code which is generating this hash has to be checked.

[Borsay Suah]

Thank you Naveen.

I don't see a duplicate Hash value in the core_company table, but the system keep throwing the error, what other things do you suggest in addition to checking the code?

Regard,

Suah