Edit

sys.dm_pdw_errors (Transact-SQL)

  • Article

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

Holds information about all errors encountered during execution of a request or query in Azure Synapse Analytics dedicated SQL pools and Analytics Platform System (PDW).

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 more information on node IDs, see sys.dm_pdw_nodes (Transact-SQL).
session_id nvarchar(32) Identifier of the session involved, if any. For more information on session IDs, see sys.dm_pdw_exec_sessions (Transact-SQL).
request_id nvarchar(32) Identifier of the request involved, if any. For more information on request IDs, see sys.dm_pdw_exec_requests (Transact-SQL). This request_id can be corresponded with the request_id in sys.dm_pdw_exec_requests
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 Capacity limits.

Related content