SALES: 1-800-867-1380
Expand Minimize

sys.dm_federation_operation_errors (Azure SQL Database)

Updated: April 24, 2014

This topic is OBSOLETE. You can find the most current version in the SQL 14 Transact-SQL Reference. See sys.dm_federation_operation_errors.

ImportantImportant
The current implementation of Federations will be retired with Web and Business service tiers.  Consider deploying custom sharding solutions to maximize scalability, flexibility, and performance.  For more information about custom sharding, see Scaling Out Azure SQL Databases.

Returns rows containing information on errors that occur during SPLIT or DROP federation operations. The sys.dm_federation_operations_errors view is specific to Microsoft Azure SQL Database and is not supported in on-premises SQL Server.

The sys.dm_federation_operations_errors view contains the following fields:

 

Columns Data Type Description

federation_operation_id

uniqueidentifier

federation_operation_type

nvarchar(60)

Federation operation description (SPLIT or DROP)

federation_id

int

The target federation_id for the federation operation.

federation_name

sysname

Name of the federation for the given federation_id.

start_date

datetimeoffset

The UTC time when the operation was initiated.

last_modify_date

datetimeoffset

The UTC time when information on the federation operation was last updated.

percent_complete

real

The percentage of rows that have been copied when the error occurred.

Values range from 0 to 100.

error_code

int

The code indicating the error that has occurred.

error_desc

nvarchar(4000)

Description of the error that occurred.

error_severity

int

Returns 16 if the operation failed.

error_state

int

Returns 1 if the operation failed

You must be connected to the database used to start the federation operation, and you must have VIEW DATABASE STATE permissions.

For federation operations that complete successfully, all data about the operation disappears from sys.dm_federation_operations (Azure SQL Database) and sys.dm_federation_operation_members (Azure SQL Database) views. If an error is encountered during a federation operation and the operation is unsuccessful due to the error, the rows are copied from sys.dm_federation_operations and sys.dm_federation_operation_members to sys.dm_federation_operation_errors (Azure SQL Database) and sys.dm_federation_operation_error_members (Azure SQL Database).

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft