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:
- 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
- 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