We have installed CA PPM 15.2 Patch 01( Version: 184.108.40.206 01 39). When we set the Entity for Fiscal Periods of Data Warehouse Option in System Option, we received the error: System error. Contact system administrator.
Error in logfile:Caused by: java.sql.SQLException: [CA Clarity][Oracle JDBC Driver][Oracle]ORA-04063: package body "NIKU_IDA.CRV_SQL_CURVE_PKG" has errorsORA-06508: PL/SQL: could not find program unit being called: "NIKU_IDA.CRV_SQL_CURVE_PKG"
We found that the TYPE CRV_PREIOD and CRV_SLICE are being used with one additional column group_by and these type definiations don't have that column.
Package compilation the error:
Error(910,32): PLS-00306: wrong number or types of arguments in call to 'CRV_PERIOD'Line 910 in CRV_SQL_CURVE_PKG v_calendar(idx) := CRV_PERIOD( v_period, v_start, v_temp_date, DATE_TO_JULIAN( v_start ), DATE_TO_JULIAN( v_temp_date ), v_period_type, v_calendar_key, v_conversion, v_group_by ); If we see the CRV_PERIOD definition, it doesn't have group by columnCREATE OR REPLACE TYPE "CRV_PERIOD" FORCEAS OBJECT ( PERIOD NUMBER, START_DATE DATE, FINISH_DATE DATE, JULIAN_START INTEGER, JULIAN_FINISH INTEGER, PERIOD_NAME VARCHAR2(32), CALENDAR_KEY VARCHAR(20) NULL, FTE_CONVERSION NUMBER );
better to compile clarity and DWH schema after installed clarity 15.1 and try to configure system settings. This will help to recompile invalid database object after restoration.
admin compile db
admin db compile -Ddb.id=Datawarehouse
CA Support suggested rebuild the Data Warehouse using below command, that resolved the issue.
Am not sure why do we need to rebuild for new installations too
admin db dwh-upgrade -Dupgrade.phase=maintenance
The only reason i can think of rebuilding is if your DWH upgrade during patch 1 of 15.1 has gone wrong, do you have the install log where I can take a look.
There were no errors in patch01 installation. please find the attached install.log
Running this command resolved the issue - admin db dwh-upgrade -Dupgrade.phase=maintenance
Seems like this is happening because application is not going to support the user called "NIKU_IDA". Can you please drop this user, and use another one? I guess that will be helpful.
Can you please check the date format set in the database for PPM as well as DWH? There is an existing thread on this same topic Load Data Warehouse Job fails
Some of the DB objects may not be compiled when you restoring the Database dump. For best practice, better to recompile the database objects after restoration has completed.