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

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 Setup application, while trying to review a new loan before setting it to active.
This condition could be caused by another loan, still in a pending state, which has only been partially imported into the Servicing Director database. This loan, with possible missing records from key, required tables, may be causing other good loans from being reviewed and set to active in the Loan Setup application.
This problem pending loan, will most likely not be visible in the Loan Setup application screens.

This condition will most likely be caused by some custom loan import into Servicing Director.

Environment:

Loan Setup Review

Workaround:

The incomplete pending loan should be removed from the Service database.
Since the offending pending loan record is not visible in the Loan Setup application, you will need to look directly in the Service database to find it, then delete it.
These actions should be carried out by the IT Department or Database Administrator, after securing database backups.

To find the offending loan record, you should review your custom loan import to see which tables are meant to be populated, and which key tables are missing the new loan record.

Once the incomplete, partial loan record has been found, and removed from the database, you should be able to continue successfully reviewing new loans and setting them to active.

ArticleNumber:

000041907