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 Data Explorer
This command returns a result set that includes aggregated streaming ingestion failures that occur when data is ingested using one of the streaming ingestion types.
Note
Streaming ingestion failures are grouped into buckets of short periods of time and aggregated by database, table, principal, ingestion properties, failure kind, and error code.
Gateway throttling failures will not appear in the result set of this command.
The retention period for streaming ingestion failures is 14 days.
If you have Database Admin or Database Monitor permissions, you see all failed operations. Otherwise, you only see operations that you created. For more information about permissions, see role-based access control.
| Syntax option | Description |
|---|---|
.show streamingingestion failures |
Returns aggregated streaming ingestion failures |
.show streamingingestion failures | where ... |
Returns a filtered set of streaming ingestion failures |
Learn more about syntax conventions.
| Output parameter | Type | Description |
|---|---|---|
| Database | string |
Target database of the ingestion |
| Table | string |
Target table of the ingestion |
| Principal | string |
The principal whosе credentials were used for the ingestion |
| RootActivityId | guid |
The ingestion Root Activity ID |
| IngestionProperties | dynamic |
The ingestion properties |
| Count | long |
The total count of failures in the bucket |
| FirstFailureOn | datetime |
Date/time (in UTC) of the first ingestion in the bucket |
| LastFailureOn | datetime |
Date/time (in UTC) of the last ingestion in the bucket |
| FailureKind | string |
Type of the failure (Permanent/Transient) |
| ErrorCode | string |
The error code of the failure |
| Details | string |
The details about the failure |
| Database | Table | Principal | RootActivityId | IngestionProperties | Count | FirstFailureOn | LastFailureOn | FailureKind | ErrorCode | Details |
|---|---|---|---|---|---|---|---|---|---|---|
| DB1 | Table1 | aadapp=xxxxxxxx-xxxxx-xxxx-xxxx-xxxxxxxxx | 04411033-5ffb-410f-bc6d-a24d50790a80 | { "Mapping": "Mapping_name", "Format": "Csv", "Compressed": true, "IngestionSource": "Storage" } | 2 | 2020-10-11 12:06:35.8362967 | 2020-10-11 12:06:35.8362967 | Transient | Kusto.DataNode.Exceptions.StreamingIngestionServiceException | Server error in performing streaming ingestion into xxxx : Can't determine row store for ingestion |
| DB1 | Table1 | aadapp=xxxxxxxx-xxxxx-xxxx-xxxx-xxxxxxxxx | d025b3e1-8f3d-4864-be0a-de54ce5246be | { "Mapping": null, "Format": "Csv", "Compressed": false, "IngestionSource": "Stream" } | 3 | 2020-10-11 12:07:40.8362967 | 2020-10-11 12:08:35.8362967 | Permanent | Kusto.DataNode.Exceptions.StreamingIngestionServiceException | Database metadata is unavailable. |