SQL Server Errors or Failures from Error: 40138 to Error: 40161


Error: 40138, Severity: 16, Query references entities from multiple partitions.

Error: 40139, Severity: 16, The data node does not host a replica of the requested partition.
Error: 40140, Severity: 16, Set partition failed since a different partition already was set in the current transaction.
Error: 40141, Severity: 16, Partition has to be set using sp_set_partition before executing this query.
Error: 40142, Severity: 16, Accessing a different partition in the same transaction is not allowed.
Error: 40143, Severity: 16, The replica that the data node hosts for the requested partition is not primary.

Error: 40144, Severity: 16, Cannot find the object “%.*ls” because it does not exist or you do not have permissions.
Error: 40145, Severity: 16, Database is not found.
Error: 40146, Severity: 16, Table group object is not found.
Error: 40147, Severity: 16, Stored procedure ‘%.*ls’ is only for CloudDB.
Error: 40148, Severity: 16, The existing persisted queue snapshot CSN (%d, %I64d) at %S_LSN is greater than the requested snapshot CSN (%d, %I64d) at %S_LSN.
Error: 40149, Severity: 16, The database does not host any partitions.
Error: 40151, Severity: 16, Partition is in transactionally inconsistent state.
Error: 40152, Severity: 16, Partition delete expects no context transaction.

Error: 40153, Severity: 16, The current database has been shutdown. The current database has been switched to master.
Error: 40157, Severity: 16, Too many secondaries. At most 32 are currently supported.
Error: 40158, Severity: 16, Could not change database collation for database id %d.
Error: 40159, Severity: 16, Database scoping cannot be run inside a transaction.
Error: 40160, Severity: 16, Heartbeat message version mismatch. Actual version is %d and the expected is %d.
Error: 40161, Severity: 16, Invalid partition type. Only 1 or 2 is supported.

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.

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 *