SAP Knowledge Base Article - Preview

3470716 - Error on Allocate Aggregation stage: constraint NOT NULL violation; checkNotNullColumn(): found NULL

Symptom

Pipeline failed on Allocate Aggregation stage with the following message:

Problem executing storedProc AllocateUtilsLib:PopulatePATransaction( pPeriodSeq = <PERIOD>, pProcessingUnitSeq = <PIPELINERUNSEQ>, pModelSeq = <MODEL> ) ,cause: SAP DBTech JDBC: [287]: cannot insert NULL or update to NULL: "TCMP"."ALLOCATEUTILSLIB":"POPULATEPATRANSACTION": line XXX col XXX (at pos XXXX): TrexColumnUpdate failed on table 'TCMP:CS_PATRANSACTION' with error: constraint NOT NULL violation;checkNotNullColumn(): found NULL on pos XXXX ,column 'EVENTTYPEID', table 'TCMP:CS_PATRANSACTION'

Fatal error in runStage! Cause: SAP DBTech JDBC: [287]: cannot insert NULL or update to NULL: "TCMP"."ALLOCATEUTILSLIB":"POPULATEPATRANSACTION": line XXX col XX (at pos XXXX): TrexColumnUpdate failed on table 'TCMP:CS_PATRANSACTION' with error: constraint NOT NULL violation;checkNotNullColumn(): found NULL on pos XXXX,column 'EVENTTYPEID', table 'TCMP:CS_PATRANSACTION'.


Read more...

Environment

SAP SuccessFactors Incentive Management

  • Hana instance

Product

SAP SuccessFactors Incentive Management all versions

Keywords

Pipeline failure, Allocate Aggregation, Null value, Event type null. , KBA , CEC-SAL-COM-PIP , Pipeline Runs and Calculations , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.