topic Re: Unable to manage or create subscriptions in Web Portal in Report Server

Unable to manage or create subscriptions in Web Portal

ianproc — Thu, 28 Jul 2022 16:23:26 GMT

I am trying to copy my PBIRS system to a new server.

I backup the ReportServer and ReportServerTEmpDB database
Restore the backups on the new server
I backup and restore the encryption key on the new server

The subscription jobs in the SQL Agent are automatically created and all the reports in the Web Portal appear and seem fine.

However when I browse to the "My Subscriptions" page or I try to view the existing subscriptions for a report I get "An Error Has Occurred. Please try again later".

If I try to create a new subscription I again get "An Error Has Occurred. Please try again later", but the New Subsciption page does appear but with no delivery methods in the drop down box.

I have tried changing the email settings in the configuration manager to no change in behaviour.

In the RSPortal Log file I get the following error each time I get the error message in the web portal.

2022-07-28 17:14:49.0894|ERROR|45|OData exception occurred: System.Net.WebException: The request failed with HTTP status 503: Service Unavailable.

I am running the May 2022 version (15.0.1108.297) of Power BI Report Server on Windows Server 2019

What is the problem and how can I fix it?

Re: Unable to manage or create subscriptions in Web Portal

Anonymous — Mon, 01 Aug 2022 04:45:43 GMT

Hi ianproc ,

In Power BI Report Server, this issue "HTTP Error 503 The service is unavailable" usually occurs in case of the following:

The PowerBI Report Server service is stopped.
The PowerBI Report Server service Account is disabled or its password expired
The PowerBI Report Server service account is not configured properly.
The Power BI Report Server is not configured properly.

Please first check if the above problem occurs according to this document.

Also, you may check this thread to see if it helps you with your problem.

HTTP Error 503. The service is unavailable

Best Regards,
Community Support Team _ Caitlyn

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

Re: Unable to manage or create subscriptions in Web Portal

ianproc — Mon, 01 Aug 2022 08:59:51 GMT

The "503: Service Unavailable" error comes out of the Log Files. All reports work - its JUST THE SUBSCRIPTIONS. So all the above links/solutions don't apply.

We're using the same account as the server that works. As far as we know the two servers are identical.

Re: Unable to manage or create subscriptions in Web Portal

Anonymous — Tue, 02 Aug 2022 02:42:50 GMT

Hi ianproc ,

If you reconfigure the data source authentication and connection in Report Manager, does this problem still exist?

Also,please check out this thread below, he seems to have a similar experience to you.

An Error occurred try again later when trying to modify subscription

Hope it helps,

Best Regards,
Community Support Team _ Caitlyn

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

Re: Unable to manage or create subscriptions in Web Portal

ianproc — Tue, 02 Aug 2022 14:16:12 GMT

If you reconfigure the data source authentication and connection in Report Manager, does this problem still exist?

YES

An Error occurred try again later when trying to modify subscription

I tried the script in the solution and it makes no difference. The problem while similar didn't mention the "503 Service Unavailable" error I see in the log file.

Re: Unable to manage or create subscriptions in Web Portal

ianproc — Tue, 02 Aug 2022 14:29:53 GMT

THis is what I find in the RSPortal_YYYY_MM_DD_HH_MM_SS.log file:

2022-08-02 15:02:37.4765|ERROR|11|OData exception occurred: System.Net.WebException: The request failed with HTTP status 503: Service Unavailable.
at System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage message, WebResponse response, Stream responseStream, Boolean asyncCall)
at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodName, Object[] parameters)
at Microsoft.SqlServer.ReportingServices2010.ReportingService2010.GetItemParameters(String ItemPath, String HistoryID, Boolean ForRendering, ParameterValue[] Values, DataSourceCredentials[] Credentials)
at Microsoft.SqlServer.ReportingServices2010.RSConnection2010.<>c__DisplayClass94_0.<GetItemParameters>b__0()
at Microsoft.SqlServer.ReportingServices2010.RSConnection2010.SoapMethodWrapper`1.ExecuteMethod(Boolean setConnectionProtocol)
at Microsoft.SqlServer.ReportingServices2010.RSConnection2010.GetItemParameters(String itemPath, String historyId, Boolean forRendering, ParameterValue[] values, DataSourceCredentials[] credentials)
at Microsoft.ReportingServices.Portal.Services.SoapProxy.SoapRS2010Proxy.<>c__DisplayClass6_0.<GetItemParameters>b__0()
at Microsoft.ReportingServices.Portal.Services.SoapProxy.SoapAuthenticationHelper.ExecuteWithWindowsAuth[TReturn](SoapHttpClientProtocol soapClient, IPrincipal userPrincipal, Func`1 func)
at Microsoft.ReportingServices.Portal.Services.SoapProxy.SoapRS2010Proxy.GetParameterTypes(IPrincipal userPrincipal, String reportpath)
at Microsoft.ReportingServices.Portal.Repositories.SubscriptionService.<>c__DisplayClass4_0.<GetSubscriptions>b__0(SubscriptionImpl x)
at System.Linq.Enumerable.WhereSelectArrayIterator`2.MoveNext()
at System.Collections.Generic.List`1..ctor(IEnumerable`1 collection)
at System.Linq.Enumerable.ToList[TSource](IEnumerable`1 source)
at Microsoft.ReportingServices.Portal.ODataWebApi.V1.Controllers.SubscriptionsController.GetEntitySet(String castName)
at Microsoft.ReportingServices.Portal.ODataWebApi.Controllers.Reflection.EntitySetReflectionODataController`1.GetRoot(ODataPath oDataPath, Int32& index)
at Microsoft.ReportingServices.Portal.ODataWebApi.Controllers.Reflection.ReflectionODataController`1.Get(ODataPath oDataPath)
at lambda_method(Closure , Object , Object[] )
at System.Web.Http.Controllers.ReflectedHttpActionDescriptor.ActionExecutor.<>c__DisplayClass6_2.<GetExecutor>b__2(Object instance, Object[] methodParameters)
at System.Web.Http.Controllers.ReflectedHttpActionDescriptor.ExecuteAsync(HttpControllerContext controllerContext, IDictionary`2 arguments, CancellationToken cancellationToken)
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at System.Web.Http.Controllers.ApiControllerActionInvoker.<InvokeActionAsyncCore>d__1.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at System.Web.Http.Filters.ActionFilterAttribute.<CallOnActionExecutedAsync>d__6.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
at System.Web.Http.Filters.ActionFilterAttribute.<CallOnActionExecutedAsync>d__6.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at System.Web.Http.Filters.ActionFilterAttribute.<ExecuteActionFilterAsyncCore>d__5.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at System.Web.Http.Controllers.ActionFilterResult.<ExecuteAsync>d__5.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at System.Web.Http.Controllers.ExceptionFilterResult.<ExecuteAsync>d__6.MoveNext().| RequestID = s_3d76d1b9-c25a-45e5-a52a-5b065155f1ed