Scheduled query error reports - Amazon Timestream

Scheduled query error reports

This section describes the format of the error reports that are generated by Timestream, when an error is encountered during the running a scheduled query.

The error reports have the following JSON format:

{ "reportId": <String>, // A unique string ID for all error reports belonging to a particular scheduled query run "errors": [ <Error>, ... ], // One or more errors }

The Error object can be one of three types:

  • Records Ingestion Errors

    { "reason": <String>, // The error message String "records": [ <Record>, ... ], // One or more rejected records ) }
  • Row Parse and Validation Errors

    { "reason": <String>, // The error message String "rawLine": <String>, // [Optional] The raw line String that is being parsed into record(s) to be ingested. This line has encountered the above-mentioned parse error. }
  • General Errors

    { "reason": <String>, // The error message }

The following is an example of an error report that was produced due to ingestion errors.

{ "reportId": "C9494AABE012D1FBC162A67EA2C18255", "errors": [ { "reason": "The record timestamp is outside the time range [2021-11-12T14:18:13.354Z, 2021-11-12T16:58:13.354Z) of the memory store.", "records": [ { "dimensions": [ { "name": "dim0", "value": "d0_1", "dimensionValueType": null }, { "name": "dim1", "value": "d1_1", "dimensionValueType": null } ], "measureName": "random_measure_value", "measureValue": "3.141592653589793", "measureValues": null, "measureValueType": "DOUBLE", "time": "1637166175635000000", "timeUnit": "NANOSECONDS", "version": null }, { "dimensions": [ { "name": "dim0", "value": "d0_2", "dimensionValueType": null }, { "name": "dim1", "value": "d1_2", "dimensionValueType": null } ], "measureName": "random_measure_value", "measureValue": "6.283185307179586", "measureValues": null, "measureValueType": "DOUBLE", "time": "1637166175636000000", "timeUnit": "NANOSECONDS", "version": null }, { "dimensions": [ { "name": "dim0", "value": "d0_3", "dimensionValueType": null }, { "name": "dim1", "value": "d1_3", "dimensionValueType": null } ], "measureName": "random_measure_value", "measureValue": "9.42477796076938", "measureValues": null, "measureValueType": "DOUBLE", "time": "1637166175637000000", "timeUnit": "NANOSECONDS", "version": null }, { "dimensions": [ { "name": "dim0", "value": "d0_4", "dimensionValueType": null }, { "name": "dim1", "value": "d1_4", "dimensionValueType": null } ], "measureName": "random_measure_value", "measureValue": "12.566370614359172", "measureValues": null, "measureValueType": "DOUBLE", "time": "1637166175638000000", "timeUnit": "NANOSECONDS", "version": null } ] } ] }