Clarity PPM

Expand all | Collapse all

Load Data Warehouse job fails - DWH_CFG_PRE_CONFIG_SP

Jump to Best Answer
  • 1.  Load Data Warehouse job fails - DWH_CFG_PRE_CONFIG_SP

    Posted 07-28-2016 10:25 AM



    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



      P_FULL_RELOAD => 'N'




    [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

  • 2.  Re: Load Data Warehouse job fails - DWH_CFG_PRE_CONFIG_SP
    Best Answer

    Posted 07-28-2016 04:32 PM

    Hi Lukas,


    The error you hit is a known issue when there is a database mismatch with Data Warehouse. It usually happens when there is a mismatch between the database version and the application version, such a patch.

    To fix the issue, please run the following command on the CA PPM application server:

    admin db dwh-upgrade -Dupgrade.phase=maintenance


    This will bring the DWH database to the correct schema needed for the Data Warehouse to execute.


    I hope this helps -Nika