Clarity PPM

Expand all | Collapse all

Load datawarehouse job failing load access right job successfully completed

Jump to Best Answer
  • 1.  Load datawarehouse job failing load access right job successfully completed

    Posted 05-03-2016 02:48 AM
      |   view attached

    Hi All,

     

    After DWH setup, we have completed jaspersoft installation by running jobs.

    1. create and update jaspersoft job - successfully completed

    2. time slice job - completed

    3. load datawarehouse -failed (in bg-dwh log, am getting the below error)

    ERROR 2016-04-28 07:23:12,286 [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',

      P_FULL_RELOAD => 'Y'

    );

    END;

    )

    4. i tried running  load access right job. it also completed sucessfully..

     

    this issue is reporting in test environment. In our dev environment Jaspersoft implementation completed successfully.

     

    Attached bg-dwh log also. Please anyone help me to sort out the

    Thanks,

    Agin

    Attachment(s)

    zip
    bg-dwh log.txt.zip   1K 1 version


  • 2.  Re: Load datawarehouse job failing load access right job successfully completed
    Best Answer

    Posted 05-03-2016 02:59 AM

    Hi Agin,

     

    The problem looks like mismatch of CA PPM version and datawarehouse version

     

    Can you execute the below query in PPM & DWH and compare the version

     

    DWH - select * from cmn_dwh_install_history order by installed_date


    CA PPM - select * from cmn_install_history order by installed_date

     

    If the version of DWH is different then you should manually upgrade the DWH schema

     

    Enter the following command from the <install_dir>/bin directory command prompt to apply the Data Warehouse patch content:

      admin db dwh-upgrade -Dupgrade.phase=maintenance

     

    Let me know how it goes.

     

    Regards

    Suman Pramanik



  • 3.  Re: Load datawarehouse job failing load access right job successfully completed

    Posted 05-03-2016 10:06 AM

    Thanks Suman,

     

    I am not in office today. i will update you about this tomorrow.

     

    Thanks,

    Agin



  • 4.  Re: Load datawarehouse job failing load access right job successfully completed

    Posted 05-04-2016 11:12 PM

    Thanks Suman.

     

    it worked

     

    Many Thanks,

    Agin



  • 5.  Re: Load datawarehouse job failing load access right job successfully completed

    Posted 05-05-2016 01:54 AM

    Thanks Agin, request you to mark the post answered.