Common DIEF errors

DIEF

Error message Cause Solution
Blank rows at the end of the file.

Open the .csv file with Notepad and remove any extra commas at the end of the file.
  Column values have not been copied all the way down for all records. Ensure all columns have required values.
 

Inappropriate characters in a column.

For example, #N/A in an Amount column, $ sign against an Amount.

 Remove or fix the incorrect characters.
Blank columns at the end of the file. Copy the data only to a new spreadsheet and import.

Error occurred while doing bulk copy from the temp table to the entity table-Violation of PRIMARY KEY constraint 'I_100479ITEMIDX'.

Cannot insert duplicate key in object 'dbo.DMFPRODUCTENTITY'. The duplicate key value is (5637159827, GroupsProducts, GroupsProducts-11, 303260).

 Duplicate ItemId in file. Assign unique ItemId.
Common Issues
  File is open during import process. Make sure that the file is not open when importing it.
 

Mandatory data is missing from the file.

If a file has large volume of data and returns an error while importing, test this file with just one row of data to easily identify any issue with the data.
  Format of the file is not correct. Open the .csv file with Notepad and remove any extra commas at the end of the file.
  Before importing the file, preview the file from GetStagingData form.

If data can be viewed from Get staging data, then it means that there is no issue with file format.

  Check any error not related to file format in Execution History > Log of Error.
  1. Close the message.

  2. Select GroupProducts, then select Execution History to locate the Error log.

  3. Select the batch, then click Error Log.

    The error log details are located at the bottom of the screen.

  4. Close the error log.
  5. Update your file to correct any data or formatting error, then attempt the import again.