SQL Server Errors or Failures from Error: 40162 to Error: 40186

SQLServerF1

Error: 40162, Severity: 16, The replica that the data node hosts for the requested partition is not transactionally consistent.

Error: 40163, Severity: 16, Become nothing expects no context transaction.
Error: 40166, Severity: 16, A CloudDB reconfiguration is going on and all new user transactions are aborted.
Error: 40167, Severity: 21, A paired CloudDB fabric node failed and database %d must be shutdown.
Error: 40170, Severity: 16, Catchup of secondary at %s:%s:%s:%d has failed.

Error: 40171, Severity: 16, Table group name (single part name) should not be longer than nvarchar(64).
Error: 40172, Severity: 16, The partition is not in a state that allows deletion.
Error: 40173, Severity: 16, This requested operation can not performed as this partition is in delete process.
Error: 40174, Severity: 16, The partition is in transition and transactions are being terminated.
Error: 40175, Severity: 16, Add a secondary with wait can not be used in a transaction.
Error: 40176, Severity: 16, Rename a partition can not be used in a transaction.

Error: 40177, Severity: 16, The new table group does not match the existing table group for the renaming partition.
Error: 40178, Severity: 16, A partition with same name already exists.
Error: 40179, Severity: 16, Fabric-database (‘%.*ls’) cannot be paired, the monitor thread is not running.
Error: 40180, Severity: 16, Fabric-database (‘%.*ls’) cannot be paired, the database is already paired.
Error: 40181, Severity: 16, Fabric-database (‘%.*ls’) cannot be paired, the supplied mutex (‘%.*ls’) could not be opened. Error code: %d
Error: 40182, Severity: 16, The schema scope %ld being created is not empty.
Error: 40183, Severity: 16, Could not create database side pairing mutex for database (‘%.*ls’). Error code: %d
Error: 40185, Severity: 16, Secondary failure report expects no context transaction.
Error: 40186, Severity: 16, The data node does not host a replica of the requested partition with the requested version.

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 *