ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

Load Data Warehouse Job Fails With Error ORA-04063

book

Article ID: 217630

calendar_today

Updated On:

Products

Clarity PPM SaaS Clarity PPM On Premise

Issue/Introduction

The following error appears in the bg-dwh.log

[CA Clarity][Oracle JDBC Driver][Oracle]ORA-04063: package body "NIKU.CRV_SQL_CURVE_PKG" has errors
ORA-06508: PL/SQL: could not find program unit being called: "NIKU.CRV_SQL_CURVE_PKG"
ORA-06512: at "NIKU.CRV_CALENDAR_FCT", line 7
ORA-06512: at line 1
ORA-06512: at "NIKU.RPT_CALENDAR_SP", line 85
ORA-06512: at line 2

Environment

All

Resolution

Have DBA team run the following command:

ALTER PACKAGE CRV_SQL_CURVE_PKG COMPILE;