Resolve DataChecker error/warning

email subject ERROR: analytics.tiger.agents.DataChecker

Use enclosed query to find violations.

Example:

SELECT
        table_name,
        ora_err_mesg$,
        COUNT(*)n_incidents,
        concat_string_csv('(' || DATA || ')') incidents
FROM
        (SELECT 'slxre2_pagg_library' table_name, a.ora_err_mesg$, a.project ||',' || a.SAMPLE ||',' || a.LIBRARY ||',' || a.data_type data
        FROM err$_slxre2_pagg_library a WHERE a.resolution_timestamp IS NULL
        UNION ALL
        SELECT 'slxre2_pagg_sample', a.ora_err_mesg$, a.project ||',' || a.SAMPLE ||',' || a.data_type data
        FROM err$_slxre2_pagg_sample a WHERE a.resolution_timestamp IS NULL
        UNION ALL
        SELECT 'slxre2_library_agg_qc' table_name, a.ora_err_mesg$, a.project ||',' || a.SAMPLE ||',' || a.LIBRARY ||',' || a.data_type data
        FROM err$_slxre2_library_agg_qc a WHERE a.resolution_timestamp IS NULL
        UNION ALL
        SELECT 'slxre2_sample_agg_qc', a.ora_err_mesg$, a.project ||',' || a.SAMPLE ||',' || a.data_type data
        FROM err$_slxre2_sample_agg_qc a WHERE a.resolution_timestamp IS NULL
        )
GROUP BY table_name, ora_err_mesg$

Find and watch automatically created PO ticket by searching for sample alias(s) in https://broadinstitute.atlassian.net/browse/PO Cloud Jira.

Once PO ticket is resolved, check datamarts for valid records.

To clear DataChecker warning emails, update corresponding resolution_timestamp fields.

Example

UPDATE err$_slxre2_pagg_sample   
SET resolution_timestamp = SYSDATE
where resolution_timestamp IS NULL