DF-M23226- Excel output is not created when running express reports with the output type of Excel

Submitted by 334 on
Symptom
DF-M23226- Excel output is not created when running express reports with the output type of Excel. If the output type is html or pdf output is created and you can click on the thumbnail in express reports to view the report results.
Product Line
Millennium

String or binary data would be truncated error in report.log

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
 
 
Product Line
Millennium

Header name display uses non-preferred name type value if the value of the code for the name type begins with uppercase characters

Submitted by 334 on
Symptom
When adding a name with a name type where the code has mixed case characters, example STMail, the name for this respective type is used in the header name information instead of the existing preferred name.  All reports, exports and locations where default preferred name is used will display the incorrect name type.



Product Line
Millennium

DF-M23148-“Conversion from string “N” to type ‘Date’ is not valid” importing running import into pending tables

Submitted by 334 on
Symptom
“Conversion from string “N” to type ‘Date’ is not valid” importing running import into pending tables



The csv file contains relid, relkey and relnmy1 fields mapped to the Relation table


The identifier settings are as follows


The mapping is created for the two fields to the Relation table



After saving the mapping and we click File>Run import to pending tables, the error occurs.
“Conversion from string “N” to type ‘Date’ is not valid” 
Product Line
Millennium

DF-M23125-Error converting data type varchar to numeric when chart_nm12 is added to lookup tables for chart of accounts

Submitted by 334 on
Symptom
Error “Error converting data type varchar to numeric, Error code 8114” occurs when adding values to Tools>Profile Lookups>Lookup Tables>Chart of Accounts if field chart_nm12 is in Maintenance form in Display Design>Lookups>Chart of Accounts for Lookup Type Maintenance Form

Product Line
Millennium

Unable to copy Millennium user group or Millennium user

Submitted by 334 on
Symptom
When copying an existing Millennium group or user, the new group does not show up in groups nor user maintenance.
When you click copy, the system indicates copy is in progress but the copy is not successful.
This is occurring in version 2015.x-2016.1.2 of Millennium but fixed for 2016.1.3 with a new millsys.dll and millsys.pdb file.
Turning on a SQL Profiler Trace results in the following user error:  ​  Could not find stored procedure 'sp_addgroup' 
 
Product Line
Millennium