Genesys CTI User Forum

Genesys CTI User Forum => Genesys CTI Technical Discussion => Topic started by: C_Genesys on August 08, 2017, 11:57:00 AM

Title: Contact Server : Duplicated Persistent Error executing stmt
Post by: C_Genesys on August 08, 2017, 11:57:00 AM

I am getting below error on contact server logs and need to delete the below interaction , what should be the ideal approach to delete them from DB

contsrvz21.20170801_092350_762.log:09:27:45.204 Dbg 29999 [uningTask-4] <00030a9V1Q89VJGA 00030a9V1Q89VJG9> Insertion of EmailOut with Id '00030a9XXM323TRH' failed with error Duplicated Persistent Error executing stmt [insert into EmailOut (EmailOut.Id, EmailOut.StandardResponseId, EmailOut.ReferenceId, EmailOut.ReplyToAddress, EmailOut.Forward, EmailOut.CcAddresses, EmailOut.FromAddress, EmailOut.ReviewerId, EmailOut.SentDate, EmailOut.BccAddresses, EmailOut.ToAddresses, EmailOut.FromPersonal) values (?, ?, ?, null, ?, null, ?, null, ?, null, ?, ?) in transaction : 259791292@txn-txn-905600 with timeout=60] - ORA-00001: unique constraint (GCTICSADMINISTRATOR.PK_EMAILOUT) violated
contsrvz21.20170801_092350_762.log:09:27:45.470 Dbg 29999 [uningTask-4] <00030a9V1Q89VJGA 00030a9V1Q89VJG9> Insertion of EmailOut with Id '00030a9XXM32HTCY' failed with error Duplicated Persistent Error executing stmt [insert into EmailOut (EmailOut.Id, EmailOut.StandardResponseId, EmailOut.ReferenceId, EmailOut.ReplyToAddress, EmailOut.Forward, EmailOut.CcAddresses, EmailOut.FromAddress, EmailOut.ReviewerId, EmailOut.SentDate, EmailOut.BccAddresses, EmailOut.ToAddresses, EmailOut.FromPersonal) values (?, ?, ?, null, ?, null, ?, null, ?, null, ?, ?) in transaction : 259791292@txn-txn-905600 with timeout=60] - ORA-00001: unique constraint (GCTICSADMINISTRATOR.PK_EMAILOUT) violated

Title: Re: Contact Server : Duplicated Persistent Error executing stmt
Post by: cavagnaro on August 08, 2017, 02:20:25 PM

Open an eSR with Genesys please.
They will guide you better.