Servicing Director Collections Contact Error: "ContactTable: Database Error during Open: Data truncated."

Servicing Director Collections Contact Error: "ContactTable: Database Error during Open: Data truncated."

ContactTable: Database Error during Open: Data truncated.


Root Cause:

When you open the Collections Contact screen for some loans, you can get this error because of a comments issue for certain loans in Servicing Director. 


Workaround:

  1. Have your database administrator locate the problem loans using the following SQL query in a SQL Server Management Studio New Query screen: 

SELECT DataLength(Comment), Status.LoanID , Comment

FROM Contact 

JOIN Status ON status.LoanID = Contact.LoanID

WHERE 

DATALENGTH(Comment) >= 268

AND primstat = 1

ORDER BY DataLength(Comment) DESC

  1. Using the results from step 1, open the loan(s) in Customer Service (not Collections) and edit the comments from the Comments screen to shorten them to less than 268 characters in length using your own choice of editing the comment text. 

ArticleNumber:

000039304