staging_error_log
- Last UpdatedDec 05, 2024
- 1 minute read
The Staging_Error_Log table contains curated events from the MES database that failed to be pushed to CONNECT data services.
AVEVA Events to CONNECT will retry intermittent failures which will not be recorded in this table. This table holds failures that cannot be retried automatically as well as the failures that were retried by the adaptor and failed.
|
Field |
Data type |
PK |
Nulls? |
Description |
|---|---|---|---|---|
|
created_at_utc |
tdatetime |
N |
N |
Identifies the time when this event was created in this table. |
|
staging_type_id |
string80 |
N |
N |
Identifies the type of curated event. For example, MESMaterialProducedActual (ItemProd), Asset (Ent), MESMaterialClass (ItemClass), etc. |
|
type_action |
string40 |
N |
N |
Identifies the action of this event performed on the MES database. For example, create (insert or update), or delete. |
|
response_content |
varbinary |
N |
N |
Contains the entire response content that failed when processing to CONNECT data services. This includes the CONNECT response, the actual data, agent response, etc. |
|
error_msg |
notes |
N |
N |
Contains the error message that failed when pushing this data to CONNECT data services. The HTTP error information is extracted from the entire response content and stored in the error message for quick reference. |
|
status |
int32 |
N |
N |
The status of the event data after being failed when submitted to CONNECT data services: 0 – Original event failed (default) 1 – Edited, but not resubmitted 2 – Ready to be reprocessed 3 – Resubmitted |
|
last_edit_by |
string40 |
N |
Y |
Identifies the user who last created this data. |
|
last_edit_at |
tdatetime |
N |
N |
Identifies the date and time the record was last changed. |
|
row_id |
bigint64 |
Y |
N |
The unique row identifier. This field is maintained for audit purposes. |