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 "Service", table "dbo.E3_Loan", column 'InterestRate'

The statement has been terminated.

Other extended error information may also be included at this point.

Root Cause:

This error indicates that E3 has exported incorrect data and your Servicing Director SQL server is rejecting it.

Workaround:

Use E3 customer support to identify which fields are rejected and correct them in E3 before exporting the loan data again.

Capture the entire, extended error message text, and contact D+H Support using Case Management on the Finastra Customer Success Community website.

ArticleNumber:

000038658

Related Articles
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 ...
Servicing Director 7.8 Known Issue: The Event Manager>Daily Delinquency Counters Update Error: "T_DelinquentCounters_Update : The INSERT statement conflicted..."
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 ...
Servicing Director Year End Rollover Update Fails With Error: Insert Statement Conflicted With Column Check Constraint ...Table EndofYear, Column PointsPaid
Error Running Stored Procedure: Insert statement conflicted with column check constraint 'CK_ENDOFYEAR_POINT_0524B3A7' The conflict occurred in database 'Service', table 'EndofYear', column 'PointsPaid' The statement has been terminated. Root Cause: ...
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 ...
Servicing Director Event Manager LP Build Import Data in Loan Setup Event Error: "Unable to load XML file"
Run-Time Error < Object: "TheView", Event: "EventInitialize", Line: 28 > Unable to load XML file (C:\SvcData\MapFiles\HFS_LaserPro_Import.eix): Line (0,0): The system cannot locate the resource specified. Root Cause: This is an issue for current ...

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

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

Related Articles

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

Servicing Director 7.8 Known Issue: The Event Manager>Daily Delinquency Counters Update Error: "T_DelinquentCounters_Update : The INSERT statement conflicted..."

Servicing Director Year End Rollover Update Fails With Error: Insert Statement Conflicted With Column Check Constraint ...Table EndofYear, Column PointsPaid

Servicing Director 7.9 Known Issue: The Event Manager>Daily Delinquency Counters Update Error: "T_DelinquentCounters_Update : The INSERT statement conflicted...Contact"

Servicing Director Event Manager LP Build Import Data in Loan Setup Event Error: "Unable to load XML file"