I've been trying to help a friend who uses Sage and I have hit a wall -- trying to contact Sage support has been very frustrating and futile so I'm turning to the community in hopes that someone here can help me.
When you try to close out the year it asks you to make a backup which is not a problem. After that I presume that Sage is moving the 2017 and that fails with the following error:
An error has occurred while moving current year to last year. As a result, the new fiscal year could not start. Please restore from backup or run Advanced Database Check
Attempting to run Advanced Database Check leads to a popup saying that the database could not be repaired and to call a 1-800 number which was impossible to get through to anyone on. When I finally did they offered to e-mail some suggestions but sent me an e-mail that mentioned the forums but was otherwise blank.
Eventually, I found the Dbverifier log -- all the verifications Begin and End with no issues except got Historical Date -- Historical Data has the following errors:
# HISTORICAL DATA PROBLEM: This historical table exists, but is missing an entry in the simplygrouppriv table - tpysh02 - PrlView
# HISTORICAL DATA PROBLEM: This historical table exists, but is missing an entry in the simplygrouppriv table - tpysh02 - PrlEdit
# HISTORICAL DATA PROBLEM: This historical table exists, but is missing an entry in the simplygrouppriv table - tpysh02 - SystemAdmin
# HISTORICAL DATA PROBLEM: This historical table exists, but is missing an entry in the simplygrouppriv table - tpys1h02 - PrlView
# HISTORICAL DATA PROBLEM: This historical table exists, but is missing an entry in the simplygrouppriv table - tpys1h02 - PrlEdit
# HISTORICAL DATA PROBLEM: This historical table exists, but is missing an entry in the simplygrouppriv table - tpys1h02 - SystemAdmin
# HISTORICAL DATA PROBLEM: This historical table exists, but is missing an entry in the simplygrouppriv table - tpys2h02 - PrlView
# HISTORICAL DATA PROBLEM: This historical table exists, but is missing an entry in the simplygrouppriv table - tpys2h02 - PrlEdit
# HISTORICAL DATA PROBLEM: This historical table exists, but is missing an entry in the simplygrouppriv table - tpys2h02 - SystemAdmin
# 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: This historical table exists, but is missing an entry in the simplygrouppriv table - tjeh01 - GLEdit
# HISTORICAL DATA PROBLEM: This historical table exists, but is missing an entry in the simplygrouppriv table - tjeh01 - APEdit
# HISTORICAL DATA PROBLEM: This historical table exists, but is missing an entry in the simplygrouppriv table - tjeh01 - AREdit
# HISTORICAL DATA PROBLEM: This historical table exists, but is missing an entry in the simplygrouppriv table - tjeh01 - PrlEdit
# HISTORICAL DATA PROBLEM: This historical table exists, but is missing an entry in the simplygrouppriv table - tjeh01 - InvEdit
# HISTORICAL DATA PROBLEM: This historical table exists, but is missing an entry in the simplygrouppriv table - tjeh01 - Common
# HISTORICAL DATA PROBLEM: This historical table exists, but is missing an entry in the simplygrouppriv table - tjeh01 - SystemAdmin
# HISTORICAL DATA PROBLEM: This historical table exists, but tCompOth.nActHistSt is 0 - tJEH01
After doing some Googling I discovered some people with similar problems had solved them by clearing Historical Data. I made a copy of the Sage data and using that copy tried to clear financial history and the result was a popup saying that there is no financial history to clear.
I also attempted to run the Advanced Database Check from outside of Sage -- strangely when I attempt that I am asked for the sysadmin password and despite entering the correct password I keep getting told it is incorrect. This is not a typo -- I have done it a dozen times and can log into Sage with those credentials but the very same credentials do not work for Advanced Database Check run without starting Sage.
I also attempted to export all the records and then start a new company and import them. While that did create a company that had all the customers, vendors, accounts, etc -- the values in all the accounts were zero
So basically it appears that while Sage has been working fine (or at least appears so) there is a problem with the data integrity and the end of year procedure runs a check that is strict enough to fail because of this problem.
I was able to update to version 2018.0 and then to 2018.1 -- in both cases, it modified the database which I thought might fix the problem but in the end, did not.
So what are my options?
Is there a way to run the year-end close while disabling the data check?
Is there a way to dump all the data into something that could then be imported into a new company with everything intact?
Can I manually edit the database and fix or delete the errors?
As far as I can tell there doesn't appear to be any backups. I found a couple but they were all created when they attempted to do the year-end close and I don't think they were doing backups so unless Sage has automatic backups to some non-obvious location simply restoring from backup is not an option.
