Hi,
we have completed the dwh and jaspersoft installation and configurations. Both show as 'Available' in the CSA.
When I run the query to see if my dblink is set up correctly, data is returned.
So, when the time came to run the load dwh job it fails almost immediately.
In the bg-dwh.log file I see:
INFO 2016-11-29 11:28:51,740 [Thread-14] dwh.event dwh_etl_master - Start of job execution
ERROR 2016-11-29 11:28:52,398 [Thread-14] dwh.event 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.
INFO 2016-11-29 11:28:52,406 [Thread-14] dwh.event dwh_etl_master - Job execution finished
ERROR 2016-11-29 11:28:52,437 [Dispatch Load Data Warehouse : bg@Server (tenant=clarity)] dwh.event ETL Job Failed. Log details below:
2016/11/29 11:28:52 - dwh_db_check_ - ERROR (version 5.0.2, build 1 from 2013-12-04_15-52-25 by buildguy) : An error occurred executing this job entry :
2016/11/29 11:28:52 - dwh_db_check_ - Couldn't execute SQL: EXEC DWH_CFG_PRE_CONFIG_SP 'PPMDBLINK.niku.niku', 'Y'
2016/11/29 11:28:52 - dwh_db_check_ -
2016/11/29 11:28:52 - dwh_db_check_ - [CA Clarity][SQLServer JDBC Driver][SQLServer]Procedure or function DWH_CFG_PRE_CONFIG_SP has too many arguments specified.
null
on the application front end I see:
"Financial plans has invalid start or end periods."
Can anyone please advise? Thanks.