PII Audit Scan unable to detect PII in Oracle CLOB

book

Article ID: 141185

calendar_today

Updated On:

Products

CA Test Data Manager (Data Finder / Grid Tools)

Issue/Introduction

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

Environment

Release : 4.8.1

Component : CA Test Data Manager - TDM Web Portal

Resolution

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.