rsportal

3 Topics

Error RSPortal: obtaining a connection from the pool
Hi, we use Oct. 2020 release (product version 1.9.7627.11028) and have the following Internal Server Error: 2021-02-01 10:54:28.3246|ERROR|190|OData exception occurred: System.Exception: ReportServerDatabaseUnavailableException --->System.InvalidOperationException: Timeout expired. The timeout period elapsed prior to obtaining a connection from the pool. This may have occurred because all pooled connections were in use and max pool size was reached. I can reproduce this error when i open one of our Power BI Reports ( Live Connection to Tabular) and navigate through the tabs and filter values. After each click i can see increasing connections on SQL Server DB ReportSever DB via sys.sysprocesses. When it reaches 100 connections , the error occurs and the Report Service is unavailable( empty root folder) for some minutes. 100 fits to the following Log entry in RSPortal after restarting PBIRS: 2021-02-01 12:05:10.4767|INFO|1|Catalog max connection pool size: 100 What is RsPortal used for? Older Power BI report do not show this behaviour. Is it a bug and how can i resolve or work around the problem? Is it fixed in Januar 2021 release?
Solved
Anonymous
5 years ago Place Report Server
24KViews
1like
33Comments
Power BI Report Server hanging
HI, I am periodically finding that the reports on our Power BI report Server become unavailable and when I try and access them I just get a loading message on the web page. Investigating further each time they hang I see the following messages in the log file 2020-07-20 00:00:06.6986|INFO|125|Catalog max connection pool size: 100 2020-07-20 00:00:06.6986|INFO|125|Deleting expired log file: D:\Program Files\Microsoft Power BI Report Server\PBIRS\LogFiles\msmdsrv.log Last written: 6/19/2020 6:32:14 PM 2020-07-20 00:00:06.6986|WARN|125|Exception deleting expired log fileSystem.IO.IOException: The process cannot access the file 'D:\Program Files\Microsoft Power BI Report Server\PBIRS\LogFiles\msmdsrv.log' because it is being used by another process. at System.IO.__Error.WinIOError(Int32 errorCode, String maybeFullPath) at System.IO.File.InternalDelete(String path, Boolean checkHost) at Microsoft.BIServer.HostingEnvironment.Logger.DeleteExpiredFilesInternal(Int32 keepUntilDays, FileInfo[] logFiles) 2020-07-20 00:00:06.6986|INFO|125|Deleting expired log file: D:\Program Files\Microsoft Power BI Report Server\PBIRS\LogFiles\RSHostingService_2020_07_05_00_00_02.log Last written: 7/5/2020 11:59:57 PM 2020-07-20 00:00:06.7142|INFO|125|Deleting expired log file: D:\Program Files\Microsoft Power BI Report Server\PBIRS\LogFiles\RSPortal_2020_06_25_18_05_44.log Last written: 6/25/2020 6:05:44 PM 2020-07-20 00:00:06.7142|WARN|125|Exception deleting expired log fileSystem.IO.IOException: The process cannot access the file 'D:\Program Files\Microsoft Power BI Report Server\PBIRS\LogFiles\RSPortal_2020_06_25_18_05_44.log' because it is being used by another process. at System.IO.__Error.WinIOError(Int32 errorCode, String maybeFullPath) at System.IO.File.InternalDelete(String path, Boolean checkHost) at Microsoft.BIServer.HostingEnvironment.Logger.DeleteExpiredFilesInternal(Int32 keepUntilDays, FileInfo[] logFiles) Any idea if these are the cause of the hanging and how I can prevent the deletion exceptions from happening?
MikeSJ
6 years ago Place Report Server
3.6KViews
0likes
5Comments
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 Web Service URLs works properly. However, when calling the Web Portal URL, we are getting an 503 error. The RSHostingService LogFile contains the following information: ################ 2019-10-04 08:17:42.4934|INFO|12|Immediate restart of process Portal 2019-10-04 08:17:42.4934|INFO|12|Launching Process : Portal 2019-10-04 08:17:42.4934|INFO|12|Starting Process: C:\Program Files\Microsoft Power BI Report Server\PBIRS\Portal\RSPortal.exe 2019-10-04 08:17:44.3907|WARN|12|Child Process [Portal] Died. Check the log for further information ################ Does anyone have an idea what to do against the dying RSPortal process? It worked properly with an older version of Power BI report server. I also tried assigning another Web Portal Virtual Directory and another Port. No success. Restarts did not work either. Thank you for any help, kind regards, Patrick Wolf
Solved
Anonymous
6 years ago Place Report Server
35KViews
1like
22Comments