SSRS-error about report server database version after hotfixing SQL. The found version is '164'. The expected version is '163'

Question

After applying hotfix KB3194725 to our SQL server, the SSRS server throws the following exception when trying to generate a report:

Exception type: InvalidReportServerDatabaseException

Exception message: 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'.

score 1 · Answer 1 · answered Jan 23 '18 at 18:04

1

Based on the version that you got which is 163, try to apply this query on the

instance hosting your reporter server database.

In my below example, the database is named ReportServer :

USE [ReportServer]

DELETE FROM ServerUpgradeHistory WHERE ServerVersion > 163

answered Jan 23 '18 at 18:04

Scorpion99

111
3

I tried this, and the error has changed and now shows as "ReportServerException: Specified cast is not valid." Any recommendations? – James Lee Nov 13 '21 at 06:01

score 0 · Accepted Answer · answered Nov 21 '16 at 09:01

0

This can be fixed by applying the same hotfix to the SSRS-server.

answered Nov 21 '16 at 09:01

Henrik H

111
1
4

SSRS-error about report server database version after hotfixing SQL. The found version is '164'. The expected version is '163'

2 Answers2