Symptom
Running a report the following error occurs in the report.log
Accounting Report payments only prompted by dates
[Microsoft][ODBC SQL Server Driver][SQL Server]String or binary data would be truncated. Statement: update report_descripts set report_run_user = 'membber', report_run_date = '01/11/2018 09:53:39 AM', report_select_time = '00:00:16', report_format_time = '00:00:07', report_total_time = '00:00:23', report_records = '602', report_export_time = '00:00:00', report_format_name = 'JFYGHJ_ID_NAME_ADREESS_PAYMENTINFO_FOR ACCT WITHOUT PROMPTS FOR PLEDGES_WITH COMMENTS .RPT', report_export_owner = null, report_export_dbase = null, report_export_table = null where report_name='Accounting Report payments only prompted by dates' and report_type='U' and report_category='Financial & Giving' and report_groups=' ' Native Error: 8152. Total Time: 00:00:23
[Microsoft][ODBC SQL Server Driver][SQL Server]String or binary data would be truncated. Statement: update report_descripts set report_run_user = 'membber', report_run_date = '01/11/2018 09:53:39 AM', report_select_time = '00:00:16', report_format_time = '00:00:07', report_total_time = '00:00:23', report_records = '602', report_export_time = '00:00:00', report_format_name = 'JFYGHJ_ID_NAME_ADREESS_PAYMENTINFO_FOR ACCT WITHOUT PROMPTS FOR PLEDGES_WITH COMMENTS .RPT', report_export_owner = null, report_export_dbase = null, report_export_table = null where report_name='Accounting Report payments only prompted by dates' and report_type='U' and report_category='Financial & Giving' and report_groups=' ' Native Error: 8152. Total Time: 00:00:23
Cause
The format name is too long. The column report_format_name can only hold 80 characters.
Resolution
Save the format name with a name that is less than 80 characters.
Update any reports with the new format name and resave the report.
Update any reports with the new format name and resave the report.
Article Type
Product Info
Product Line
Millennium
Product Module/Feature
Reporting
Reports
Ranking