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

Submitted by 334 on Fri, 12/15/2017 - 10:44
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

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 Tue, 12/12/2017 - 10:05
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

Unable to copy Millennium user group or Millennium user

Submitted by 334 on Tue, 12/05/2017 - 08:13
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