I encountered this as well and although the field order was changed in 2020, compared to my 2018 and 2019 installs, what i found was the actual cause of the error was that providex.dde was missing the blank record for the table, 000349 was the key.
This is the same cause of the error 65 when trying to source a UDF in AR_InvoiceHistoryHeader when trying to select either the SO_SalesOrderJournal_upd or the other AR one and it was caused by the missing blank record for the AR_TransactionPosting table, 000597 was the key.
My observation was that anytime an object attempted to use the the SY_File object's GetColumnInfo method to get a property like Length without first checking if a valid object was returned would cause the error 65 and GetColumnInfo will fail to return a valid object when the blank record is missing in providex.dde.
I wrote a utility that compared physical tables in providex.ddf and looked for missing blank records in providex.dde with the option to write the records and on my vanilla install of 2018 and 2019, I was missing a number of tables so I reached out to sage to confirm that all physical tables should have a matching blank record and they said they shouldn't, which makes me second guess their answer so I said I would just use this method for tables that actually produce an error 65.
To date, I'm only aware of AR_TransactionPosting and CM_UDFMaintenanceListingWrk causing the error.
I haven't confirmed it but it sounds like reordering the fields is writing the required blank record to providex.dde because just clicking the update button without making any changes did not write the blank record.
------------------------------
David Speck II
Tennessee Software Solutions
------------------------------
Original Message:
Sent: 08-02-2021 11:06
From: Mary Mays
Subject: v2020 ADV error 65
I argued with Sage about this because I had 2 separate upgrades going - one standard and one advanced with the same message... AND I was luck to have no mods or 3rd party programs installed - very vanilla installs. Support came back with this fix
I called Sage and there is a fix for this - has nothing to do with enhancements or patch level. I've fixed a couple of installs using this.
1. Make a backup of MAS90 folder (I just backed up the CM_UDFMaintenanceListing.wrk file in MAS_System)
2. Log into Sage 100
3. Select File, Run from toolbar
4. Type: SYZCON
5. Click OK
6. Type: DD
7. Press Enter
8. Click on binoculars icon on Table name field
9. Expand C/M and double-click 'CM_UDFMaintenanceListingWrk'
10. Click on 'Data Elements' tab
11. Move 'Sort Field' to top of list
12. Click 'Exit' in lower right corner
13. Type: BYE
14. Try printing UDF List
it was supposed to get written up on the Sage KB
------------------------------
Mary Mays
Sr. Consultant, DSD Business Systems
DSD Business Systems
Goddard KS
316-269-4264
------------------------------
Original Message:
Sent: 08-02-2021 08:54
From: Doug Higgs
Subject: v2020 ADV error 65
I believe the attached kb is the resolution to @Jeff Schwenk 's original post. Looks like corrupt data dictionary.
------------------------------
Doug Higgs
Midwest Commerce Solutions, Inc
(312) 315-0960
Chauffeur, Chef, and Personal Assistant to Sprinkles