String or Binary Data Truncated

<< Click to Display Table of Contents >>

Navigation:  Professional > Troubleshooting > Reporting Errors >

String or Binary Data Truncated

Affected Software/Reports/DLL(s): EQuIS Professional Reports


Affected Software Version: N/A


Symptoms: The following error can occur when running a report in EQuIS Professional.


System.Data.SqlClient.SqlException: String or binary data would be truncated.

at EarthSoft.Common.Data.SqlConnection.ExecuteFunction(String functionName, IDataParameterCollection parameters)

at EarthSoft.Common.Reports.FunctionReport.Execute() at EarthSoft.Common.Reports.FunctionReport.Execute(Int32 facilityId)

at EarthSoft.Reports.ReportGrid.backgroundWorker_DoWork(Object sender, DoWorkEventArgs e)


Cause/Details: This error may be caused by a customized EQuIS Schema or a customized report.


The error can occur if either field length or field data type in the custom database schema or custom report has been changed.


Resolution/Workaround: Check to confirm that the field lengths for the input and output parameters of a report match the data type and length of those in the database.