Clarity PPM

Expand all | Collapse all

Load Data-ware House Job Failed

  • 1.  Load Data-ware House Job Failed

    Posted 01-12-2018 03:27 PM
      |   view attached

    Hi,

     

    We are upgrading our non-production instance from ca ppm 14.2 sp11 to ca ppm 15.2 sp5. During pre-grade, we get to know that Data ware house setup is required to perform the upgrade for next level.

     

    In our current production and all non-production system we are not using DWH and Jasper Soft with CA PPM 14.2 SP11 version.  In order to full fill the requirement of pre-upgrade check, we started the setup of DWH in our non production instance with help of DBA. We followed the document suggested by CA and we were succeeded to create the DWH Schema on same CA PPM Database and created the DB Link as ppmdblink and tested the below query from ppm_dwh scream. Everything was working fine.

     

    select count(1) from [dblink].[cappm database server schema].niku.srm_resources

     

    Later in CA PPM Admin side we configured the system option and CSA as mentioned in install and upgrade guide document and everything was looking fine.

     

    We ran the time slice job and noticed the new DWH time slices in system and job ran successfully. Now, when we are executing Load data ware house job and getting the below error. The same error is appearing in bg_dwh log. There is no error in any other logs .

     

    Log Entry

    Date

    Message

    Job Started

    1/12/18 10:14 AM

    Message

    1/12/18 10:14 AM

    Executing ETL Job.

    Error

    1/12/18 10:14 AM

    dwh_db_check_ - An error occurred executing this job entry : Couldn't execute SQL: EXEC DWH_CFG_PRE_CONFIG_SP 'ppmdblink.HNA_DEV.niku', 'N' [CA Clarity][SQLServer JDBC Driver][SQLServer]Procedure or function DWH_CFG_PRE_CONFIG_SP has too many arguments specified.

    Error

    1/12/18 10:14 AM

    ETL Job Failed. Please see log bg-dwh.log for details.

    Job Completed

    1/12/18 10:14 AM

    NJS-0401: Execution of job failed.

     

    Any suggestions?

     

    Thanks,

    Shal

    Attachment(s)

    zip
    bg-dwh.log.zip   1022B 1 version


  • 2.  Re: Load Data-ware House Job Failed

    Posted 01-12-2018 05:39 PM

    It has been resolved.

     

    I missed the below command before running the "Load Dataware House" job.

    admin db dwh-upgrade -Dupgrade.phase=maintenance

     

    Thanks,

    Shal



  • 3.  Re: Load Data-ware House Job Failed

    Posted 01-15-2018 12:06 AM

    Hi,

     

    I found the similar thread. It maybe helpful for your investigation.

     

    Load DWH job fails