1098 Export Error
Problem: When trying to run the 1098 Export get the following error:
---------------------------
VBScript: Update error occurred
---------------------------
A data or business logic error has occurred in this application. Information about this error has been logged in your institution's database. The following information will assist support personnel in troubleshooting the problem:
Error number:100 Error description:Unable to complete StateReports:busState:Get1098TExport method
---------------------------
The error detail in CAMS Manager >View Error Log is:
Unable to complete StateReports:busState:Get1098TExport method
VisualBasic Error num: -2147217833
Desc: String or binary data would be truncated.
Possible Solution: This tells us that a field is too long for the export file. Normally it would be either the SSN field or the Student Name field. More likely it is the SSN as the SSN field can only have 9 numbers and 2 dashes. The SSN does not have to have any dashes. But if it is more than 9 numbers long it can only be dashes in the SSN.
To see which SSNs are incorrect you can use the following scripts:
SELECT StudentSSN
FROM IRSForm1098
WHERE LEN(REPLACE(StudentSSN, '-', '')) >9
Then take the SSN(s) and run the following script to find the student's name:
SELECT Lastname, Firstname FROM Student WHERE StudentSSN = {SSN from above}