Skip to main content

Tracking Non Conformant Data (KBA1830)





This topic has been Retired and moved to Documentation: Monitoring Masking Job


Applicable Delphix Versions 

Major Release

All Sub Releases


Tracking Nonconforming Data in the Masking Monitor page

Starting version, a report on Non Conformant data can be found on the Monitoring Page. This applies to specific algorithms where the data need to match the format or pattern in order to be masked mask. If data does not match the required format - it stays unchanged (which might or might not fail the masking job, depending on the job settings). 

When nonconforming data is detected, a warning triangle is set in the Masking Job status UI ( and a report is available via Masking Monitor page.

The warning triangle (Warning .png) is shown on the following pages: 

  • Job Overview Page


  • Job Monitoring Page


Accessing the Nonconforming Data Report
If Nonconforming data was detected, the report can be accessed using these steps:
  1. Navigate to the Delphix Masking application.
  2. Select Monitor tab.
    This opens the Monitor page.
  3.  Select Tables with Nonconforming Data field.
    If value of the field is greater than zero, a (yellow) warning icon is displayed in the Completed section against the row for affected table.
  4. Click on the Warning icon Warning .png in the Completed section.
    This opens the report providing details.


  1. In the Description for the NONCONFORMING DATA, you might find the top most non conforming data samples (i.e. not all, but first few).

Interpreting the report 

Using the example depicted above, the top most nonconforming data samples are:

  • NNNN

Each character in the non conforming data is sampled as follows as per Unicode Character Property.

  • N for digits
  • L for letters
  • M for marks
  • P for punctuation
  • S for symbols
  • Z for separator
  • O for other
  • U for unknown

You can track down the non conforming data using the samples, based on unicode character properties, depending on specific data source type support of regular expressions. 

In the above example the data source is Oracle DB. From the report above we can find table name - PHONE, and column name PHONE_MASK.


Below are the Oracle character classes, used in the regular expression:


All alphanumeric characters


All alphabetic characters


All blank space characters.


All control characters (nonprinting)


All numeric digits


All [:punct:], [:upper:], [:lower:], and [:digit:] characters.


All lowercase alphabetic characters


All printable characters


All punctuation characters


All space characters (nonprinting)


All uppercase alphabetic characters


All valid hexadecimal characters


For the sample in the example above LLLLZLLLZLLLL, the Oracle DB SQL query would look like:




This query will return the occurrences of `PHONE_MASK` column in the `PHONE` table, corresponding to the `LLLLZLLLZLLLL` pattern.

Related Documentation





 The pattern might be not an exact representation of the field data, but the part of the data. Sometimes white spaces in the beginning or at the end of the data field might be truncated.