AnsweredAssumed Answered

Load DWH job fails

Question asked by CMCN1982 on Nov 29, 2016
Latest reply on Dec 6, 2016 by CMCN1982

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.

Outcomes