datamart extract is failing the bg-ca.log showing “cannot insert NULL into NBI_PRT_FACTS.TEAM_ID

Document ID : KB000107823
Last Modified Date : 27/07/2018
Show Technical Document Details
Issue:
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 
Environment:
CA PPM 14.x +
Cause:
The STR are unknown.
Resolution:
A direct database update is required to resolve this problem.

Please contact CA Support for assistance with implementing this solution.