We are currently building notification framework to monitor Data Stream errors in Slack.
On the DataStream object we can identify records with the ImportRunStatus field having a value of FAILURE. However, we cannot find where the error message content is stored (likely a related object looking up to this DataStream)
When failures occur, the error message is visible to be previewed while on the Refresh History tab as shown in screenshot. This is the text content we are trying to find within SF schema.
According to this link: a DLO exists for Problem Records, but in Query Editor or Data Explorer cannot find nor query this DLO, for example PR_DLO_<DataStreamName> - in Query Editor we receive an Insufficient Access error. In data explorer that DLO is not able to be seen in the lookup.
Has anyone else managed to find where this error message is stored?
Thanks in advance!
Confirming unfortunately the explicit fieldname instead of wildcard also doesn't make a difference