PO00078: DUPLICATE RECORDS ARE BEING INSERTED IN THE ENVELOPE TABLE

APAR status

• Closed as program error.

Error description

• Duplicate records are being inserted in the envelope table for
  certain transactional mailings causing the RCT to generate
  errors and not insert any record until duplicate records are
  removed manually.
   Here is an example error message:
  Caused by: java.sql.BatchUpdateException: Violation of PRIMARY
  KEY constraint 'tEnvelope_PK'. Cannot insert duplicate key in
  object 'dbo. UCC_Envelope'. The duplicate key value is
  (133041000000000001, 33041).
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * All TMS users                                                *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * Duplicate records with the same envelopid were attempted to  *
  * be inserted into the UCC_Envelope Table for emessage System  *
  * tables by the RCT. This caused the RCT contact data queue to *
  * be backed up on the eMessage Hosted Side .                   *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * No action required this issue has been fixed on the Hosted   *
  * side.                                                        *
  ****************************************************************
  

Problem conclusion

• The root cause was identified as the TMS sub system in eMessage
  had a defect that was causing the ids to be duplicated. The root
  cause was fixed with a Patch on the eMessage Hosted side that
  was rolled out on 09/12/12
  

Temporary fix

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

Modules/Macros

• TMS
  

Fix information

• Fixed component name

  UNICA EMESSAGE

• Fixed component ID

  5725E2800

Applicable component levels

• R850 PSY

     UP