Anonymize PII job fails on Conversations

Products

• Clarity PPM On Premise
• Clarity PPM SaaS

Issue/Introduction

The Anonymize PII job fails with the following error:

PPM Tables (O) - An error occurred executing this job entry : 

Couldn't execute SQL: BEGIN

COP_PII_ANONYMIZE_SP(

    P_JOB_RUN_ID => 0,

P_JOB_USER_ID => 0,

P_ANONYMIZE_RESOURCE => '1',

P_ANONYMIZE_ALL => '0',

    P_DBLINK_COUNT => 511.0);

END;

 

ORA-20100: ENCOUNTERED EXCEPTION WHILE PROCESSING NMC_CONVERSATIONS. SQLERRM : ORA-30926: unable to get a stable set of rows in the source tab.

Environment

Release : 16.0.x, 16.1.x

Resolution

DE69220, fixed in 16.1.2

Using the SP from 16.1.2 will help workaround the issue. 

Workaround:

1. Run the SQL of the updated in 16.1.2 stored procedure COP_PII_ANONYMIZE_SP (attached below),
2. Recompile it
3. Run the job again