FIX: You receive error messages when you run a query that uses tempdb in SQL Server

Applies to: SQL Server 2012 Service Pack 3


You run a query on an instance of Microsoft SQL Server 2012. If the query uses tempdb, you might receive the following error messages:

  • Error: 5180, Severity: 22, State: 1.

    Could not open File Control Block (FCB) for invalid file ID 0 in database 'tempdb'.
  • Error: 17066, Severity: 16, State: 1.

    SQL Server Assertion: File:< Alloc.cpp>, line=2697 Failed Assertion = 'IAM_pg_id != PageId_NULL'.
  • Error: 3624, Severity: 20, State: 1.

    A system assertion check has failed. Check the SQL Server error log for details.
  • Error: 605, Severity: 21, State: 3.

    Attempt to fetch logical page (19:31824) in database 2 failed. It belongs to allocation unit 0 not to 720680216393744384. 

This issue may occur when you use one of the following features:

  • Optimistic transaction isolation levels
  • Online indexing
  • Multiple active result sets (MARS)
  • Triggers


Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.


Learn about the terminology that Microsoft uses to describe software updates.