Error message when running Data Warehouse - Full Load: Procedure or function DWH_CFG_PRE_CONFIG_SP has too many arguments specified.

Document ID : KB000125302
Last Modified Date : 25/01/2019
Show Technical Document Details
Issue:
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.
 
Cause:
Environmental version mismatch
Resolution:
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