Hello,
I have been using Sage 2014.3 since well, 2014. Have had the odd issue here and there but never did. Tried to start a new fiscal year, was told it can't go forward because of a database error. I did the advanced database verification and was told an error was found but that it couldn't fix it.
I opened the log and found this :
# 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 - tgmsch01 - GLEdit
# HISTORICAL DATA PROBLEM: This historical table exists, but is missing an entry in the simplygrouppriv table - tgmsch01 - APEdit
# HISTORICAL DATA PROBLEM: This historical table exists, but is missing an entry in the simplygrouppriv table - tgmsch01 - AREdit
# HISTORICAL DATA PROBLEM: This historical table exists, but is missing an entry in the simplygrouppriv table - tgmsch01 - PrlEdit
# HISTORICAL DATA PROBLEM: This historical table exists, but is missing an entry in the simplygrouppriv table - tgmsch01 - InvEdit
# HISTORICAL DATA PROBLEM: This historical table exists, but is missing an entry in the simplygrouppriv table - tgmsch01 - Common
# HISTORICAL DATA PROBLEM: This historical table exists, but is missing an entry in the simplygrouppriv table - tgmsch01 - SystemAdmin
# HISTORICAL DATA PROBLEM: This historical table exists, but is missing an entry in the simplygrouppriv table - tjeah01 - GLEdit
# HISTORICAL DATA PROBLEM: This historical table exists, but is missing an entry in the simplygrouppriv table - tjeah01 - APEdit
# HISTORICAL DATA PROBLEM: This historical table exists, but is missing an entry in the simplygrouppriv table - tjeah01 - AREdit
# HISTORICAL DATA PROBLEM: This historical table exists, but is missing an entry in the simplygrouppriv table - tjeah01 - PrlEdit
# HISTORICAL DATA PROBLEM: This historical table exists, but is missing an entry in the simplygrouppriv table - tjeah01 - InvEdit
# HISTORICAL DATA PROBLEM: This historical table exists, but is missing an entry in the simplygrouppriv table - tjeah01 - Common
# HISTORICAL DATA PROBLEM: This historical table exists, but is missing an entry in the simplygrouppriv table - tjeah01 - SystemAdmin
# 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
Unable to convert MySQL date/time value to System.DateTime
I will preface by saying that my datafiles are located on a Dropbox, which after doing some reading on this forum, is not the best idea. I have been doing that since 2014 and have never had an issue until now. That being said, I will not do this going forward, but still need to figure out how to repair my data file.
Anything I can do? I have tried opening a few older backups, to no avail. Not sure how far back I would have to go - can't imagine having to redo the whole year...
Thank you!
