rsInvalidReportServerDatabase error after upgrade
We recently
upgraded a SQL Server 2014 database from Service Pack 1 to SP2.
The upgrade seemed to be successful. The status of all the features set-up were flagged accordingly.
I checked the error
logs and everything seemed fine.
However in the
Windows NT log there was an error which stated “The report server
database is an invalid version”.
When I then tried to
view the reports the following message was displayed:
The version of
the report server database is either in a format that is not valid,
or it cannot be read. The found version is '164'. The expected
version is '163'. (rsInvalidReportServerDatabase).
This is due to a
bug which was fixed in ‘Cumulative update 1 for SQL Server 2014
SP2’ (KB article number – 3212393 - FIX:
rsInvalidReportServerDatabase error after you upgrade).
To fix we applied
the latest Cumulative Update Package (which in this instance was
CU5).
This resolved the issue and reporting services now appear to be
running normally again.
Links: