Load DWH DWH_CFG_PRE_CONFIG_SP has too many arguments specified.

Products

• Clarity PPM SaaS
• Clarity PPM On Premise

Issue/Introduction

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.
 

Environment

Release: 15.4.1,15.5
Component:

Cause

Environmental version mismatch

Resolution

Check the version between Clarity and DWH by running the queries:

On Clarity 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 Clarity 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:
3. Restore a new DWH backup
4. Recreate the DBLINK
5. Run Load Data Warehouse - Full