Sage 100

 View Only

  • 1.  Data Dictionary issues with system files

    Posted 03-25-2025 11:00

    I have a client experiencing major GL issues in Sage 2019 Premium.  In setting up a testing install, we found corruption in the data dictionaries  The struggle right now is to get the system files corrected which is more compilated in Premium.  In the restore of the MAS_System database, the SY_Company table is blank.  Tried using a flat file import in SQL,  but it did not work because the fields do not line up the same way. In manually populating the data in SQL (to get past the errors when trying to check that the data shows as converted) we found that in the UI, the data is not in the "right place - the version level showed in the domain field on the email tab,  Also the eInvoice Payments is not in the right place so it was really difficult to get past the messages on required field setting.    I am familiar with the Activate command but there does not seem to be a way to do it for the system files.   In the SY_module, it is listed as SYS (compared to A/P).  Tried with both SYS and S/Y but returned 0.   The command refers to a company code so my gut tells me it won't work.  Talked to Dan at Sage and he was not sure either.   I believe that you can reset the dictionary for a file using DD but I am not exactly sure how.   Does anyone know?   Once we get the system files corrected so we can reliably access the companies in the test install we want to make sure we can duplicate the issues, I will try updating the dictionaries for GL.  



    ------------------------------
    Bob Osborn
    Senior Consultant
    DSD
    7142645278
    ------------------------------


  • 2.  RE: Data Dictionary issues with system files

    Posted 03-25-2025 11:07

    For SY_Company you can just re-create the company codes in the admin console, and Sage will find the company databases.  You'll lose the company key link (user permissions, paperless history...) but for testing I am assuming that isn't a problem.



    ------------------------------
    Kevin Moyes
    Technical Systems Analyst
    Munjal White Consulting Co.
    Toronto ON
    ------------------------------



  • 3.  RE: Data Dictionary issues with system files

    Posted 03-25-2025 13:59

    Hi @Kevin Moyes  We were able to get them created by restoring the MAS_System DB, which had a couple of the sample companies.  Copied the data down from them to the customer company codes for all columns.  However there is still a mismatch between what the columns are in SQL and in DFDM.   But it is working somewhat.   Now we are getting an error about the encryption keys when trying to run GL reports. Confirmed they are right.  Tested in sample companies & can run the reports.  Copied the keys from the sample companies to the live companies in SY_Company and GL_Options but the error persists.  Running the reports is what we need to test as that is were the reported problems are..

     



    ------------------------------
    Bob Osborn
    Senior Consultant
    DSD
    7142645278
    ------------------------------

    Original Message


  • 4.  RE: Data Dictionary issues with system files

    Posted 03-25-2025 18:00

    Sage DFDM doesn't read the SQL data properly?  Wow, that is odd.

    I don't know enough about the encryption keys to comment further about that.

    My inclination, if this is just a test environment, would be to do a fresh install, then migrate from the source system again.  (Taking backups of MAS_System and \MAS90\ along the way of course).



    ------------------------------
    Kevin Moyes
    Technical Systems Analyst
    Munjal White Consulting Co.
    Toronto ON
    ------------------------------

    Original Message


  • 5.  RE: Data Dictionary issues with system files

    Posted 03-26-2025 08:00

    Do the new copied-down CompanyKeys match the old CompanyKeys?  Do Entry screens work but just not reports?



    ------------------------------
    Steve Iwanowski, NextStep Technology Advisors, aka DSD Lancaster PA ¯\_(ツ)_/¯
    ------------------------------

    Original Message


  • 6.  RE: Data Dictionary issues with system files

    Posted 03-27-2025 19:36

    So to wrap up this saga, someone reinstalled Sage to the testing server and restored the databases & the MAS90 folder.  Had to move over the _appserv folder & update the permissions on the databases to get it functioning  At which point I saw exactly the same thing that I had originally seen - an empty SY_company table.  Before the reinstall was done,  we had gotten the company codes created by using the "clean install" MAS_System database which had the sample company records. Only issue was the encryption key error.   Managed to find & restore the MAS_System database.  Was back to having the sample companies.  Recreated the actual companies by making sure each column was populated with "appropriate" data.  Was able to get into the companies but was back to the AES Encryption message when running reports.    @Alnoor Cassim advised to the GL_Options AESDataEncryptionTest. data from the test company to the GL_Options in the "live" company.  Nothing is needed it the SY_company table.    
       Got all that done and then when to show the developer the issue in the live company for reference and it works fine now (GL Detail report omitted accounts in a selected range even though there were transactions) ..  Seems all the companies GLs now show in balance..    Only thing the client did was a single one sided JE dated in 2011.  It remains a complete mystery.    But I think that this has convinced them they need to upgrade..  



    ------------------------------
    Bob Osborn
    Senior Consultant
    DSD
    7142645278
    ------------------------------

    Original Message


Related Content