Clarity

  • Private Community

  • 1.  datamart role up job has an error CA PPM v15.5

    Posted Mar 29, 2019 04:55 AM

    Hi I am trying to run this job it gives and error the Extract Datamart job run 

    but when I run the roll up job I recieve this error any help?

     

    ERROR 2019-03-29 10:38:30,667 [Dispatch Datamart Rollup - Time Facts and Time Summary : bg@ICPPM-APP (tenant=clarity)] niku.njs (clarity:admin:5308073__4B960CE4-03C0-47EA-BF64-22B63CFF77BD:Datamart Rollup - Time Facts and Time Summary) Error executing job: 5022013
    com.niku.union.persistence.PersistenceException:
    SQL error code: 515
    Error message: [CA Clarity][SQLServer JDBC Driver][SQLServer]Cannot insert the value NULL into column 'FISCAL_TIME_KEY', table 'cappm.niku.NBI_FM_PT_FACTS'; column does not allow nulls. INSERT fails.
    SQL error code: 3621
    Error message: [CA Clarity][SQLServer JDBC Driver][SQLServer]The statement has been terminated.
    SQL error code: 50000
    Error message: [CA Clarity][SQLServer JDBC Driver][SQLServer]-20000_Error in NBI_FM_PTF_SP - Inserting into NBI_FM_PT_FACTS
    SQL error code: 515
    Error message: [CA Clarity][SQLServer JDBC Driver][SQLServer]Cannot insert the value NULL into column 'FISCAL_TIME_KEY', table 'cappm.niku.NBI_FM_PT_FACTS'; column does not allow nulls. INSERT fails.
    SQL error code: 3621
    Error message: [CA Clarity][SQLServer JDBC Driver][SQLServer]The statement has been terminated.
    SQL error code: 50000
    Error message: [CA Clarity][SQLServer JDBC Driver][SQLServer]-20000_Error in NBI_FM_PTF_SP - Inserting into NBI_FM_PT_FACTS
    SQL error code: 515
    Error message: [CA Clarity][SQLServer JDBC Driver][SQLServer]Cannot insert the value NULL into column 'FISCAL_TIME_KEY', table 'cappm.niku.NBI_FM_PT_FACTS'; column does not allow nulls. INSERT fails.
    SQL error code: 3621
    Error message: [CA Clarity][SQLServer JDBC Driver][SQLServer]The statement has been terminated.

     

    thank you



  • 2.  Re: datamart role up job has an error CA PPM v15.5
    Best Answer

    Broadcom Employee
    Posted Mar 29, 2019 04:41 PM

    Hi,

     

    Can you try this solution and see if it works for you?

    Datamart Rollup Job Failed - Cannot insert the val - CA Knowledge 



  • 3.  Re: datamart role up job has an error CA PPM v15.5

    Posted Apr 02, 2019 03:39 AM

    Good Morning

     

    Your Solution worked very well ,thanks for the help

     

    Best Regards

    Goodwill