尝试在报表管理器Url中查看SSRS订阅时出错

Question

我们的报表服务器数据库已移至新环境。订阅适用于大多数用户/所有者。然而，我们有一个不能工作的问题。已使用以下查询进行更改：

      DECLARE @OldUserID uniqueidentifier
      DECLARE @NewUserID uniqueidentifier
      SELECT @OldUserID = UserID FROM dbo.Users WHERE UserName = 'DOMAINA\OldUser'
      SELECT @NewUserID = UserID FROM dbo.Users WHERE UserName = 'DOMAINA\NewUser'
      UPDATE dbo.Subscriptions SET OwnerID = @NewUserID WHERE OwnerID = @OldUserID

您可以查询(SSMS)并看到新用户现在拥有订阅，但当您尝试在报表服务器上查看此内容时，会得到如下图所示的错误

​

​

日志文件错误如下：

​

library!ReportServer_0-1!2a1c!10/05/2017-11:53:22:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.NotEnabledException: , Microsoft.ReportingServices.Diagnostics.Utilities.NotEnabledException: The requested functionality is not currently enabled.;
extensionfactory!ReportServer_0-1!2a1c!10/05/2017-11:53:22:: i INFO: Skipped instantiating Report Server PowerBI report server extension. Extension was not enabled.
library!ReportServer_0-1!2908!10/05/2017-11:53:29:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.NotEnabledException: , Microsoft.ReportingServices.Diagnostics.Utilities.NotEnabledException: The requested functionality is not currently enabled.;
extensionfactory!ReportServer_0-1!2908!10/05/2017-11:53:29:: i INFO: Skipped instantiating Report Server PowerBI report server extension. Extension was not enabled.
library!ReportServer_0-1!2fa4!10/05/2017-11:53:29:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.NotEnabledException: , Microsoft.ReportingServices.Diagnostics.Utilities.NotEnabledException: The requested functionality is not currently enabled.;

​

我该如何解决这个问题？

Answer 1

我也有同样的问题。我转到ReportServer数据库订阅表，选择属于我的报告(使用OwnerID，您可以在Users表中查找)，结果显示我的一些报告具有'en‘语言环境，而其他报告则为'rus’。当只剩下一个语言环境时，问题就消失了。

下面是您要查找的select：

​

SELECT [SubscriptionID]
    ,[OwnerID]
    ,[Report_OID]
    ,[Locale]
    ,[InactiveFlags]
    ,[ExtensionSettings]
    ,[ModifiedByID]
    ,[ModifiedDate]
    ,[Description]
    ,[LastStatus]
    ,[EventType]
    ,[MatchData]
    ,[LastRunTime]
    ,[Parameters]
    ,[DataSettings]
    ,[DeliveryExtension]
    ,[Version]
    ,[ReportZone]
FROM [ReportServer].[dbo].[Subscriptions] s
inner join [ReportServer].[dbo].[Users] u
on s.ownerid = u.[UserID]
where u.username like '%your_name%'

​