datamart extract is failing the bg-ca.log showing “cannot insert NULL into NBI_PRT_FACTS.TEAM_ID
Article ID: 107823
CLARITY PPM FOR ITGCLARITY PPM FEDERALClarity PPM SaaSClarity PPM On Premise
Our datamart extract job failed in production this morning. Here is a copy of the error message: PMD application error java.sql.SQLException: [CA Clarity][Oracle JDBC Driver][Oracle]ORA-20000: Error in NBI_EXTRACT_SP - Calling NBI_EXTR_PRTF_SP: ORA-20000: Error in NBI_EXTR_PRTF_SP - CHECKING IF THERE ARE ANY EVENTS TO PROCESS: ORA-20000: Error in NBI_PRTF_SP - DONE DROPPING INDEXES: ORA-01400: cannot insert NULL into ("SC51929P"."NBI_PRT_FACTS"."TEAM_ID") ORA-06512: at "SC51929P.NBI_EXTRACT_SP", line 362 ORA-06512: at line 1
The STR are unknown.
CA PPM 14.x +
A direct database update is required to resolve this problem.
Please contact CA Support for assistance with implementing this solution.