SharePoint SSRS integrated report manage subscription issues

Question

SharePoint SSRS integrated report manage subscription issues

Shri-6058 326

Hello, I have 100s of Reports published via SharePoint 2013 integrated mode. All sudden from past one month, I cant see the manage subscription list(once you register subscription, it use to show a list of subscriber) and its now showing blank. Is there a way to retrive via database? I dont want to repair or apply april month security due to unsupported scenario. I really want to recover the manage subscription list.

Please advise a way to retrive existing subscription list for the report. Thank you

2 answers

Your answer

Answer 1

Yanli Jiang - MSFT 31,681 Microsoft External Staff

Hi Shri-6058 ,

Please try the following PowerShell script:



Add-PSSnapin Microsoft.SharePoint.PowerShell -ErrorAction SilentlyContinue

$webApp = Get-SPWebApplication "http://yourwebappurl"
$ssrsSubMgr = $webApp.GetSSRSReportServerSubscriptionManager()

if ($ssrsSubMgr -ne $null)
{
    Write-Host "Manage Subscription option for SSRS is available."
}
else
{
    Write-Host "Manage Subscription option for SSRS is not available."
}

Note that you'll need to replace "http://yourwebappurl" with the URL of your SharePoint web application.

For more information, please refer to:

https://learn.microsoft.com/en-us/sql/reporting-services/subscriptions/manage-subscription-owners-and-run-subscription-powershell?view=sql-server-ver16

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Yanli Jiang - MSFT 31,681 Reputation points Microsoft External Staff

2023-07-04T09:48:17.5866667+00:00

Hi Shri-6058 ,

Do you have further question on this, could we offer more support? If you have any concerns, please feel free to reply.

If the answer is helpful, please click "Accept Answer" and kindly upvote it.
Shri-6058 326 Reputation points

2023-07-18T15:50:19.51+00:00

Thank you Yanli Jiang. when I tried to run the script, it errors "Method invocation failed because [Microsoft.SharePoint.Administration.SPWebApplication] does not contain a method named 'GetSSRSReportServerSubscriptionManager'."

Do I have to include the method or is it part of the admin sharepoint?

Thanks

Shridhar

The following script runs just fine however when I try to retrive ListMySubscriptions, its returning blank

Param(

[string]$server,

[string]$site

)

$webAddr = 'https://SPssrsReport/_vti_bin/ReportServer/ReportService2010.asmx'

$secpasswd = ConvertTo-SecureString "xxxxxxxxx" -AsPlainText -Force

$mycreds = New-Object System.Management.Automation.PSCredential ("\spreportAdmin", $secpasswd)

[System.Net.ServicePointManager]::ServerCertificateValidationCallback = {$true}

$rs2010 += New-WebServiceProxy -Uri $webAddr -Credential $mycreds -Namespace SSRS.ReportingService2010;

#$rs2010 | get-member;

$mySubsList = $rs2010.ListMySubscriptions($site);

$mySubsList | select *

#Run example: powershell E:\code\temp\Subscription.ps1 "/_vti_bin/ReportServer/" "https://SPssrsReport"

thanks

Shri

Answer 2

Yanli Jiang - MSFT 31,681 Microsoft External Staff

Hi Shri-6058 ,

Please try to go to Central Administration->Site settings->Site collection features, and make sure "Report Server Central Administration Feature" is activated.

Then go to the site collection, and make sure "Report Server Integration Feature" is activated at site collection level.

If you could not see these features, please run rsSharePoint.msi and repair.

Similar issue for your reference:

https://social.technet.microsoft.com/Forums/office/en-US/1d980e96-4867-4412-9d38-3e34fb7114d3/report-subscriptions-menu-missing?forum=SP2016

More troubleshooting:

https://social.technet.microsoft.com/wiki/contents/articles/1867.sharepoint-2010-troubleshoot-sql-server-reporting-services-ssrs.aspx

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Shri-6058 326 Reputation points

2023-06-23T16:36:36.7366667+00:00

Thank you for the response. I verified both in Central admin and the site collection have this feature activated already. Thats how all reports are loading just fine. The problem is only with subscription doesnt show on the page and beleive its stored in the database. Thats how existing enrolled people are good.

We are in a process of taking it to PowerBI however we cant find the subscriber is a big challenge.

I am really afraid of repairing using rsSharePoint.msi as it might result some other reporting display issue and its unsupported already. Any other Powershell script or mechanism to retrieve manage subscription?

Appreciate any help
Shri-6058 326 Reputation points

2023-07-18T15:54:10.68+00:00

I did run the rsSharePoint.msi in my development and the SSRS reporting service is crashed. Luckily I tried ind development. It appears that somthing glitches. I have the Mar 2023 updates on the dev SharePoint as well.

Share via

SharePoint SSRS integrated report manage subscription issues

2 answers

Your answer