SQL Server Reporting Services EventID 108异常报错求助

环境与问题现象 #

• 使用SQL Server 2019（15.0.1102.861）Reporting Services
• 服务不定期在同一秒内多次（5-6次）触发EventID 108报错，无规律可循
• 报错发生时无订阅、定时任务等特殊任务执行，暂无法确定是否因用户打开/编辑含非最优查询的报表导致
• 未安装Analysis Server，怀疑报错由Skype for Business或Anywhere 365的报表触发

Windows事件日志记录 #

原始错误摘要：

error, ID:108, Source:Report Server (SSRS), Message:Report Server (SSRS)

完整事件XML（含DAX标识）：

<Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event">
   <System>
      <Provider Name="Report Server (SSRS)" /> 
      <EventID Qualifiers="0">108</EventID> 
      <Level>2</Level> 
      <Task>2</Task> 
      <Keywords>0x80000000000000</Keywords> 
      <TimeCreated SystemTime="2023-02-08T06:26:17.553286000Z" /> 
      <EventRecordID>365647</EventRecordID> 
      <Channel>Application</Channel> 
      <Computer>MyReportServer.MyDomain</Computer> 
      <Security /> 
   </System>
   <EventData>
      <Data>Report Server (SSRS)</Data> 
      <Data>DAX</Data> 
   </EventData>
</Event>

报错时间戳（同一秒内多次触发） #

<TimeCreated SystemTime="2023-02-08T06:26:17.553286000Z" /> 
<TimeCreated SystemTime="2023-02-08T06:26:17.553286000Z" />
<TimeCreated SystemTime="2023-02-08T06:26:17.537658500Z" />
<TimeCreated SystemTime="2023-02-08T06:26:17.522032200Z" />
<TimeCreated SystemTime="2023-02-08T06:26:17.037601300Z" />

SSRS同期日志（疑似无关警告） #

2023-02-08 06:26:13.7997|INFO|21|Deleting expired log file: C:\Program Files\Microsoft SQL Server Reporting Services\SSRS\LogFiles\RSPortal_2023_01_04_19_15_05.log Last written: 04.01.2023 19:15:05
2023-02-08 06:26:13.7997|WARN|21|Exception deleting expired log fileSystem.IO.IOException: The process cannot access the file 'C:\Program Files\Microsoft SQL Server Reporting Services\SSRS\LogFiles\RSPortal_2023_01_04_19_15_05.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)
2023-02-08 06:26:23.8306|INFO|21|Deleting expired log file: C:\Program Files\Microsoft SQL Server Reporting Services\SSRS\LogFiles\RSPortal_2023_01_04_19_15_05.log Last written: 04.01.2023 19:15:05
2023-02-08 06:26:23.8306|WARN|21|Exception deleting expired log fileSystem.IO.IOException: The process cannot access the file 'C:\Program Files\Microsoft SQL Server Reporting Services\SSRS\LogFiles\RSPortal_2023_01_04_19_15_05.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)

请求协助排查该EventID 108报错的根本原因。

内容的提问来源于stack exchange，提问作者Michael Tobisch