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

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:

The Servicing Director Year End Rollover Update fails with this error during end of year processing.

The Year End Rollover update does not work with negative values in the Points field in the Year To Date screen.
This is a data condition that needs to be corrected in your system before the Year End Rollover update will complete successfully.



 

Workaround:

Your IT dept or Database Administrator must run the following SQL select query to locate the problem loan(s) :

Use Service
Select * from YeartoDate
where points < 0

Thereafter, correct the Points paid on these loans in Customer Service > Balances > Year To Date > Points.
Then, run the Year End Rollover update again.
 

ArticleNumber:

000039973