Reporting Services :- Error – “Invalid or Expired Session” // “LoadSnapshot: Item … not found in the database”

Background

Noticing an error in SQL Server Reporting Services.

 

Error

  1. Extended Event
    • Invalid or Expired Session: <####>
    • Expired Session: <####>
  2. SQL Server Reporting Services
    • LogFile
      • LoadSnapshot: Item with session <####> not found in the database

 

Trouble Shooting

SQL Server Engine

Extended Event

SQL Server Reporting Services

Error Log


session!ReportServer_0-58!5fb4!04/05/2018-08:50:38:: i INFO: LoadSnapshot: Item with session: zyqbuw55tqova33r1p3frq3h, reportPath: , userName: LAB\IISA1$ not found in the database
session!ReportServer_0-58!6e8!04/05/2018-09:27:18:: i INFO: LoadSnapshot: Item with session: hqmnqp55ln0d3u55jlm1lc45, reportPath: , userName: LAB\IISA1$ not found in the database
session!ReportServer_0-58!6e8!04/05/2018-13:01:20:: i INFO: LoadSnapshot: Item with session: li1xi5vyrnv4khb4r225txa2, reportPath: , userName: LAB\IISA1$ not found in the database
session!ReportServer_0-58!6e8!04/05/2018-13:10:20:: i INFO: LoadSnapshot: Item with session: li1xi5vyrnv4khb4r225txa2, reportPath: , userName: LAB\IISA1$ not found in the database
session!ReportServer_0-58!31c8!04/05/2018-13:19:20:: i INFO: LoadSnapshot: Item with session: li1xi5vyrnv4khb4r225txa2, reportPath: , userName: LAB\IISA1$ not found in the database
session!ReportServer_0-58!6c10!04/05/2018-13:28:20:: i INFO: LoadSnapshot: Item with session: li1xi5vyrnv4khb4r225txa2, reportPath: , userName: LAB\IISA1$ not found in the database
session!ReportServer_0-58!6c10!04/05/2018-13:37:21:: i INFO: LoadSnapshot: Item with session: li1xi5vyrnv4khb4r225txa2, reportPath: , userName: LAB\IISA1$ not found in the database
session!ReportServer_0-58!6e8!04/05/2018-13:46:21:: i INFO: LoadSnapshot: Item with session: li1xi5vyrnv4khb4r225txa2, reportPath: , userName: LAB\IISA1$ not found in the database
session!ReportServer_0-58!31c8!04/05/2018-13:55:20:: i INFO: LoadSnapshot: Item with session: li1xi5vyrnv4khb4r225txa2, reportPath: , userName: LAB\IISA1$ not found in the database
session!ReportServer_0-58!6e8!04/05/2018-14:04:20:: i INFO: LoadSnapshot: Item with session: li1xi5vyrnv4khb4r225txa2, reportPath: , userName: LAB\IISA1$ not found in the database
session!ReportServer_0-58!6e8!04/05/2018-14:13:21:: i INFO: LoadSnapshot: Item with session: li1xi5vyrnv4khb4r225txa2, reportPath: , userName: LAB\IISA1$ not found in the database
session!ReportServer_0-58!6e8!04/05/2018-14:22:21:: i INFO: LoadSnapshot: Item with session: li1xi5vyrnv4khb4r225txa2, reportPath: , userName: LAB\IISA1$ not found in the database
session!ReportServer_0-58!6e8!04/05/2018-14:31:21:: i INFO: LoadSnapshot: Item with session: li1xi5vyrnv4khb4r225txa2, reportPath: , userName: LAB\IISA1$ not found in the database
session!ReportServer_0-59!7760!04/05/2018-16:09:32:: i INFO: LoadSnapshot: Item with session: hqmnqp55ln0d3u55jlm1lc45, reportPath: , userName: LAB\IISA1$ not found in the database
session!ReportServer_0-59!6848!04/05/2018-16:15:56:: i INFO: LoadSnapshot: Item with session: hqmnqp55ln0d3u55jlm1lc45, reportPath: , userName: LAB\IISA1$ not found in the database
session!ReportServer_0-59!5fb4!04/05/2018-16:24:10:: i INFO: LoadSnapshot: Item with session: hqmnqp55ln0d3u55jlm1lc45, reportPath: , userName: LAB\IISA1$ not found in the database

 

Remediation

Outline

  1. Launch SQL Server Management Studio ( SSMS )
  2. Connect to the Instance’s Reporting Services
  3. Access the Server Properties
  4. Navigate to the Advanced Tab
  5. Ensure the following system properties are set
    • UseSessionCookies
      • Set to False

Screen Shots

Before

After

 

References

  1. Microsoft
    • MSDN
      • Challen Fu
        • Disable the Cache for all reports in SSRS 2008
          Link

 

Leave a Reply

Please log in using one of these methods to post your comment:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

w

Connecting to %s