When running Load Data Warehouse - Full Load, it fails with error:
dwh_db_check_ - An error occurred executing this job entry :
Couldn't execute SQL: EXEC DWH_CFG_PRE_CONFIG_SP 'PPMDBLINK.niku.niku', 'Y'
[CA Clarity][SQLServer JDBC Driver][SQLServer]Procedure or function DWH_CFG_PRE_CONFIG_SP has too many arguments specified.
Environmental version mismatch
Check the version between PPM and DWH by running the queries:
On Niku database:
select * from cmn_install_history order by installed_date
On DWH database:
select * from cmn_dwh_install_history order by installed_date
See if the patch level is the same between PPM and DWH.
If patch level is higher on the PPM side:
1. Run the command:
admin db dwh-upgrade -Dupgrade.phase=maintenance
2. Run Load Data Warehouse - Full
If patch level is higher on DWH side:
1. Restore a new DWH backup
2. Recreate the DBLINK
3. Run Load Data Warehouse - Full