Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
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 | Session ID 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.