Troubleshooting
Problem
Duplicate key errors in the partner profile when setting up two Identical relationships (1902)
Symptom
Receiving Duplicate Key error when setting up more than one relationship for a partner
ODBC: MFC database exception encountered in PartnerLIB Error:
Cannot insert duplicate key row in object 'Relationship_tb' with unique index
'RelationshipKEY'.
The statement has been terminated.
Cannot insert
duplicate key row in object 'Relationship_tb' with unique index
'RelationshipKEY'.
The statement has been terminated.
SQL
Statement: SELECT
""PartnerKEY"",""Direction"",""Agency"",""Version"",""TransactionSetID"",""Relea
se"",""TestMode"",""Description"",""ImportTemplateKEY"",""DataEntryTemplateKEY""
,""TurnAroundTemplateKEY"",""ExportTemplateKEY"",""ExportFileName"",""ExportToFl
atFileNow"",""TurnAroundNow"",""SequenceCheckType"",""AckErrors"",""AckExpected"
",""HoursOverdue"",""AckTemplateKEY"",""AckTransactionSetID"",""ApplicationKEY""
,""Alias"",""FunctionalGroupControlKEY"",""InterchangeControlKEY"",""ControlNumb
er"",""PrintTemplateKEY"",""RelationshipTemplateKEY"",""SkipComplianceCheck"",""
ImmediateAckProcessing"",""IsAcknowledgement"",""ExportToMailbox"",""RecipientMa
ilbox"",""RecipientEMailAddress"",""ContentType"",""ContentSubType"" FROM
""Relationship_tb"" WHERE ""PartnerKEY"" = 'Partner Name' and ""Direction"" = 1
and ""Description"" = '810 - IN' ORDER BY ""PartnerKEY"" User: User Name
Computer: Server Name AuditEventID: 70523 EventName: gentran ."
Log InLog in to view more of this document
Historical Number
PRI2337
Was this topic helpful?
Document Information
Modified date:
16 June 2018
UID
swg21522197