sys.dm_exec_compute_node_errors (Transact-SQL)

APPLIES TO: yesSQL Server 2016 and later noAzure SQL Database yesAzure Synapse Analytics (SQL DW) yesParallel Data Warehouse

Returns errors that occur on PolyBase compute nodes.

Column Name Data Type Description Range
error_id nvarchar(36) Unique numeric id associated with the error . Unique across all query errors in the system
source nvarchar(255) Source thread or process description
type nvarchar(255) Type of error.
create_time datetime The time of the error occurrence
compute_node_id int Identifier of the specific compute node See compute_node_id of sys.dm_exec_compute_nodes (Transact-SQL)
rexecution_id nvarchar(36) Identifier of the PolyBase query, if any.
spid int Identifier of the SQL Server session
thread_id int Numeric identifier of the thread on which the error occurred.
details nvarchar(4000) Full description of the details of the error.
compute_pool_id int Unique identifier for the pool.

See Also

PolyBase troubleshooting with dynamic management views
Dynamic Management Views and Functions (Transact-SQL)
Database Related Dynamic Management Views (Transact-SQL)