cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
New Member

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?

5 REPLIES 5
Highlighted
Memorable Member
Memorable Member

Re: Power BI Report Server hanging

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!

Highlighted
New Member

Re: Power BI Report Server hanging

Hi,

 

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

Highlighted
Memorable Member
Memorable Member

Re: Power BI Report Server hanging

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!

Highlighted
Resolver II
Resolver II

Re: Power BI Report Server hanging

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 👍

Highlighted
New Member

Re: Power BI Report Server hanging

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

 

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Community Conference

Microsoft Power Platform Communities

Check out the Winners!

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Tech Marathon

Maratón de Soluciones de Negocio Microsoft

Una semana de contenido con +100 sesiones educativas, consultorios, +10 workshops Premium, Hackaton, EXPO, Networking Hall y mucho más!