Clear SSRS cache with SQL code

Question

To solve this problem - SSRS shows wrong form I tried to clear the SSRS cache. One post suggested that I use SQL to do so - http://social.msdn.microsoft.com/Forums/sqlserver/en-US/58caa380-ece8-4507-9ff3-684c93685e72/how-to-clear-a-report-cache-in-ssrs-2008?forum=sqlreportingservices

The code -

Use ReportServer
EXEC FlushReportFromCache @Path
EXEC CleanExpiredCache

@Path you need to give path for report for which you need to clear cache.

Which path do I enter here ? I entered the folder which contains all my rdlc files and the sql gave me 0 rows returned. I am doing simple beginner exercises on a local system.

M.Ali M.Ali · Accepted Answer · 2014-04-06T19:36:26

This is the Path to your report that you want to clear from your cache. you can get this by querying the dbo.Catalog table in your ReportServer database something as follows:

USE ReportServer;
GO

SELECT  Name     --<-- Report Name
      ,[Path]    --<-- Report Path
FROM [dbo].[Catalog] 

GO

Clear SSRS cache with SQL code

1 Answers