Datamart Rollup - Time Facts and Time Summary job fails with error ORA-12801: error signaled in parallel query server P03K

book

Article ID: 142260

calendar_today

Updated On:

Products

STARTER PACK-CLARITY PPM Clarity PPM SaaS

Issue/Introduction

A scheduled run of Datamart Rollup -Time Facts and Time Summary fails with error similar to below: 


ERROR 2019-12-15 22:00:09,323 [Dispatch Datamart Rollup -Time Facts and Time Summary) : xxxxxxxxx(tenant=clarity)] niku.njs(clarity:admin:12906893__678C0430-957E-428C-A22B-BC3E5B534E2F:Datamart Rollup -Time Facts and Time Summary) Error executing job:5008002 error java.sql.SQLException: [CA Clarity][Oracle JDBCDriver][Oracle]ORA-20000: Error in CMN_JOB_DATAMART_ROLLUP_SP - ORA-20000:Error in NBI_EXTRACT_TF_TS_SP - Analyzing NBI_PM_PT_FACTS: ORA-20011:Approximate NDV failed: ORA-12801: error signaled in parallel query server P03K
ORA-27090: Unable to reserve kernel resources forasynchronous disk I/O
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
Additional information: 128
Additional information: 139639241039526
ORA-06512: at "CLARITY.CMN_JOB_DATAMART_ROLLUP_SP",line 11
ORA-06512: at line 1

Environment

Release : All supported Clarity releases

Resolution

This is a database server issue. Engage the DBA team to resolve this by increasing the kernel resource value for accessing the parallel I/O.