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

book

Article ID: 125302

calendar_today

Updated On:

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.
 

Cause

Environmental version mismatch

Environment

Release: CODFSS99000-15.4.1-PPM SAAS FedRAMP-Sandbox-Small Environment
Component:

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