Servicing Director 7.9 Known Issue: Payment Processing Error Posting Payoff: "...Cannot insert duplicate key in object 'dbo.BorrowerEmailAddress'..."
Violation of UNIQUE KEY constraint 'LoanID_Idx'. Cannot insert duplicate key in object 'dbo.BorrowerEmailAddress'. The statement has been terminated.
Root Cause:
This is an issue found on Servicing Director 7.9 or Servicing Director 7.9 with Service Pack 1.
Workaround:
The issue addressed in this article was resolved in Servicing Director version 8.0.
ArticleNumber:
000039325
Related Articles
Servicing Director Error Message When Posting A Batch : "'Violation of PRIMARY KEY constraint 'aaaaaXXXXXXX_PK. Cannot insert duplicate key in object 'dbo.XXXXXXXXX.'
Violation of PRIMARY KEY constraint 'aaaaaXXXXXXX_PK. Cannot insert duplicate key in object 'dbo.XXXXXXXXX Root Cause: This error message may be encountered when attempting to post a payment batch, a loan modification batch, an insurance or tax ...
Servicing Director Freddie Mac EDR (Midanet) Export Event Error: "Cannot insert duplicate key..."
Error running procedure: P_Frd_EDR_BuildDAC Cannot insert duplicate key row in object ''dbo.LoanDEvents'' with unique index ''IDX_LoanDEvents_Unq''. The duplicate key value is (####, ##,<Date>, 0). The statement has been terminated. Root Cause: This ...
Servicing Director 7.9 Known Issue: The Event Manager>Daily Delinquency Counters Update Error: "T_DelinquentCounters_Update : The INSERT statement conflicted...Contact"
The event failed and reported this error: T_DelinquentCounters_Update : The INSERT statement conflicted with the FOREIGN KEY constraint "FK_LoanStatistics_Contact". The conflict occurred in database "Service", table "dbo.Contact". The statement has ...
Error: Cannot insert duplicate key row, when entering CCR/CTR information on specific account(s)
2147217873 - cannot insert duplicate key row in object 'dbo. EntityAccountInfo' with unique index 'IX_EntityAccountInfo_1'. Error occurred in Microsoft OLE DB Provider for SQL Server. Operation failed. The current screen will shut down. OK Root ...
Servicing Director Loan Import Error: "Failed on Employer table. Violation of PRIMARY KEY constraint 'Employer_PK' ..."
Failed on Employer table. Violation of PRIMARY KEY constraint 'Employer_PK'. Cannot insert duplicate key in object 'dbo.Employer'. The duplicate key value is (<Loan ID?, 0, 1). Root Cause: This is an error from SQL server, indicating the given loan ...