Subscriptions are 'disabled' and setting to enabled instantly revert to disabled

Question

Post reply

Subscriptions are 'disabled' and setting to enabled instantly revert to disabled

sqlnorth

Mr or Mrs. 500

Points: 593
More actions
August 23, 2022 at 2:21 pm

#4079720

We have SSRS 2019, some of our subscriptions (across multiple reports) are currently 'disabled' and other subscriptions for same reports are ok so cannot see any commonality.
If we via the browser mark the subscription as enabled, then refresh browser it is back in disabled mode.
However if we 'edit' the subscription then simply click 'apply' so no conscious change then it is in enabled mode.
Looking in SSRS logs I can only see this which I cannot explain, so not sure if it is the reason as this is a pure SSRS 2019 install, no PBI elements.
library!ReportServer_0-19!d9c!08/23/2022-15:44:00:: i INFO: Call to GetReportParametersAction(/Da Vinci/Finance/Accounts Receivable/Invoice Audit (DV-FAR09)). User: UserX.
library!ReportServer_0-19!35a4!08/23/2022-15:44:00:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.NotEnabledException: ,
Microsoft.ReportingServices.Diagnostics.Utilities.NotEnabledException: The requested functionality is not currently enabled.;
extensionfactory!ReportServer_0-19!35a4!08/23/2022-15:44:00:: i INFO: Skipped instantiating Report Server PowerBI report server extension. Extension was not enabled.
thanks in advance

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Jo Pattyn SSC-Dedicated Points: 32347 More actions · Answer 1

Not sure if it's related but occasionally we have corrupt subscriptions. Those have a double datasource

check

select 
DataSource.DSID DatasourceID
,DataSource.Name DatasourceName
,Subscriptions.[SubscriptionID] SubscriptionID
,Subscriptions.Description SubscriptionName
,Reports.Name RerportName
,Reports.Path ReportPath
from [ReportServer].[dbo].[DataSource] DataSource
left join [ReportServer].dbo.Subscriptions  Subscriptions
on DataSource.SubscriptionID =Subscriptions.SubscriptionID
left join [ReportServer].[dbo].[Catalog] Reports
on Subscriptions.Report_OID=Reports.ItemID
where DataSource.SubscriptionID in
(
SELECT 
[SubscriptionID]
--, count(*) aantal
  FROM [ReportServer].[dbo].[DataSource]
  where subscriptionid is not null
group by SubscriptionID
having count(*) > 1
)

Fix is deleting a double datasource

DELETE FROM ReportServer.dbo.DataSource
WHERE DSID = (
    SELECT MAX(DSID)
    FROM ReportServer.dbo.Subscriptions
    JOIN ReportServer.dbo.DataSource
       ON DataSource.SubscriptionID = Subscriptions.SubscriptionID
    WHERE Subscriptions.SubscriptionID = 'GUID AbonnementID' 
)

sqlnorth Mr or Mrs. 500 Points: 593 More actions · Answer 2

thanks for reply, but no just 1 datasource, and some subscriptions for same report are ok, just some are disabled, change to enabled via browser immediately back to disabled (it must do an internal verification). Open/save subscription fixes it, but 400+ of them have this problem, am thinking direct update of inactiveflags field on subsriptions to set to 0 and see if that keeps it ok, but probably would not as i guess SSRS would do same check

sqlnorth Mr or Mrs. 500 Points: 593 More actions · Answer 3

It appears that the 'enabled' button only works if user clicked disabled (sets inactiveflags to 128), so a value of 4 or 8 needs to set to 0 via update statement or to edit then save subscription with no changes, which I guess performs some sort of refresh to fix this random issue