| title | description | author | ms.author | ms.date | ms.service | ms.subservice | ms.topic | dev_langs | monikerRange | |
|---|---|---|---|---|---|---|---|---|---|---|
sys.dm_pdw_errors (Transact-SQL) |
sys.dm_pdw_errors 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). |
WilliamDAssafMSFT |
wiassaf |
04/23/2024 |
sql |
data-warehouse |
reference |
|
>=aps-pdw-2016||=azure-sqldw-latest |
[!INCLUDE applies-to-version/asa-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
[!INCLUDE synapse-analytics-od-unsupported-syntax]
| 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) | [!INCLUDE ssInfoNA] | [!INCLUDE ssInfoNA] |
type |
nvarchar(4000) | Type of error that occurred. | [!INCLUDE ssInfoNA] |
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 | [!INCLUDE ssInfoNA] | |
details |
nvarchar(4000) | Holds the full error text description. |
For information about the maximum rows retained by this view, see Capacity limits.