Location of Errors and Warnings Messages

  • 2 June 2022
  • 1 reply

Dear Community
If I'm clicking on Report->Errors or Warnings then I see a fulll list of them. Where are those records stored? In which table can I find them ?

My problem is that once forgot to check the "Error" manually, therefore I want to create a script which regularly should check if errors exists.

But wo far, I couldn't the table/view/place where this Infos are stored.

Any ideas?






Best answer by JTreadwell 2 June 2022, 22:11

View original

1 reply

Userlevel 3
Badge +5

Hi Alex, Great question. This data is stored in the Targe Database in the <TableName>_L and <TableName>_M tables. 

  1. The List Table (_L) - Holds the list of all DW_IDs of rows in the raw table that were flagged by a data validation rule.
  2. The Messages Table (_M) - Includes a description of why each record in the List table was flagged.

Hope that helps!