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

book

Article ID: 107823

calendar_today

Updated On:

Products

CLARITY PPM FOR ITG CLARITY PPM FEDERAL Clarity PPM SaaS Clarity PPM On Premise

Issue/Introduction

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 

Cause

The STR are unknown.

Environment

CA PPM 14.x +

Resolution

A direct database update is required to resolve this problem.

Please contact CA Support for assistance with implementing this solution.