Clarity

  • Private Community
 View Only

  • 1.  Datamart Extraction Job is Failing

    Posted Apr 25, 2017 03:35 AM

    WARN 2017-04-23 23:26:53,903 [Dispatch pool-4-thread-7 : bg@dmyxyxyx (tenant=clarity)] caching.SecurityObjectCache (clarity:xxyyyyxxxx:45976213__3477F3DF-9B61-4226-B759-481E58C0F9FE:Time Slicing) Invalid security object key: odf_cst_xx_inv_financemetric_parentRECORDCMN
    WARN 2017-04-23 23:26:54,003 [Dispatch pool-4-thread-7 : bg@dmyxyxyx (tenant=clarity)] caching.SecurityObjectCache (clarity:xxyyyyxxxx:45976213__3477F3DF-9B61-4226-B759-481E58C0F9FE:Time Slicing) Invalid security object key: odf_cst_xx_benefit_plan_grandparentRECORDCMN
    WARN 2017-04-23 23:26:54,143 [Dispatch pool-4-thread-7 : bg@dmyxyxyx (tenant=clarity)] caching.SecurityObjectCache (clarity:xxyyyyxxxx:45976213__3477F3DF-9B61-4226-B759-481E58C0F9FE:Time Slicing) Invalid security object key: odf_cst_xx_cost_plan_grandparentRECORDCMN
    WARN 2017-04-24 01:29:22,122 [Dispatch pool-4-thread-7 : bg@dmyxyxyx (tenant=clarity)] niku.union (clarity:xxyyyyxxxx:45976289__02C98BE8-8C5F-45F4-9618-25DD80F6F32D:Datamart Extraction) java.sql.SQLException: [CA Clarity][Oracle JDBC Driver][Oracle]ORA-20000: Error in NBI_EXTRACT_SP - Executing NBI_EXTR_PCF_SP: ORA-20000: Error in NBI_EXTR_PCF_SP - executing NBI_PROJECT_CURRENT_FACTS_SP: ORA-20000: Error in NBI_PROJECT_CURRENT_FACTS_SP - Calling NBI_PROJECT_FORECAST_SP since there are projects with Forecast: ORA-20000: Error in NBI_PROJECT_FORECAST_SP -Populating the planning related information for each of the plan type for the given project: ORA-00001: unique constraint (NIKU.NBI_PROJECT_FORECAST_PK) violated
    ORA-06512: at "NIKU.NBI_EXTRACT_SP", line 362
    ORA-06512: at line 1
    was not found in file: messages_en.properties
    ERROR 2017-04-24 01:29:22,128 [Dispatch pool-4-thread-7 : bg@dmyxyxyx (tenant=clarity)] niku.njs (clarity:xxyyyyxxxx:45976289__02C98BE8-8C5F-45F4-9618-25DD80F6F32D:Datamart Extraction) Error executing job: 5941063 error java.sql.SQLException: [CA Clarity][Oracle JDBC Driver][Oracle]ORA-20000: Error in NBI_EXTRACT_SP - Executing NBI_EXTR_PCF_SP: ORA-20000: Error in NBI_EXTR_PCF_SP - executing NBI_PROJECT_CURRENT_FACTS_SP: ORA-20000: Error in NBI_PROJECT_CURRENT_FACTS_SP - Calling NBI_PROJECT_FORECAST_SP since there are projects with Forecast: ORA-20000: Error in NBI_PROJECT_FORECAST_SP -Populating the planning related information for each of the plan type for the given project: ORA-00001: unique constraint (NIKU.NBI_PROJECT_FORECAST_PK) violated
    ORA-06512: at "NIKU.NBI_EXTRACT_SP", line 362
    ORA-06512: at line 1

    WARN 2017-04-24 01:56:17,589 [Dispatch pool-4-thread-6 : bg@dmyxyxyx (tenant=clarity)] caching.SecurityObjectCache (clarity:xxyyyyxxxx:45985213__F7B12292-5A94-4FDE-B0AC-3491AB96A0D2:Time Slicing) Invalid security object key: odf_cst_xx_inv_financemetric_parentRECORDCMN
    WARN 2017-04-24 01:56:17,698 [Dispatch pool-4-thread-6 : bg@dmyxyxyx (tenant=clarity)] caching.SecurityObjectCache (clarity:xxyyyyxxxx:45985213__F7B12292-5A94-4FDE-B0AC-3491AB96A0D2:Time Slicing) Invalid security object key: odf_cst_xx_benefit_plan_grandparentRECORDCMN
    WARN 2017-04-24 01:56:17,804 [Dispatch pool-4-thread-6 : bg@dmyxyxyx (tenant=clarity)] caching.SecurityObjectCache (clarity:xxyyyyxxxx:45985213__F7B12292-5A94-4FDE-B0AC-3491AB96A0D2:Time Slicing) Invalid security object key: odf_cst_xx_cost_plan_grandparentRECORDCMN



  • 2.  Re: Datamart Extraction Job is Failing

    Posted Apr 25, 2017 03:38 AM

    Can someone help to fix this issue?



  • 3.  Re: Datamart Extraction Job is Failing
    Best Answer

    Broadcom Employee
    Posted Apr 25, 2017 03:08 PM

    Hi Rajkumar,

     

     

    Your error message is:
    ORA-00001: unique constraint (NIKU.NBI_PROJECT_FORECAST_PK) violated

     

    Looks like the Datamart is trying to insert a record which is already there (duplicate). We will have to find out which is the erroneous record, why it's there and how to resolve the issue.

     

    The primary key is on: PROJECT_ID and PLAN_TYPE. Please run the query:

     

    select project_id, plan_type, count(*) from (

    SELECT  PLANS.OBJECT_ID PROJECT_ID,       

                                                    CASE WHEN CL.LOOKUP_CODE= 'BUDGET' THEN 50343 ELSE 50342 END PLAN_TYPE       

                                                                                    FROM

                                                     INV_INVESTMENTS INV

                                    JOIN FIN_PLANS PLANS ON (INV.ID = PLANS.OBJECT_ID AND PLANS.IS_PLAN_OF_RECORD = 1 )

                                    JOIN  PAC_MNT_PROJECTS pmt ON (pmt.ID=INV.ID AND LOCATIONID IS NOT NULL AND DEPARTCODE IS NOT NULL)

                                    JOIN CMN_LOOKUPS CL ON (PLANS.PLAN_TYPE_CODE =CL.LOOKUP_CODE AND CL.LOOKUP_TYPE = 'FIN_PLAN_TYPE' )

                                    LEFT OUTER JOIN INV_PROJECTS PROJECTS ON INV.ID=PROJECTS.PRID 

                                    WHERE NVL(PROJECTS.IS_TEMPLATE,0)=0

    )

    group by project_id, plan_type

    having count(*) >1

     

    See if you have any duplicates, if you do, look in UI to see if you can identify/fix it.

     

    I do recommend you to raise a case with us in Support so we dig deep into this issue and figure it out. When you do, please let me know what the issue number is.

     

    Thank you -Nika