PII Audit Scan unable to detect PII in Oracle CLOB


Article ID: 141185


Updated On:


CA Test Data Manager (Data Finder / Grid Tools)


When scanning an Oracle 12c table containing a CLOB column, an embedded XML that contains PII information will not be identified as PII


Release : 4.8.1

Component : CA Test Data Manager - TDM Web Portal


Engineering reviewed the issue and determined this scenario is not supported.

The Sustaining Engineer confirmation in the code that CLOB columns (and similar column types like BLOB, BINARY, VARBINARY and so on) are ignored on purpose during PII scan - however, only their content, column name will still be tested for PII data.

According to comments in the code it's because we used sampling technique (the process of choosing randomly only part of all rows) is not compatible with such columns. So technically, it really isn't supported scenario, scanning CLOB field itself is unsupported.