Clarity PPM1

Expand all | Collapse all

Load Data Warehouse job: ERROR ... CA PPM 15.1 sp#3 - Jaspersoft_6.2.1_5.2.1.54

Jump to Best Answer
  • 1.  Load Data Warehouse job: ERROR ... CA PPM 15.1 sp#3 - Jaspersoft_6.2.1_5.2.1.54

    Posted 01-19-2017 09:24 AM

    I am installing Jaspersoft_6.2.1_5.2.1.54 on PPM 15.1 and when I excecute the job Load Data Warehouse this error occurs.

     

    ERROR 2017-01-19 10:30:59,407 [Dispatch Load Data Warehouse : bg@CACLTDW02 (tenant=clarity)] dwh.event ETL Job Failed. Log details below:
    2017/01/19 10:30:59 - dwh_db_check_ - ERROR (version 5.0.2, build 1 from 2013-12-04_15-52-25 by buildguy) : An error occurred executing this job entry :
    2017/01/19 10:30:59 - dwh_db_check_ - Couldn't execute SQL: BEGIN
    2017/01/19 10:30:59 - dwh_db_check_ - EXEC RPT_CALENDAR_SP;
    2017/01/19 10:30:59 - dwh_db_check_ - EXEC RPT_INV_HIERARCHY_SP;
    2017/01/19 10:30:59 - dwh_db_check_ - END;
    2017/01/19 10:30:59 - dwh_db_check_ -
    2017/01/19 10:30:59 - dwh_db_check_ - [CA Clarity][SQLServer JDBC Driver][SQLServer]Entity has not been setup in Data Warehouse Settings
    null



  • 2.  Re: Load Data Warehouse job: ERROR ... CA PPM 15.1 sp#3 - Jaspersoft_6.2.1_5.2.1.54
    Best Answer

    Posted 01-19-2017 10:47 AM

     

    Hi Ricardo

     

    For the Data Warehouse job to work, you must set up the Data Warehouse entity and other options. Please go to Administration - System Options and fill in the Entity and Languages.

     

    Then run a Full Load again.

     

     

    For more information, check the tec article:

     

    https://www.ca.com/us/services-support/ca-support/ca-support-online/knowledge-base-articles.tec1223718.html

     

     

    Hope this helps -Nika



  • 3.  Re: Load Data Warehouse job: ERROR ... CA PPM 15.1 sp#3 - Jaspersoft_6.2.1_5.2.1.54

    Posted 01-24-2017 10:08 AM

    Thank you very much Nika.

    Thats was the solution.

    Best Regards