DWH load

[Borut Debeljak]

In DWH load proces we have an error with   DWH_FIN_VENDOR_LN : error reports probem with VENDOR_STATUS field. I suspect problem s in data, however I haven't find where from data is taken for this field.

Can you suggest how/where to check data?

Error message from log:
INFO 2020-07-22 15:01:34,933 [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 'ppm_dwh.ppm_dwh.DWH_FIN_VENDOR_LN'; column does not allow nulls. INSERT fails.]

------------------------------
Borut Debeljak
------------------------------

[Marc Buigues]

Can you please check in Administration > Finance > Setup > Transactions > Vendors for any Vendor with empty Vendor Status (or showing up as NULL, [--SELECT--]...)? If there is any, please modify it to have a valid status.

[Borut Debeljak]

Hello,

Thanks, I have found a record, which caused problem and correct it. Afterwards job finished ok

------------------------------
Borut Debeljak
------------------------------

[Marc Buigues]

Thanks for your confirmation as well. I am glad that this helped you resolve the issue.