FIX: Error 17066 occurs during the encryption operation when you use TDE in SQL Server 2012

Symptoms

Assume that you set a database to use transparent data encryption (TDE) in Microsoft SQL Server 2012. In a rare case, during the encryption operation, you receive the following error messages in the SQL Server error log:
Error: 17066, Severity: 16, State: 1.

SQL Server Assertion: File:< lckmgr.cpp>, line=9506 Failed Assertion = 'removedEntry != NULL'. This error may be timing-related. If the error persists after rerunning the statement, use DBCC CHECKDB to check the database for structural integrity, or restart the server to ensure in-memory data structures are not corrupted.

* Non-yielding Scheduler

Process 19:0:1 (0x12b4) Worker 0x00000000054DA160 appears to be non-yielding on Scheduler 31. Thread creation time: 13076246206261. Approx Thread CPU Used: kernel 0 ms, user 51402 ms. Process Utilization 31%. System Idle 66%. Interval: 70448 ms.
When this error occurs, you have to restart SQL Server.

Resolution

Cumulative Update information

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.
Ιδιότητες

Αναγνωριστικό άρθρου: 3103293 - Τελευταία αναθεώρηση: 18 Νοε 2015 - Αναθεώρηση: 1

Σχόλια