Monday 10 July 2017

rsInvalidReportServerDatabase error after upgrade


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:

 







No comments:

Post a Comment