have you ever seen following error?
ERROR 2016-07-28 16:16:52,822 [Thread-14] dwh.event dwh_db_check_ - An error occurred executing this job entry :
Couldn't execute SQL: BEGIN
P_DBLINK => 'PPMDBLINK.WORLD',
P_FULL_RELOAD => 'N'
[CA Clarity][Oracle JDBC Driver][Oracle]ORA-06550: line 2, column 2:
PLS-00306: wrong number or types of arguments in call to 'DWH_CFG_PRE_CONFIG_SP'
ORA-06550: line 2, column 2:
PL/SQL: Statement ignored
I checked stored procedure and seems to have only one argument as P_DBLINK. Any ideas? DWH template was imported successfully and for the proper version of PPM.
The error you hit is a known issue when there is a database mismatch with Data Warehouse. It usually happens when there is a mismatch between the database version and the application version, such a patch.
To fix the issue, please run the following command on the CA PPM application server:
admin db dwh-upgrade -Dupgrade.phase=maintenance
This will bring the DWH database to the correct schema needed for the Data Warehouse to execute.
I hope this helps -Nika