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?

Parents
  • 0

    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!

  • 0 in reply to Agate

    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."

  • 0 in reply to LH-HMMI

    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?

Reply Children
  • 0 in reply to Richard S. Ridings

    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 **********

  • 0 in reply to Richard S. Ridings

    The log shows that there is a problem with the historical Data. At the begin of 2017 Sage corrected a date issue with this file. I assume whatever they did created this issue. 

  • 0 in reply to LH-HMMI

    I don't know what might have been done to the file when it was corrected.  I might be able to correct it as I am one of those 3rd party services Agate mentioned.  I can correct some problems within the file but I can't guarantee I can correct all problems.  I do know that you will likely not be able to correct it with Sage 50 itself.

    Are you able to run reports on years prior to 2017?  Or were they removed from the file when Sage repaired it before?

    If you want, I can take a look at your file and see if I can correct it.  You can reach me through the email address in my profile.

  • 0 in reply to LH-HMMI

    I didn't see the log file post before I sent my last message.  I'd have to see your file to know exactly what needs to be done to do the repair but I should be able to get it to a point where you can upgrade.  I can also test the upgrades here on a copy of your file to make sure.

    If you want me to take a look, contact me through the email address in my profile.