Forum Discussion
ReportServerTempDB.dbo.ContentCache
We upgraded our existing SSRS to PBIX by restoring our 2014 ReportServer and ReportServerTempDB on the new SQL 2017 instance and then installed Power BI server and shut down the SSRS server. Al the r...
It is the procedure 'CleanExpiredContentCache that is failing.
DELETE
FROM
[ReportServerTempDB].dbo.[ContentCache]
WHERE
ExpirationDate < @now
Appearently when you just restore an SSRS DB to 2017 and then point Power BI server to it, it doesn't do any house keeping.
I did a schema compare to a clean Power BI server install and found two descrepancies. One being this table was missing and the other was just an index on rge ExecutionCahce table. I made the changes and we'll see if I just brought doen Power BI.