June 14, 2021 at 3:43 pm
Hello experts,
I migrated some SSRS 2012 reports, including some subscriptions, into a new SSRS 2017 instance.
I can see a list of the migrated subscriptions in the ReportServer database with the query below. But when I try to go to the My subscriptions page in the SSRS web portal, I get the error below; No subscriptions are visible on the page; and there is no way to add a subscription.
"An error occurred. Something went wrong. Please try again later."
Does anyone know why this error happens and how to fix it? I don't think the log files show anything of interest, but if there are any errors I should look for, please let me know.
Thanks for any help.
-- webrunner
USE ReportServer
GO
SELECT
c.Name AS ReportName,
'Next Run Date' = CASE next_run_date
WHEN 0 THEN null
ELSE
substring(convert(varchar(15),next_run_date),1,4) + '/' +
substring(convert(varchar(15),next_run_date),5,2) + '/' +
substring(convert(varchar(15),next_run_date),7,2)
END,
'Next Run Time' = isnull(CASE len(next_run_time)
WHEN 3 THEN cast('00:0'
+ Left(right(next_run_time,3),1)
+':' + right(next_run_time,2) as char (8))
WHEN 4 THEN cast('00:'
+ Left(right(next_run_time,4),2)
+':' + right(next_run_time,2) as char (8))
WHEN 5 THEN cast('0' + Left(right(next_run_time,5),1)
+':' + Left(right(next_run_time,4),2)
+':' + right(next_run_time,2) as char (8))
WHEN 6 THEN cast(Left(right(next_run_time,6),2)
+':' + Left(right(next_run_time,4),2)
+':' + right(next_run_time,2) as char (8))
END,'NA'),
Convert(XML,[ExtensionSettings]).value('(//ParameterValue/Value[../Name="TO"])[1]','nvarchar(50)') as [To]
,Convert(XML,[ExtensionSettings]).value('(//ParameterValue/Value[../Name="CC"])[1]','nvarchar(50)') as [CC]
,Convert(XML,[ExtensionSettings]).value('(//ParameterValue/Value[../Name="RenderFormat"])[1]','nvarchar(50)') as [Render Format]
,Convert(XML,[ExtensionSettings]).value('(//ParameterValue/Value[../Name="Subject"])[1]','nvarchar(50)') as [Subject]
---Example report parameters: StartDateMacro, EndDateMacro & Currency.
,Convert(XML,[Parameters]).value('(//ParameterValue/Value[../Name="StartDateMacro"])[1]','nvarchar(50)') as [Start Date]
,Convert(XML,[Parameters]).value('(//ParameterValue/Value[../Name="EndDateMacro"])[1]','nvarchar(50)') as [End Date]
,Convert(XML,[Parameters]).value('(//ParameterValue/Value[../Name="Currency"])[1]','nvarchar(50)') as [Currency]
,[LastStatus]
,[EventType]
,[LastRunTime]
,[DeliveryExtension]
,[Version]
FROM
dbo.[Catalog] c
INNER JOIN dbo.[Subscriptions] S ON c.ItemID = S.Report_OID
INNER JOIN dbo.ReportSchedule R ON S.SubscriptionID = R.SubscriptionID
INNER JOIN msdb.dbo.sysjobs J ON Convert(nvarchar(128),R.ScheduleID) = J.name
INNER JOIN msdb.dbo.sysjobschedules JS ON J.job_id = JS.job_id
Ref.: https://stackoverflow.com/questions/18960965/ssrs-subscriptions-how-to-view-all-report-recipients
-------------------
A SQL query walks into a bar and sees two tables. He walks up to them and asks, "Can I join you?"
Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html
June 14, 2021 at 6:43 pm
I think I found the answer.
Even when one wants to use SSL/443 (as we do), apparently the subscriptions page starts erroring out if you take out port 80 in the Advanced Multiple Web Site Configuration's top section "Multiple HTTP Identities for the currently selected Reporting Services feature."
Once I put back port 80, the subscription page loaded without issue.
Seems odd but maybe someone has an explanation for this setup.
Thanks, HTH.
-- webrunner
-------------------
A SQL query walks into a bar and sees two tables. He walks up to them and asks, "Can I join you?"
Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html
June 15, 2021 at 7:18 pm
Might be a silly question but did you set up both the web portal and web service for SSL?
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
August 17, 2022 at 11:03 pm
We just had a similar problem (SQL Server Standard 2019) after someone installed a new certificate. As part of the installation, they got rid of entries we didn't need. Such as the port 80!
I agree that we shouldn't need it, but as soon as I put it back, subscription management (per report or per system) began to work again. Note that all access we can control and see seems to be HTTPS, so I am not sure how or where the port 80 enters into things.
Thanks, Webrunner. It would have taken forever to figure this out.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply