We are facing issue with the Anonymize Personally Identifiable Information (PII) job. It fails on the lower QA environment. The job fails with a certain error in the logs but the resource data appears to be anonymzed. The job failure may leave traces of data not being anonymized.
Error as per bg log:
Oracle? - An error occurred executing this job entry : Couldn't execute SQL: BEGINDWH_PII_ANONYMIZE_SP( P_DBLINK => 'CLARITYDBLINK', P_JOB_RUN_ID => 0, P_JOB_USER_ID => 0, P_ANONYMIZE_RESOURCE => '1', P_ANONYMIZE_ALL => '0');END;[CA Clarity][Oracle JDBC Driver][Oracle]ORA-20100: ENCOUNTERED EXCEPTION WHILE PROCESSING DWH_TRD_RES_RESOURCE. SQLERRM : ORA-03150: end-of-file on communication channel for database linkORA-06512: at "PPM_DWH.DWH_PII_ANONYMIZE_SP", line 89ORA-06512: at line 2
There is an issue with the DBLINK.
DBLINK needs to be working well, the PII job needs Datawarehouse setup in-order to anonymize data in DWH schema.