I've just come across this error, but it has nothing to do with trying to bring in a company code from another installation. My case is an actual upgrade, where the system files and data have been migrated from 2017 Advanced to 2020 Advanced. The error occurs when trying to print or preview any reports. Has anyone else had this happen?
I've checked the company code AES encryption keys in both versions and they're all identical. The only company that isn't in the 2017 version is the PMZ demo data company for production management.
I've had good assistance from Sage support, but our efforts have been in vain. There are some enhancements installed, not just production management. The recommendation now is to uninstall and try again, taking time after each enhancement installation to ensure that the error doesn't pop up.
------------------------------
John Kerr
Net at Work
------------------------------
Original Message:
Sent: 06-24-2020 13:30
From: Doug Higgs
Subject: The Encryption Key is Invalid
Can you please clarify "grab the encryption key from a good company in and paste it into the AES encryption field of the new company." ? What is a good company? One of the companies in the destination Sage 100 installation? Aren't the encryption keys different for each company code?
------------------------------
Doug Higgs
Midwest Commerce Solutions, Inc
(312) 315-0960
Assistant to the Traveling Secretary
------------------------------
Original Message:
Sent: 06-24-2020 13:21
From: Wayne Schulz
Subject: The Encryption Key is Invalid
Let me save you a click
Applies to Sage 100 2018+ ( 6.00) when you attempt to copy the MAS_XXX folder during a re-migration and conversion.
The issue is that MAS_SYSTEM has an AES key field ( per company ) which helps ensure data cannot simply copy.
Here's the workaround:
Using DFDM, go into sy_company, find the AES Encryption key for one of the current companies in the destination system. I never bother with the "Change encryption keys" program, I just
- create the new company in the destination system,
- copy in the data, then
- grab the encryption key from a good company in and paste it into the AES encryption field of the new company. Comes right up.
For version 610 ( 2019 ) (and maybe 600 - 2018 ), you will also need to go into the G/L options for a known good company and do the same for data encryption test. That handles the PII stuff. I think Payroll is like G/L, but I haven't fiddled with it.
------------------------------
Wayne Schulz - Schulz Consulting - 860-516-8990