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.]
There is at least one Vendor Status that does not have any value (i.e.: current value is '[--Select--]'):
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.