sys.dm_pdw_errors (Transact-SQL)

Applies to: Azure Synapse Analytics Analytics Platform System (PDW)

Holds information about all errors encountered during execution of a request or query.

Note

This syntax is not supported by serverless SQL pool in Azure Synapse Analytics.

Column Name	Data Type	Description	Range
error_id	nvarchar(36)	Key for this view. Unique numeric id associated with the error.	Unique across all query errors in the system.
source	nvarchar(64)	Information not available.	Information not available.
type	nvarchar(4000)	Type of error that occurred.	Information not available.
create_time	datetime	Time at which the error occurred.	Smaller or equal to current time.
pwd_node_id	int	Identifier of the specific node involved, if any. For additional information on node ids, see sys.dm_pdw_nodes (Transact-SQL).
session_id	nvarchar(32)	Identifier of the session involved, if any. For additional information on session ids, see sys.dm_pdw_exec_sessions (Transact-SQL).
request_id	nvarchar(32)	Identifier of the request involved, if any. For additional information on request ids, see sys.dm_pdw_exec_requests (Transact-SQL).
spid	int	spid of the SQL Server session involved, if any.
thread_id	int	Information not available.
details	nvarchar(4000)	Holds the full error text description.

For information about the maximum rows retained by this view, see the Metadata section in the Capacity limits topic.

See Also