Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
ianproc
New Member

Unable to manage or create subscriptions in Web Portal

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

  1. I backup the ReportServer and ReportServerTEmpDB database
  2. Restore the backups on the new server
  3. 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?

5 REPLIES 5
ianproc
New Member

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

v-xiaoyan-msft
Community Support
Community Support

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.

 

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.

v-xiaoyan-msft
Community Support
Community Support

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.

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.

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.