Unable to update 2017 file into 2021.

I have a company file that was worked on by Sage in 2017 and I have not been able to update into the new programs. As a work around I have been using it in 2017 version, however I have upgraded my computer and no longer have the 2017 so I need it fixed. I call Sage only to be told there is no one available and to visit Sage City for assist or try again later.

When I open the program in the 2018,2019,2020 or 2021 version. It starts the update, then at about 80% shows an error message saying "Unable to open company.

Anyone have an idea how I can get this resolved?

  • Hi LH-HMMI:

    Your data may be damaged or corrupted and that may be the reason it cannot be upgraded. If this is the case your data may have to be repaired. There was some issues with the 2017 version. Do you recall which version you were using? Are you unable to use the 2017 data with the 2017 version of Sage 50? If you can use the 2017 version, try the Advanced Database Check option under Maintenance to see if this may correct your data so you can upgrade to whichever version you want. Let us know whether the database check works or not!

    Hope this helps somewhat!

  • Yes the file will work in 2017. We tried the Advanced Database Check and recieve an error "The Sage 50 database verification tool has found a problem in your company file that it was unable to fix."

  • There should be a related *.log file in the following folder.

    C:\Users\YourWindowsUsername\Documents\Simply\DbVerifier\Logs

    What does it indicate about the problem?

  • Hi LH-HMMI:

    It appears you will need a data repair. Sage has 2 data repair services. One can be done for $250.00 plus taxes and it is usually repaired in a week's time. The second costs $500.00 plus taxes and it is done in less than a week. There are also 3rd party repair services charging anywhere from $400.00 and upwards with a fairly fast turnaround time.

  • Here is the error in the log

    "HISTORICAL DATA PROBLEM: The historical set in the datadict table does not have the same number of historical years - tGMscH tJEAH tJEH tJEPH tJEPHH tJETH
    # HISTORICAL DATA PROBLEM: The historical table entries in the datadict table are not sequential - tJEAH
    # HISTORICAL DATA PROBLEM: The historical table entries in the datadict table are not sequential - tJEH
    # HISTORICAL DATA PROBLEM: This historical table exists, but tCompOth.nActHistSt is 3 - tJEH08
    # HISTORICAL DATA PROBLEM: The number of entries in the simplygrouppriv table do not match tCompOth.nActHistSt or there are entries for that table that exceed tCompOth.nActHistSt - tGMscH
    # HISTORICAL DATA PROBLEM: The number of entries in the simplygrouppriv table do not match tCompOth.nActHistSt or there are entries for that table that exceed tCompOth.nActHistSt - tJEAH
    # HISTORICAL DATA PROBLEM: The number of entries in the simplygrouppriv table do not match tCompOth.nActHistSt or there are entries for that table that exceed tCompOth.nActHistSt - tJEH
    # HISTORICAL DATA PROBLEM: The number of entries in the simplygrouppriv table do not match tCompOth.nActHistSt or there are entries for that table that exceed tCompOth.nActHistSt - tJEPH
    # HISTORICAL DATA PROBLEM: The number of entries in the simplygrouppriv table do not match tCompOth.nActHistSt or there are entries for that table that exceed tCompOth.nActHistSt - tJEPHH
    # HISTORICAL DATA PROBLEM: The number of entries in the simplygrouppriv table do not match tCompOth.nActHistSt or there are entries for that table that exceed tCompOth.nActHistSt - tJETH
    ********** END: Verifying Historical data integrity **********