cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
mikegrove Frequent Visitor
Frequent Visitor

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 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.

Any sugesstions would be wonderful.

4 REPLIES 4
mikegrove Frequent Visitor
Frequent Visitor

Re: ReportServerTempDB.dbo.ContentCache

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.

lynamc Frequent Visitor
Frequent Visitor

Re: ReportServerTempDB.dbo.ContentCache

USE [ReportServerTempDB]
GO
/****** Object: Table [dbo].[ContentCache] Script Date: 21/05/2019 12:07:50 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[ContentCache](
[ContentCacheID] [bigint] IDENTITY(1,1) NOT NULL,
[CatalogItemID] [uniqueidentifier] NOT NULL,
[CreatedDate] [datetime] NOT NULL,
[ParamsHash] [int] NULL,
[EffectiveParams] [nvarchar](max) NULL,
[ContentType] [nvarchar](256) NULL,
[ExpirationDate] [datetime] NOT NULL,
[Version] [smallint] NULL,
[Content] [varbinary](max) NULL,
CONSTRAINT [PK_ContentCache] PRIMARY KEY NONCLUSTERED
(
[ContentCacheID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO


USE [ReportServerTempDB]
GO

/****** Object: Index [IX_ExecutionCacheLastUsed] Script Date: 21/05/2019 12:09:14 ******/
CREATE NONCLUSTERED INDEX [IX_ExecutionCacheLastUsed] ON [dbo].[ExecutionCache]
(
[ReportID] ASC,
[AbsoluteExpiration] ASC,
[LastUsedTime] ASC,
[ExecutionCacheID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO

 

lynamc Frequent Visitor
Frequent Visitor

Re: ReportServerTempDB.dbo.ContentCache

CREATE NONCLUSTERED INDEX [IX_ContentCache] ON [dbo].[ContentCache]
(
[CatalogItemID] ASC,
[ParamsHash] ASC,
[ContentType] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO

CREATE NONCLUSTERED INDEX [IX_ContentCache_ExpirationDate] ON [dbo].[ContentCache]
(
[ExpirationDate] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO

 

Super User
Super User

Re: ReportServerTempDB.dbo.ContentCache

I don't think Microsoft actually support an inplace upgrade of SSRS to PBI Report Server see here https://docs.microsoft.com/en-us/power-bi/report-server/migrate-report-server

 

The documentation talks about cloning the ReportServer database, but I think you are meant to let the PBI Report Server config manager create a new ReportServerTempDB database. 

Helpful resources

Announcements
Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Summit North America

Power Platform Summit North America

Register by September 5 to save $200

PBI Community Highlights

PBI Community Highlights

Check out what's new in the Power BI Community!

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Users Online
Currently online: 96 members 1,594 guests
Please welcome our newest community members: