Rate Matrix extraction on Large Dataset Fails with ORA-01403: no data found

Products

• Clarity PPM SaaS
• Clarity PPM On Premise

Issue/Introduction

The Rate Matrix Extraction job intermittently fails with the following error:

ORA-20000: Error in CMN_JOB_RATE_MATRIX_SP - ORA-20000: Error in NBI_PROJ_RATES_AND_COSTS_SP - Calling PPA_GETRATE_WITHROLE: ORA-01403: no data found

Environment

Release: CODCVU9900-14.3-PPM SAAS-View Only Userpack for-Canadian Government Entities
Component:

Cause

Caused by DE33410

Resolution

DE33410 has been fixed in PPM 15.3 and later releases. 

For assistance with a workaround on an affected version, please contact CA Technical Support.