I am using SQL Server 2008 R2 Standard Edition. I recently upgraded from SQL Server 2008. When I try to create a Cache Refresh Plan for a shared dataset, I get the following error: <ErrorCode xmlns="http://www.microsoft.com/sql/reportingservices">rsUnknownEventType</ErrorCode> <HttpStatus xmlns="http://www.microsoft.com/sql/reportingservices">400</HttpStatus> <Message xmlns="http://www.microsoft.com/sql/reportingservices">An attempt has been made to use event type 'RefreshCache' that is not registered with this report server for external use.</Message> <HelpLink xmlns="http://www.microsoft.com/sql/reportingservices">http://go.microsoft.com/fwlink/?LinkId=20476&amp;EvtSrc=Microsoft.ReportingServices.Diagnostics.Utilities.ErrorStrings&amp;EvtID=rsUnknownEventType&amp;ProdName=Microsoft%20SQL%20Server%20Reporting%20Services&amp;ProdVer=10.50.1600.1</HelpLink> <ProductName xmlns="http://www.microsoft.com/sql/reportingservices">Microsoft SQL Server Reporting Services</ProductName> <ProductVersion xmlns="http://www.microsoft.com/sql/reportingservices">10.50.1600.1</ProductVersion> <ProductLocaleId xmlns="http://www.microsoft.com/sql/reportingservices">127</ProductLocaleId> <OperatingSystem xmlns="http://www.microsoft.com/sql/reportingservices">OsIndependent</OperatingSystem> <CountryLocaleId xmlns="http://www.microsoft.com/sql/reportingservices">1033</CountryLocaleId> <MoreInformation xmlns="http://www.microsoft.com/sql/reportingservices"><Source>ReportingServicesLibrary</Source> <Message msrs:ErrorCode="rsUnknownEventType" msrs:HelpLink="http://go.microsoft.com/fwlink/?LinkId=20476&amp;EvtSrc=Microsoft.ReportingServices.Diagnostics.Utilities.ErrorStrings&amp;EvtID=rsUnknownEventType&amp;ProdName=Microsoft%20SQL%20Server%20Reporting%20Services&amp;ProdVer=10.50.1600.1" xmlns:msrs="http://www.microsoft.com/sql/reportingservices">An attempt has been made to use event type 'RefreshCache' that is not registered with this report server for external use.</Message> </MoreInformation> <Warnings xmlns="http://www.microsoft.com/sql/reportingservices" /> I get this error if I try to create a Cache Refresh Plan through SQL Server Management Studio, or if I run the following code below. FiscalYearList is a Shared Dataset. The MatchData GUID points to an existing schedule. Public Class CachePlanHelper Public Shared Sub CreateCachePlan() Dim rs As New ReportingService2010() Dim ItemPath As String Dim Description As String Dim EventType As String Dim MatchData As String Dim parameters() As ParameterValue rs.Credentials = _ System.Net.CredentialCache.DefaultCredentials ItemPath = "/OIC/FiscalYearList" Description = "Cache Plan for FiscalYearList Shared Dataset" EventType = "RefreshCache" MatchData = "21146852-99DF-4623-8E2E-7D997BFD4899" parameters = Nothing Try rs.CreateCacheRefreshPlan(ItemPath:=ItemPath, _ Description:=Description, _ EventType:=EventType, _ MatchData:=MatchData, _ Parameters:=Parameters) Catch e As SoapException Console.WriteLine(e.Detail.InnerXml.ToString()) End Try End Sub Below is the EventProcessing section of the server’s rsreportserver.config: <EventProcessing> <Extension Name="SnapShot Extension" Type="Microsoft.ReportingServices.Library.HistorySnapShotCreatedHandler,ReportingServicesLibrary"> <Event> <Type>ReportHistorySnapshotCreated</Type> </Event> </Extension> <Extension Name="Timed Subscription Extension" Type="Microsoft.ReportingServices.Library.TimedSubscriptionHandler,ReportingServicesLibrary"> <Event> <Type>TimedSubscription</Type> </Event> </Extension> <Extension Name="Cache Update Extension" Type="Microsoft.ReportingServices.Library.ReportExecutionSnapshotUpdateEventHandler,ReportingServicesLibrary"> <Event> <Type>SnapshotUpdated</Type> </Event> </Extension> </EventProcessing>

Hi Daniel, From the error message, the issue seems to be caused by the "RefreshCache" is missing. Also, from the following configuration you posted, the "RefreshCache" is exact missing. <EventProcessing> <Extension Name="SnapShot Extension" Type="Microsoft.ReportingServices.Library.HistorySnapShotCreatedHandler,ReportingServicesLibrary"> <Event> <Type>ReportHistorySnapshotCreated</Type> </Event> </Extension> <Extension Name="Timed Subscription Extension" Type="Microsoft.ReportingServices.Library.TimedSubscriptionHandler,ReportingServicesLibrary"> <Event> <Type>TimedSubscription</Type> </Event> </Extension> <Extension Name="Cache Update Extension" Type="Microsoft.ReportingServices.Library.ReportExecutionSnapshotUpdateEventHandler,ReportingServicesLibrary"> <Event> <Type>SnapshotUpdated</Type> </Event> </Extension> </EventProcessing> To fix the issue, please add the "RefreshCache" event type to the Report Server(adding to rsreportserver.config) manually. <EventProcessing> <Extension Name="SnapShot Extension" Type="Microsoft.ReportingServices.Library.HistorySnapShotCreatedHandler,ReportingServicesLibrary"> <Event> <Type>ReportHistorySnapshotCreated</Type> </Event> </Extension> <Extension Name="Timed Subscription Extension" Type="Microsoft.ReportingServices.Library.TimedSubscriptionHandler,ReportingServicesLibrary"> <Event> <Type>TimedSubscription</Type> </Event> </Extension> <Extension Name="Cache Refresh Plan Extension" Type="Microsoft.ReportingServices.Library.CacheRefreshPlanHandler,ReportingServicesLibrary"> <Event> <Type>RefreshCache</Type> </Event> </Extension> <Extension Name="Cache Update Extension" Type="Microsoft.ReportingServices.Library.ReportExecutionSnapshotUpdateEventHandler,ReportingServicesLibrary"> <Event> <Type>SnapshotUpdated</Type> </Event> </Extension> </EventProcessing> If you have any more questions, please feel free to ask. Thanks, Jin ChenJin Chen - MSFT

Thanks, Jin, that solved it!!! I think Microsoft might have a problem. When I searched the internet for rsreportserver.config, I found three or four examples, but as far as I could tell, none of them had the event that you specified.

Thanks for the info Jin, I struck this issue also. It seems to me this is a bug/omission and the config file should be completed with this entry during setup. I've created a Connect entry for this issue - all please vote, validate, comment etc https://connect.microsoft.com/SQLServer/feedback/details/648476/ssrs-error-when-trying-to-create-cache-refresh-plan#