We just started testing this job. The Anonymize PII job is getting completed successfully and even anonymizing the default fields. But it is not clearing the APII flag and the PII Last Updated Date is not getting populated. What could be the reason for this?
We are not using Data Warehouse.
Release : 15x
Component : CA PPM DATA WAREHOUSE
According to the code of SP COP_PII_ANONYMIZE_SP the fields will only update if the parameter p_dblink_count = 0, this is the DBLINK parameter and it's likely passing a wrong value.
Looks like in the logic it's checking in table DWH_CFG_AUDIT if there is data there and sets the variable / parameter p_dblink based on that.
Can you please connect to the Data Warehouse database and run:
SELECT COUNT(*)
FROM DWH_CFG_AUDIT
Load Data Warehouse job populates this table. My guess is that since you're not using Data Warehouse but have some of it set up, it's getting confused. We can either remove the data or fully configure Data Warehouse to get past this.
Please try truncating DWH_CFG_AUDIT table and running PII job after that. This should resolve the issue, and it will be safe provided Data Warehouse is not getting used.