Sage 100

 View Only
Expand all | Collapse all

The Encryption Key is Invalid

  • 1.  The Encryption Key is Invalid

    Posted 06-23-2020 09:26
    Has anyone found a work-around for this message to allow moving company data from another 2018+ system?  It makes grabbing data from a client system and dropping it on one of our test systems a giant PITA.....

    ------------------------------
    Bernie Lehman
    Lehman Wesley & Associates
    ------------------------------


  • 2.  RE: The Encryption Key is Invalid

    Posted 06-23-2020 19:13
    Hi, Bernie. It's a huge PITA. The only thing that I've been able to do is to grab the customer's company data folder and also their MAS_System folder. When I want to work with that customer's data, I swap the MAS_System folder in my installation for their MAS_System folder and then launch Sage. It takes extra time. And this doesn't always work if there are differences between my installation and theirs. I'm sure that you already know all of this, but thought that you might like to know that you're not alone.

    ------------------------------
    Karen O'Lane
    Accounting Systems, Inc. (ASI)
    Fresno CA
    803.252.6154 x242
    559.577.4142
    90 Minds Treasurer
    ------------------------------



  • 3.  RE: The Encryption Key is Invalid

    Posted 06-23-2020 19:22
    It would have been painful 10 years ago when I would grab YE PR to run YE reports from my system while they moved on to the next year's PR processing.  Not so much any more as I have remote access to the client's installation.  But I did get bit last September doing a go live in v2019.  Somehow the GL history got mucked up so I tried to restore a v2018 GL folder to v2019.  Encryption key wouldn't let me move forward.  Tech support said sorry, not able to restore a 2018 folder to 2019 install.

    ------------------------------
    Jeff Schwenk
    FORMER 90M Board Member
    Bottomline Software, Inc.
    Waynesboro VA
    540-221-4444
    ------------------------------



  • 4.  RE: The Encryption Key is Invalid

    Posted 06-24-2020 12:09
    Edited by Robert Wood 07-20-2022 14:48
    Try this:

    https://community.90minds.com/communities/community-home/digestviewer/viewthread?MessageKey=0b8feb79-e6a0-4c9b-bba9-221960528113&CommunityKey=4593d843-4557-43ff-ba4d-6240681ed696&tab=digestviewer#bm0b8feb79-e6a0-4c9b-bba9-221960528113


    ------------------------------
    Eric Lunceford
    First Mate Business Solutions
    Oklahoma City, OK
    877-880-8960
    https://www.firstmatellc.com/
    ------------------------------



  • 5.  RE: The Encryption Key is Invalid

    Posted 06-24-2020 12:57
    Remote access definitely helps.  In the situation where I really need to have it on my own system I download the client's entire MAS90 folder and put it on my system in an alternate directory and launch it manually from pvxwin32.exe in the home folder.   It's a pain because it takes a while to download, but it works.

    ------------------------------
    Thomas Rogers (TomTarget)
    Target System Technology, Inc.
    Spokane Valley WA
    ------------------------------



  • 6.  RE: The Encryption Key is Invalid

    Posted 06-24-2020 13:01
    Nice.

    Thanks for the reference Eric.

    ------------------------------
    Thomas Rogers (TomTarget)
    Target System Technology, Inc.
    Spokane Valley WA
    ------------------------------



  • 7.  RE: The Encryption Key is Invalid

    Posted 06-24-2020 13:22
    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 

    1. create the new company in the destination system, 
    2. copy in the data, then 
    3. 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
    ------------------------------



  • 8.  RE: The Encryption Key is Invalid

    Posted 06-24-2020 13:31
    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
    ------------------------------



  • 9.  RE: The Encryption Key is Invalid

    Posted 06-24-2020 13:52
    I think it means go to the 2018 version and copy the AES key specific to the company code and paste it into the same field but in 2019 after you've copied data

    ------------------------------
    Wayne Schulz - Schulz Consulting - 860-516-8990
    ------------------------------



  • 10.  RE: The Encryption Key is Invalid

    Posted 06-24-2020 14:01
    Got it.  Thanks Wayne.

    ------------------------------
    Doug Higgs
    Midwest Commerce Solutions, Inc
    (312) 315-0960
    Assistant to the Traveling Secretary
    ------------------------------



  • 11.  RE: The Encryption Key is Invalid

    Posted 12-01-2020 21:56
    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
    ------------------------------