Skip to main content
To homepage To homepage
Solved

Location of Errors and Warnings Messages

  • June 2, 2022
  • 1 reply
  • 54 views
A
Starter

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?

 

Regards

Alex

 

Best answer by JTreadwell

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!

 

View original
    Did this topic help you find an answer to your question?

    1 reply

    JTreadwell
    Employee
    Forum|alt.badge.img+5
    • JTreadwell
    • Employee
    • 179 replies
    • Answer
    • June 2, 2022

    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!

     

    -Joseph Treadwell

    Reply


    Most helpful members this week

    Terms and ConditionsCookie settings

    Cookie policy

    We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

     
    Cookie settings