Dynamics GP Upgrade from 2013R2 to GP 2016 R2: error – ASI_MSTR_EXPLORER_FAVORITES_COLUMNS

Table Name: ASI_MSTR_Explorer_Favorites_Columns

Product ID: 1493

Product Name: SmartList

Error Code: 245

Error: >245

During upgrade to Dynamics GP 2016 if you get this error do the following:

1   SELECT * FROM ASIEXP86 where isnumeric(ASI_Column_Display_Name) = 0     : If you have record

2   UPDATE ASIEXP86 SET ASI_Column_Display_Name = ASI_Field_Number where isnumeric(ASI_Column_Display_Name) = 0

Re-run upgrade again. Upgrade will run without.