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 ID already exists in your Servicing Director database Employer table.

Workaround:

Assign a different loan ID to the import loan data.

ArticleNumber:

000039701

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 Loan Transfer Import Error: "Error inserting Detail Record ..."
Error Inserting Detail record #<Record Number> Error Conversion failed when converting date and/or time from character string. Error Violation of PRIMARY KEY constraint '<Constraint Name>'. Cannot insert dupicate key in object '<Object Name>'. The ...
Servicing Director Loan Setup Review Error : The INSERT Statement Conflicted With The FOREIGN KEY Constraint "FK_BorrowerMailing_Borrower".
The INSERT statement conflicted with the FOREIGN KEY constraint "FK_BorrowerMailing_Borrower". The conflict occurred in database "Service", table "dbo.Borrower". The statement has been terminated. Root Cause: You may encounter this error in the Loan ...
Deleting a Loan From The Servicing Director Loan Setup Application Does Not Cascade Delete The Employer Table Record And Leaves Orphaned Database Records
In the Servicing Director Loan Setup application, a user has the ability to permanently delete a pending loan from the system. When you do so, the records should cascade delete and permanently remove that pending loan record from all of the related ...
Servicing Director Event Manager E3 Import Into Loan Setup Error: ...P_E3Import_Manual_Finish...INSERT Statement Conflicted With the CHECK Constraint...
An Internal error occurred. Some loans may not be complete. P_E3Import_Manual_Finish: Database Error during Open : The INSERT statement conflicted with the CHECK constraint "CK__E3_Loan__Interes__0309C310". The conflict occurred in database ...

Servicing Director Loan Import Error: "Failed on Employer table. Violation of PRIMARY KEY constraint 'Employer_PK' ..."

Servicing Director Loan Import Error: "Failed on Employer table. Violation of PRIMARY KEY constraint 'Employer_PK' ..."

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.'

Servicing Director Loan Transfer Import Error: "Error inserting Detail Record ..."

Servicing Director Loan Setup Review Error : The INSERT Statement Conflicted With The FOREIGN KEY Constraint "FK_BorrowerMailing_Borrower".

Deleting a Loan From The Servicing Director Loan Setup Application Does Not Cascade Delete The Employer Table Record And Leaves Orphaned Database Records

Servicing Director Event Manager E3 Import Into Loan Setup Error: ...P_E3Import_Manual_Finish...INSERT Statement Conflicted With the CHECK Constraint...