I can not advance to a new calendar year.

 Sage 50 2022.2, I have cleared all past years historical data, restored backup made in early Nov. (before installing 2022 upgrade) will advance to Jan. 1,2022 but backups made after 2022 upgrade will not.  Advance Database Check gives an error and the log says

" BEGIN: Verifying Historical data integrity **********
# HISTORICAL DATA PROBLEM: The historical set in the datadict table does not have the same number of historical years - tPySH tPyS1H tPyS2H
# HISTORICAL DATA PROBLEM: This historical table exists, but is missing an entry in the simplygrouppriv table - tpysh01 - PrlView
# HISTORICAL DATA PROBLEM: This historical table exists, but is missing an entry in the simplygrouppriv table - tpysh01 - PrlEdit
# HISTORICAL DATA PROBLEM: This historical table exists, but is missing an entry in the simplygrouppriv table - tpysh01 - SystemAdmin
# HISTORICAL DATA PROBLEM: This historical table exists, but is missing an entry in the simplygrouppriv table - tpys1h01 - PrlView
# HISTORICAL DATA PROBLEM: This historical table exists, but is missing an entry in the simplygrouppriv table - tpys1h01 - PrlEdit
# HISTORICAL DATA PROBLEM: This historical table exists, but is missing an entry in the simplygrouppriv table - tpys1h01 - SystemAdmin
# HISTORICAL DATA PROBLEM: The historical table entries in the datadict table are not sequential - tPyS2H
********** END: Verifying Historical data integrity ” 

Running Windows 10, 64 bit. Any suggestions?

  • Hi, the database log suggests your historical tables are not align, if backups between Nov and Feb gives the same error and you would like to keep your work, best contact Sage 50 CA support 1 888 522 2722.