Load DWH job fails with Oracle error
search cancel

Load DWH job fails with Oracle error

book

Article ID: 251095

calendar_today

Updated On:

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