AnsweredAssumed Answered

Load Data Warehouse job fails - DWH_CFG_PRE_CONFIG_SP

Question asked by Lukas_Jezek on Jul 28, 2016
Latest reply on Jul 28, 2016 by Nika_Hadzhikidi

Hello,

 

have you ever seen following error?

ERROR 2016-07-28 16:16:52,822 [Thread-14] dwh.event dwh_db_check_ - An error occurred executing this job entry :

Couldn't execute SQL: BEGIN

  DWH_CFG_PRE_CONFIG_SP(

    P_DBLINK => 'PPMDBLINK.WORLD',

  P_FULL_RELOAD => 'N'

);

END;

 

[CA Clarity][Oracle JDBC Driver][Oracle]ORA-06550: line 2, column 2:

PLS-00306: wrong number or types of arguments in call to 'DWH_CFG_PRE_CONFIG_SP'

ORA-06550: line 2, column 2:

PL/SQL: Statement ignored

 

I checked stored procedure and seems to have only one argument as P_DBLINK. Any ideas? DWH template was imported successfully and for the proper version of PPM.

 

thank you

Outcomes