I run the data import and the following error message generates:-
Orchestrate Data Flow Import has failed. The detailed information is as follows:
Column 'ItemDescription' does not all DBNull.value
Import Command:
SELECT StockBalances.ProductCode as ItemCode
,StockBalances.Description as ItemDescription
, 1 as Make
, 0 as MfgBatchSize
FROM STOCKBALANCES.csv STOCKBALANCES
I cannot run the CSV import due to the following error message:-
Column 'ItemCode' does not all DBNull.value
Import Command:
SELECT DISTINCT STITEM05 As ItemCode
,STITEM05 As ItemDescription
,1 AS MfgBatchSize
,Blend as ProcessCode
,Kg As UnitCode
,LEFT(STITEM05,1) As ItemTypeCode
FROM [NAME OF FILE.CSV]
Please check the following:
Check the CSV file and you will see a empty field for one or more rows
Check if the order needs updating from the ERP system with the missing information or delete the order
Download a new version of the CSV file from the ERP system
If you still cannot find the missing order or other data, Please raise a new case online and reference the title of this article.