Load DWH job fails with Oracle error

Products

• Clarity PPM On Premise
• Clarity PPM SaaS

Issue/Introduction

The Load DWH job fails with the following error:

ORA-20011: Approximate NDV failed: ORA-12805: parallel query server died unexpectedly
ORA-06512: at "SYS.DBMS_STATS", line 40799
ORA-06512: at "SYS.DBMS_STATS", line 40083
ORA-06512: at "SYS.DBMS_STATS", line 38960
ORA-06512: at "SYS.DBMS_STATS", line 37135
ORA-06512: at "SYS.DBMS_STATS", line 35017
ORA-06512: at "SYS.DBMS_STATS", line 34997
ORA-06512: at "SYS.DBMS_STATS", line 36699
ORA-06512: at "SYS.DBMS_STATS", line 38784
ORA-06512: at "SYS.DBMS_STATS", line 39786
ORA-06512: at "SYS.DBMS_STATS", line 40231
ORA-06512: at "SYS.DBMS_STATS", line 40780
ORA-06512: at "PPM_DWH.CMN_GATHER_TABLE_STATS_SP", line 16
ORA-06512: at line 5

Environment

Release : Any, with Oracle

Resolution

• This is an Oracle error not related to Clarity
• We recommend engaging your DBA to look into this
  • Here is Oracle KB for info
  • Things for them to look into:
    • What is the value for parallel_degree_policy
    • Any errors in Oracle logs
• We recommend the DBA raising an Oracle Support case if this doesn't help