Power BI Report Server hanging

[MikeSJ]

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?

[saglamtimur]

Antivirus or some other application/service seems locking the log files while reading them. You may be able to determine what's locking that file using LockHunter or any other monitoring tool, immediately after exception occurs.

If my post solved your problem, mark my post as a solution to help others to quickly find it and also please give it a 👍

[KBO]

Hi @MikeSJ ,

how big is the SQL DB sized on which your Report Server DB is stores? Is the Report Server Service and the DB on the same machine? If not may be check the infrastructure.

Best,

Kathrin

If this post has helped you, please give it a thumbs up!
Did I answer your question? Mark my post as a solution!

[MikeSJ]

Hi,

DB and Power BI are on the same server. All databases are small

[KBO]

Hi @MikeSJ ,

sounds good - do have running jobs on the Report Server? (Scheduele Refreshes)

If yes and you refresh them every 5 or 10 Minutes it also could be that the performace of the rest is effected.

And how many capacity do have on your DB?

BEst,

Kathrin

If this post has helped you, please give it a thumbs up!
Did I answer your question? Mark my post as a solution!

[MikeSJ]

Hi Kathrin,

No refreshes that frequent and plenty of capacity in the databases.

Looks like I will have to wait till another month rolls around to investigate further.

Cheers,

Mike