Clarity PPM

Expand all | Collapse all

Load Data Warehouse Job error

  • 1.  Load Data Warehouse Job error

    Posted 06-01-2017 09:28 AM
      |   view attached

    Hi all,

     

    I am facing a issue when I am launching the Load Data Warehouse job in our Development environment. with this error.

     

    6/01 13:58:52 - User Defined Java Class.0 - ERROR (version 5.0.2, build 1 from 2013-12-04_15-52-25 by buildguy) : Unexpected error
    2017/06/01 13:58:52 - User Defined Java Class.0 - ERROR (version 5.0.2, build 1 from 2013-12-04_15-52-25 by buildguy) : java.lang.RuntimeException: ERROR: THERE WERE ERRORS DURING DIMENSION JOB EXECUTION FOR THE TABLE - DWH_INV_IDEA
    2017/06/01 13:58:52 - User Defined Java Class.0 -  at Processor.processRow(Processor.java:64)
    2017/06/01 13:58:52 - User Defined Java Class.0 -  at org.pentaho.di.trans.steps.userdefinedjavaclass.UserDefinedJavaClass.processRow(UserDefinedJavaClass.java:1181)
    2017/06/01 13:58:52 - User Defined Java Class.0 -  at org.pentaho.di.trans.step.RunThread.run(RunThread.java:60)
    2017/06/01 13:58:52 - User Defined Java Class.0 -  at java.lang.Thread.run(Thread.java:748)
    2017/06/01 13:58:52 - dwh_etl_interface_dim - dwh_etl_interface_dim
    2017/06/01 13:58:52 - dwh_etl_interface_dim - dwh_etl_interface_dim
    2017/06/01 13:58:52 - dwh_etl_interface_dim - ERROR (version 5.0.2, build 1 from 2013-12-04_15-52-25 by buildguy) : Errors detected!

     

    I attached the app_dwh.log for more details. Any idea ?

     

    Thank you in advance for your help.

     

    Regards,

    Karim

    Attachment(s)

    zip
    app-dwh.log.1.zip   328K 1 version


  • 2.  Re: Load Data Warehouse Job error

    Posted 06-01-2017 09:51 AM

    Seeing this in you log file: [CA Clarity][SQLServer JDBC Driver][SQLServer]Invalid column name 'LODH_ALL_COMMENTS'. Not sure if this is some custom column on your idea object. May want to investigate further.



  • 3.  Re: Load Data Warehouse Job error

    Posted 06-01-2017 09:52 AM

    Also check what data type this is and size: INFO  2017-05-31 04:00:45,465 [dwh_etl_interface_dim - User Defined Java Class] dwh.event null - DWH_INV_IDEA - Job Log: 2017/05/31 04:00:45 - ClarityDB - isOracle? - ERROR (version 5.0.2, build 1 from 2013-12-04_15-52-25 by buildguy) : An error occurred executing this job entry :
    2017/05/31 04:00:45 - ClarityDB - isOracle? - Couldn't execute SQL: DECLARE @ERR_NUMBER NUMERIC;
    2017/05/31 04:00:45 - ClarityDB - isOracle? - DECLARE @ERR_MESSAGE VARCHAR(1000);
    2017/05/31 04:00:45 - ClarityDB - isOracle? - DECLARE @V_SQL_TEXT VARCHAR(MAX);



  • 4.  Re: Load Data Warehouse Job error

    Posted 06-01-2017 03:11 PM

    Hi Karim,

     

    [CA Clarity][SQLServer JDBC Driver][SQLServer]Invalid column name 'LODH_ALL_COMMENTS'.

     

    Please try unchecking the following attribute from Data Warehouse: LODH_ALL_COMMENTS. To do this, please do the following:

    1. Go to PPM UI - Administration - Objects - Idea

    2. In Attributes, find LODH_ALL_COMMENTS, open it

    3. Uncheck the "Include in Data Warehouse" flag.

    4. Run the Load Data Warehouse - Full Load

     

    Once it completes we can try adding the attribute back. Looks like it didn't add properly.

     

    Please let me know how it goes. -Nika



  • 5.  Re: Load Data Warehouse Job error

    Posted 04-17-2018 02:57 AM

    Hi Nika,

     

    Thank you for your answer and apologize for my late response.

    I have deleted this attribute "LODH_ALL_COMMENTS" in idea object and DWH_INV_IDEA. But I still have this error, I may forget something on the road. Do I have to do something in the datawarehouse table ?

     

    Thank you in advance.

    Karim



  • 6.  Re: Load Data Warehouse Job error

    Posted 04-17-2018 09:14 AM

    Hi Karim

     

    It could be that the attribute was not fully removed, we will have to get rid of it manually. Please open a Support case and we will get this sorted for you!

     

    Thank you -Nika



  • 7.  Re: Load Data Warehouse Job error

    Posted 04-17-2018 09:35 AM

    Karim, please respond to the support to the support case as Nika suggested.  I need to understand what exact steps you taken, it appears you have deleted the attribute but system still thinks it needs to be included. Please provide step by step what you have done so we can advise on how to proceed.