Clarity

 View Only
  • 1.  Datamart extraction job failed with no proper info

    Posted May 17, 2022 07:14 AM
    Hi All - I have ran the Datamart extraction job with "Extract only Calendars" option checked, soon it failed with below error.

    What could be the possible reasons, as the below message doesn't give proper info,

    NJS-0401: Execution of job failed.


  • 2.  RE: Datamart extraction job failed with no proper info

    Broadcom Employee
    Posted May 17, 2022 07:31 AM
    what does the bg log says you should have more information there

    ------------------------------
    Thanks & Regards
    Suman Pramanik
    Sr. Principal Support Engineer | Customer Success & Support, Enterprise Software Division
    Broadcom
    ------------------------------



  • 3.  RE: Datamart extraction job failed with no proper info

    Posted May 17, 2022 07:54 AM

    I have checked the Logs, below is the error info.

    com.niku.union.persistence.PersistenceException:
    SQL error code: 50000
    Error message: [CA Clarity][SQLServer JDBC Driver][SQLServer]NBI_CFG_NO_PROJECT_OBS_ASSIGNMENT - Project or Resource OBS assignments are not setup
    SQL error code: 8153
    Error message: [CA Clarity][SQLServer JDBC Driver][SQLServer]Warning: Null value is eliminated by an aggregate or other SET operation.




  • 4.  RE: Datamart extraction job failed with no proper info

    Broadcom Employee
    Posted May 17, 2022 08:36 AM
    Thats the error 

    I have checked the Logs, below is the error info.

    com.niku.union.persistence.PersistenceException:
    SQL error code: 50000
    Error message: [CA Clarity][SQLServer JDBC Driver][SQLServer]NBI_CFG_NO_PROJECT_OBS_ASSIGNMENT - Project or Resource OBS assignments are not setup

    Have you set up the datamart settings?

    ------------------------------
    Thanks & Regards
    Suman Pramanik
    Sr. Principal Support Engineer | Customer Success & Support, Enterprise Software Division
    Broadcom
    ------------------------------