Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Getting 503 error, child process (RSPortal) died (Report Server Sept Edition 2019)

Hi all,   We have installed the Power BI Report Server (Developer) Edition on our test machine (15.0.1102.597). The machine is running SQL Server 2016 Developer Edition. Calling the Report Server W...
RSPortal
  • All41S's avatar
    All41S
    6 years ago

    Hi All,

     

    try this - maybe it helps you - for me it fixed the issue.

     

    ISSUE

    After upgrading to the latest release of PBI RS, from May 2019 to September 2019, the Web Portal address is returning an HTTP 503 error

     

    CAUSE/Analysis

    Our latest’s release of Power BI Report server (September 2019) uses a more recent .NET Framework requirements and we advise a minimum of version 4.7

     

    Action Plan

    1. Please upgrade the .NET Framework to an 4.7 or newer version (.NET Framework Runtime)
      1. https://dotnet.microsoft.com/download
    2. Restart the Server
    3. Check if the PBI Report Server is now accessible to the Web Portal
d_gosbell's avatar
d_gosbell
Super User
6 years ago

That event from MSOLAP$PBIRS is not crticial. I've seen that on other servers and I do not think it would not be causing the portal process to die.

 

You may have to consider raising an official support ticket with Microsoft for this.

 

One other thing you could try would be to turn on verbose logging for PBIRS

 

PBI Report Server enable verbose log

Enabling verbose logging in Power BI Report Server is exactly same as how it was done in SQL Server Reporting Services. Here is how you can do that: 

1)      Open <install directory>\PBIRS\ReportServer\bin\ReportingServicesService.exe.config 

2)      Under <system.diagnostics>, there is a switch called "DefaultTraceSwitch". Change the value to "4". 

3)      Under <RStrace>, there is a configuration called "Components". Change the value to "all:4". 

 

Once you've done this I think you'll need to stop and start report server from the config manager. Maybe this will provide some extra information in the logs about why the RSPortal process dies.

 

PS. you will want to remember to reset the logging level back to the default level once you are finished as the verbose logging will use a lot of extra disk space.

 

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi,

 

thanks for the Logging trick. I changed the configuration file and restarted the server.

 

May I ask: How do I open an official support ticket with Microsoft regarding Power BI Server?

 

Here is the extended output of RSHostingService Logfile after the restart. From my point of view, there is no additional helpful information included :(

##########################################

2019-10-08 07:25:01.9097|INFO|1|File Logger created: C:\Program Files\Microsoft Power BI Report Server\PBIRS\LogFiles\RSHostingService_2019_10_08_07_25_01.log - level Trace, will roll at 32 Mb, process id 8756
2019-10-08 07:25:01.9410|INFO|1|Current Directory : C:\Program Files\Microsoft Power BI Report Server\PBIRS\RSHostingService
2019-10-08 07:25:02.1298|DEBUG|1|managementUrl
2019-10-08 07:25:02.2079|DEBUG|1|rsConfigFilePath
2019-10-08 07:25:02.2237|DEBUG|1|Attempting to read Configuration from file ..\ReportServer\rsreportserver.config -> C:\Program Files\Microsoft Power BI Report Server\PBIRS\ReportServer\rsreportserver.config
2019-10-08 07:25:02.2237|INFO|4|Updating application config files
2019-10-08 07:25:02.2237|INFO|4|Syncing service machine key
2019-10-08 07:25:02.2704|DEBUG|4|managementUrl
2019-10-08 07:25:02.2704|DEBUG|4|rsConfigFilePath
2019-10-08 07:25:02.2704|DEBUG|4|Attempting to read Configuration from file ..\ReportServer\rsreportserver.config -> C:\Program Files\Microsoft Power BI Report Server\PBIRS\ReportServer\rsreportserver.config
2019-10-08 07:25:02.2860|INFO|4|Launching Process : Management Service
2019-10-08 07:25:02.2860|INFO|4|Starting Process: C:\Program Files\Microsoft Power BI Report Server\PBIRS\Management\RSManagement.exe
2019-10-08 07:25:04.3982|INFO|12|Fetched ManagementState from Management state = Valid, Encryption key present = True
2019-10-08 07:25:04.4294|DEBUG|12|Attempting to read Configuration from file ..\ReportServer\rsreportserver.config -> C:\Program Files\Microsoft Power BI Report Server\PBIRS\ReportServer\rsreportserver.config
2019-10-08 07:25:04.4294|DEBUG|12|Hosting-encryptionKey
2019-10-08 07:25:04.4294|DEBUG|12|rsConfigFilePath
2019-10-08 07:25:04.4294|DEBUG|12|Hosting-databaseValidationStatus
2019-10-08 07:25:04.4294|DEBUG|12|Hosting-url-ManagementService
2019-10-08 07:25:04.4294|DEBUG|12|Hosting-url-ReportServerWebService
2019-10-08 07:25:04.4294|DEBUG|12|Hosting-url-ReportServerWebApp
2019-10-08 07:25:04.4294|DEBUG|12|Hosting-url-PowerBIService
2019-10-08 07:25:04.4294|DEBUG|12|Hosting-url-OfficeService
2019-10-08 07:25:04.4606|DEBUG|12|Hosting-configSwitches
2019-10-08 07:25:04.4606|INFO|12|Launching Process : RS Service
2019-10-08 07:25:04.4606|INFO|12|Starting Process: C:\Program Files\Microsoft Power BI Report Server\PBIRS\ReportServer\bin\ReportingServicesService.exe
2019-10-08 07:25:04.5388|INFO|12|Launching Process : Portal
2019-10-08 07:25:04.5388|INFO|12|Starting Process: C:\Program Files\Microsoft Power BI Report Server\PBIRS\Portal\RSPortal.exe
2019-10-08 07:25:04.5700|INFO|12|Launching Process : PowerBI
2019-10-08 07:25:04.5700|INFO|12|Starting Process: C:\Program Files\Microsoft Power BI Report Server\PBIRS\PowerBI\RSPowerBI.exe
2019-10-08 07:25:04.6169|INFO|12|Launching Process : Office
2019-10-08 07:25:04.6169|INFO|12|Starting Process: C:\Program Files\Microsoft Power BI Report Server\PBIRS\Office\RSOffice.exe
2019-10-08 07:25:04.6794|INFO|12|Service watchdog: starting
2019-10-08 07:25:04.7419|DEBUG|12|Attempting to read Configuration from file ..\ReportServer\rsreportserver.config -> C:\Program Files\Microsoft Power BI Report Server\PBIRS\ReportServer\rsreportserver.config
2019-10-08 07:25:04.7575|DEBUG|12|managementUrl
2019-10-08 07:25:04.7575|DEBUG|12|rsConfigFilePath
2019-10-08 07:25:04.7575|DEBUG|12|Attempting to read Configuration from file ..\ReportServer\rsreportserver.config -> C:\Program Files\Microsoft Power BI Report Server\PBIRS\ReportServer\rsreportserver.config
2019-10-08 07:25:04.7575|DEBUG|12|Attempting to read Configuration from file ..\ReportServer\rsreportserver.config -> C:\Program Files\Microsoft Power BI Report Server\PBIRS\ReportServer\rsreportserver.config
2019-10-08 07:25:04.7575|DEBUG|12|Hosting-encryptionKey
2019-10-08 07:25:04.7575|DEBUG|12|rsConfigFilePath
2019-10-08 07:25:04.7575|DEBUG|12|Hosting-databaseValidationStatus
2019-10-08 07:25:04.7575|DEBUG|12|Hosting-url-ManagementService
2019-10-08 07:25:04.7575|DEBUG|12|Hosting-url-ReportServerWebService
2019-10-08 07:25:04.7575|DEBUG|12|Hosting-url-ReportServerWebApp
2019-10-08 07:25:04.7575|DEBUG|12|Hosting-url-PowerBIService
2019-10-08 07:25:04.7575|DEBUG|12|Hosting-url-OfficeService
2019-10-08 07:25:04.7575|DEBUG|12|Hosting-configSwitches
2019-10-08 07:25:06.1681|WARN|12|Child Process [Portal] Died. Check the log for further information
2019-10-08 07:25:06.1681|INFO|12|Immediate restart of process Portal
2019-10-08 07:25:06.1837|INFO|12|Launching Process : Portal
2019-10-08 07:25:06.1837|INFO|12|Starting Process: C:\Program Files\Microsoft Power BI Report Server\PBIRS\Portal\RSPortal.exe
2019-10-08 07:25:07.8413|WARN|12|Child Process [Portal] Died. Check the log for further information
2019-10-08 07:25:07.8413|DEBUG|12|Throttling by 28326,8056 MS
2019-10-08 07:25:14.9206|DEBUG|5|Attempting to read Configuration from file ..\ReportServer\rsreportserver.config -> C:\Program Files\Microsoft Power BI Report Server\PBIRS\ReportServer\rsreportserver.config
2019-10-08 07:25:14.9206|DEBUG|5|managementUrl
2019-10-08 07:25:14.9206|DEBUG|5|rsConfigFilePath
2019-10-08 07:25:14.9206|DEBUG|5|Attempting to read Configuration from file ..\ReportServer\rsreportserver.config -> C:\Program Files\Microsoft Power BI Report Server\PBIRS\ReportServer\rsreportserver.config
2019-10-08 07:25:14.9206|DEBUG|5|Attempting to read Configuration from file ..\ReportServer\rsreportserver.config -> C:\Program Files\Microsoft Power BI Report Server\PBIRS\ReportServer\rsreportserver.config
2019-10-08 07:25:14.9206|DEBUG|5|Hosting-encryptionKey
2019-10-08 07:25:14.9206|DEBUG|5|rsConfigFilePath
2019-10-08 07:25:14.9206|DEBUG|5|Hosting-databaseValidationStatus
2019-10-08 07:25:14.9206|DEBUG|5|Hosting-url-ManagementService
2019-10-08 07:25:14.9206|DEBUG|5|Hosting-url-ReportServerWebService
2019-10-08 07:25:14.9206|DEBUG|5|Hosting-url-ReportServerWebApp
2019-10-08 07:25:14.9206|DEBUG|5|Hosting-url-PowerBIService
2019-10-08 07:25:14.9206|DEBUG|5|Hosting-url-OfficeService
2019-10-08 07:25:14.9206|DEBUG|5|Hosting-configSwitches
2019-10-08 07:25:25.0182|DEBUG|5|Attempting to read Configuration from file ..\ReportServer\rsreportserver.config -> C:\Program Files\Microsoft Power BI Report Server\PBIRS\ReportServer\rsreportserver.config
2019-10-08 07:25:25.0182|DEBUG|5|managementUrl
2019-10-08 07:25:25.0182|DEBUG|5|rsConfigFilePath
2019-10-08 07:25:25.0182|DEBUG|5|Attempting to read Configuration from file ..\ReportServer\rsreportserver.config -> C:\Program Files\Microsoft Power BI Report Server\PBIRS\ReportServer\rsreportserver.config
2019-10-08 07:25:25.0182|DEBUG|5|Attempting to read Configuration from file ..\ReportServer\rsreportserver.config -> C:\Program Files\Microsoft Power BI Report Server\PBIRS\ReportServer\rsreportserver.config
2019-10-08 07:25:25.0182|DEBUG|5|Hosting-encryptionKey
2019-10-08 07:25:25.0182|DEBUG|5|rsConfigFilePath
2019-10-08 07:25:25.0182|DEBUG|5|Hosting-databaseValidationStatus
2019-10-08 07:25:25.0182|DEBUG|5|Hosting-url-ManagementService
2019-10-08 07:25:25.0182|DEBUG|5|Hosting-url-ReportServerWebService
2019-10-08 07:25:25.0182|DEBUG|5|Hosting-url-ReportServerWebApp
2019-10-08 07:25:25.0182|DEBUG|5|Hosting-url-PowerBIService
2019-10-08 07:25:25.0182|DEBUG|5|Hosting-url-OfficeService
2019-10-08 07:25:25.0182|DEBUG|5|Hosting-configSwitches
2019-10-08 07:25:35.1026|DEBUG|4|Attempting to read Configuration from file ..\ReportServer\rsreportserver.config -> C:\Program Files\Microsoft Power BI Report Server\PBIRS\ReportServer\rsreportserver.config
2019-10-08 07:25:35.1026|DEBUG|4|managementUrl
2019-10-08 07:25:35.1026|DEBUG|4|rsConfigFilePath
2019-10-08 07:25:35.1026|DEBUG|4|Attempting to read Configuration from file ..\ReportServer\rsreportserver.config -> C:\Program Files\Microsoft Power BI Report Server\PBIRS\ReportServer\rsreportserver.config
2019-10-08 07:25:35.1026|DEBUG|4|Attempting to read Configuration from file ..\ReportServer\rsreportserver.config -> C:\Program Files\Microsoft Power BI Report Server\PBIRS\ReportServer\rsreportserver.config
2019-10-08 07:25:35.1026|DEBUG|4|Hosting-encryptionKey
2019-10-08 07:25:35.1026|DEBUG|4|rsConfigFilePath
2019-10-08 07:25:35.1026|DEBUG|4|Hosting-databaseValidationStatus
2019-10-08 07:25:35.1026|DEBUG|4|Hosting-url-ManagementService
2019-10-08 07:25:35.1026|DEBUG|4|Hosting-url-ReportServerWebService
2019-10-08 07:25:35.1026|DEBUG|4|Hosting-url-ReportServerWebApp
2019-10-08 07:25:35.1026|DEBUG|4|Hosting-url-PowerBIService
2019-10-08 07:25:35.1026|DEBUG|4|Hosting-url-OfficeService
2019-10-08 07:25:35.1026|DEBUG|4|Hosting-configSwitches
2019-10-08 07:25:36.1821|INFO|5|Throttled restart of process by 28.326,81ms: Portal
2019-10-08 07:25:36.1821|INFO|5|Launching Process : Portal
2019-10-08 07:25:36.1821|INFO|5|Starting Process: C:\Program Files\Microsoft Power BI Report Server\PBIRS\Portal\RSPortal.exe
2019-10-08 07:25:37.7470|WARN|14|Child Process [Portal] Died. Check the log for further information
2019-10-08 07:25:37.7470|DEBUG|14|Throttling by 58435,0617 MS

#################################################

 

The RSPortal Logfile has not changed:

#################################################

2019-10-08 07:26:36.5816|INFO|1|File Logger created: C:\Program Files\Microsoft Power BI Report Server\PBIRS\LogFiles\RSPortal_2019_10_08_07_26_36.log - level Trace, will roll at 32 Mb, process id 15412
2019-10-08 07:26:36.5972|INFO|1|Provider name
2019-10-08 07:26:36.5972|INFO|1|Container name Microsoft SQL Server Reporting Services Key Container 2010
2019-10-08 07:26:36.6128|INFO|1|Setting Symmetric Key
2019-10-08 07:26:36.6284|INFO|1|Setting up Hosted Process State

###################################################

 

There is a new PowerBI logfile with some errors regarding ExtendedEvents logging. I don't think it is the cause of my problem

###################################################

2019-10-08 07:25:04.9450|INFO|1|File Logger created: C:\Program Files\Microsoft Power BI Report Server\PBIRS\LogFiles\RSPowerBI_2019_10_08_07_25_04.log - level Trace, will roll at 32 Mb, process id 10556
2019-10-08 07:25:04.9919|INFO|1|Do not dump on: Microsoft.PowerBI.ReportServer.WebApi.Catalog.CatalogAccessException,System.Threading.ThreadAbortException,System.OutOfMemoryException,System.ObjectDisposedException,System.IO.IOException,System.IO.FileLoadException,System.AppDomainUnloadedException,System.Net.Http.HttpRequestException,System.Net.HttpListenerException,System.OperationCanceledException,System.InvalidOperationException
2019-10-08 07:25:04.9919|TRACE|1|Setting unhandled exception handler
2019-10-08 07:25:04.9919|INFO|1|Provider name
2019-10-08 07:25:04.9919|INFO|1|Container name Microsoft SQL Server Reporting Services Key Container 2010
2019-10-08 07:25:04.9919|INFO|1|Setting Symmetric Key
2019-10-08 07:25:05.0075|INFO|1|Setting up Hosted Process State
2019-10-08 07:25:05.0075|DEBUG|1|Attempting to read Configuration from file C:\Program Files\Microsoft Power BI Report Server\PBIRS\ReportServer\rsreportserver.config -> C:\Program Files\Microsoft Power BI Report Server\PBIRS\ReportServer\rsreportserver.config
2019-10-08 07:25:05.0544|TRACE|5|Start XEventLogger
2019-10-08 07:25:05.4317|INFO|1|The web server needs to run elevated
2019-10-08 07:25:05.4317|INFO|1|Web Server is running.
2019-10-08 07:25:07.0587|INFO|4|Attempting to connect to Analysis Services XEvent logging...
2019-10-08 07:25:07.3100|ERROR|4|Error creating Analysis Services XEvent traceMicrosoft.AnalysisServices.AdomdClient.AdomdErrorResponseException: Failed to complete the command. XEvent is not initialized.
at Microsoft.AnalysisServices.AdomdClient.AdomdConnection.XmlaClientProvider.Microsoft.AnalysisServices.AdomdClient.IExecuteProvider.Execute(ICommandContentProvider contentProvider, AdomdPropertyCollection commandProperties, IDataParameterCollection parameters)
at Microsoft.AnalysisServices.AdomdClient.AdomdCommand.ExecuteXmlReader()
at Microsoft.PowerBI.ReportServer.AsServer.AnalysisServicesXEventLogger.TryCreatingAndSubscribingToXEventsTrace()
2019-10-08 07:25:09.3160|INFO|7|Attempting to connect to Analysis Services XEvent logging...
2019-10-08 07:25:09.3160|ERROR|7|Error creating Analysis Services XEvent traceMicrosoft.AnalysisServices.AdomdClient.AdomdErrorResponseException: Failed to complete the command. XEvent is not initialized.
at Microsoft.AnalysisServices.AdomdClient.AdomdConnection.XmlaClientProvider.Microsoft.AnalysisServices.AdomdClient.IExecuteProvider.Execute(ICommandContentProvider contentProvider, AdomdPropertyCollection commandProperties, IDataParameterCollection parameters)
at Microsoft.AnalysisServices.AdomdClient.AdomdCommand.ExecuteXmlReader()
at Microsoft.PowerBI.ReportServer.AsServer.AnalysisServicesXEventLogger.TryCreatingAndSubscribingToXEventsTrace()

[...] 
Message:Either the trace with the ID of 'PBIRSTrace' does not exist in the server with the ID of 'BI_WIN2016_DEV\PBIRS', or the user does not have permissions to access the object.

###################################################################

 

Kind regards

Patrick