FIX: Error 602 when you run a stored procedure repeatedly in SQL Server 2012 or SQL Server 2014

Symptoms

Assume that you use Microsoft SQL Server 2012 or SQL Server 2014. When you repeatedly run a stored procedure that retrieves data from a temporary table in a single session, you receive the following error message:
Error: 602, Severity: 21, State: 30.Could not find an entry for table or index with partition ID <partition ID> in database <database name>. This error can occur if a stored procedure references a dropped table, or metadata is corrupted. Drop and re-create the stored procedure, or execute DBCC CHECKDB.

Note This issue is more likely to occur on a system that has many CPUs, for example, a computer that has 20 CPUs.

Resolution

The issue was first fixed in the following cumulative update of SQL Server:
Recommendation: Install the latest cumulative update for SQL Server

Status

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

Vlastnosti

ID článku: 3080209 – Posledná kontrola: 19. 10. 2015 – Revízia: 1

Pripomienky