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

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.