AnsweredAssumed Answered

Datamart Extraction Job is Failing

Question asked by Rajkumar_Saminathan on Apr 25, 2017
Latest reply on Apr 25, 2017 by Nika_Hadzhikidi

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

Outcomes