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

    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



  • 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