Load Data Warehouse Job Fails With "Cannot insert the value NULL into column 'VENDOR

Load Data Warehouse Job Fails With "Cannot insert the value NULL into column 'VENDOR_STATUS'" Error

Article Id: 195814

Status: Published

Updated On: 21-09-2020 03:40

Products:

Clarity PPM On Premise , Clarity PPM SaaS

Issue/Introduction:

Load Datawarehouse job fails with the folllowing error (as seen in the bg-dwh.log):

INFO XXXX-XX-XX XX:XX:XX,XXX [dwh_mssql_error_occurred - Error Message Variables] dwh.event Error Message Variables - Set variable ERROR_MESSAGE to value [Cannot insert the value NULL into column 'VENDOR_STATUS', table 'x.x.DWH_FIN_VENDOR_LN'; column does not allow nulls. INSERT fails.]

Cause:

There is at least one Vendor Status that does not have any value (i.e.: current value is '[--Select--]'):

Resolution:

Under Administration > Finance > Setup > Transactions > Vendors, review your Vendors and look for any with no value selected for 'Status'. Select a value and save, then retry the Load Data Warehouse job.