Submitted by 334 on
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
 
 
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.
Article Type
Product Info
Product Line
Millennium
Product Module/Feature
Reporting
Reports
Ranking
No votes yet