SQL Server Errors or Failures from Error: 8527 to Error: 8546

SQLServerF1

 

Error: 8527, Severity: 16, An attempt to create a distributed transaction export token failed with this error: %ls. Contact your Microsoft Distributed Transaction Coordinator (MS DTC) system administrator.
Error: 8528, Severity: 16, The commit of the Kernel Transaction Manager (KTM) transaction failed: %d.
Error: 8529, Severity: 16, Unable to extract the Kernel Transaction Manager (KTM) transaction handle from the Microsoft Distributed Transaction Coordinator (MS DTC) transaction: 0x%x.
Error: 8530, Severity: 16, The Windows kernel transaction manager creation failed: 0x%x.

Error: 8531, Severity: 16, The Windows kernel transaction manager failed to create the enlistment: 0x%08x.
Error: 8532, Severity: 20, Error while reading resource manager notification from Kernel Transaction Manager (KTM): %d.
Error: 8533, Severity: 20, Error while waiting for communication from Kernel Transaction Manager (KTM): %d.
Error: 8534, Severity: 21, The KTM RM for this database, %ls, failed to start: %d.
Error: 8535, Severity: 16, A savepoint operation in the Windows transactional file system failed: 0x%x.
Error: 8536, Severity: 16, Only single DB updates are allowed with FILESTREAM operations.

Error: 8537, Severity: 16, This transaction was aborted by Kernel Transaction Manager (KTM).
Error: 8538, Severity: 16, The current isolation level is not supported by the FILESTREAM 0x%x.
Error: 8539, Severity: 10, The distributed transaction with UOW %ls was forced to commit. MS DTC became temporarily unavailable and forced heuristic resolution of the transaction. This is an informational message only. No user action is required.
Error: 8540, Severity: 10, The distributed transaction with UOW %ls was forced to rollback.
Error: 8541, Severity: 10, System process ID %d tried to terminate the distributed transaction with Unit of Work ID %ls. This message occurs when the client executes a KILL statement on the distributed transaction.
Error: 8542, Severity: 10, Spid %d tried to commit the distributed transaction with UOW %ls.
Error: 8543, Severity: 10, Unable to commit a prepared transaction from the Microsoft Distributed Transaction Coordinator (MS DTC). Shutting down server to initiate resource manager (RM) recovery. When the RM recovers, it will query the transaction manager about the outcome of the
Error: 8544, Severity: 10, Unknown status of commit of a two-phase commit transaction. Shutting down server. Restart server to complete recovery.
Error: 8545, Severity: 10, Unknown status ‘%d’ from Reenlist call in rm_resolve.
Error: 8546, Severity: 10, Unable to load Microsoft Distributed Transaction Coordinator (MS DTC) library. This error indicates that MS DTC is not installed. Install MS DTC to proceed.

This is applicable on below versions of SQL Server

SQL Server 2005
SQL Server 2008 R2
SQL Server 2012
SQL Server 2014

Hope this was helpful.

Thanks,
SQLServerF1 Team
In-Depth Blogs on SQL Server, Information about SQL Server Conferences and Events, SQL Server Frequently asked questions, SQL Server Trainings.

 

Leave a Reply

Your email address will not be published. Required fields are marked *