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 reports run just fine but my log file is filled with this error:
library!WindowsService_0!8b00!07/16/2018-16:51:19:: i INFO: Call to CleanBatch() library!WindowsService_0!8b00!07/16/2018-16:51:19:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerStorageException: , An error occurred within the report server database. This may be due to a connection failure, timeout or low disk condition within the database.; dbcleanup!WindowsService_0!8b00!07/16/2018-16:51:19:: e ERROR: Error in CleanExpiredContentCache: Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerStorageException: An error occurred within the report server database. This may be due to a connection failure, timeout or low disk condition within the database. ---> System.Data.SqlClient.SqlException: Invalid object name 'ReportServerTempDB.dbo.ContentCache'.
Any searches on 'ReportServerTempDB.dbo.ContentCache' just bring back posts related to Novell
I don't see anything named ContentCache in either database, nor do I see anything name CleanBatch.
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.