Cannot insert the value NULL into column ‘xxx’, table ‘PricingManagementdbo.RPMxxx’; column does not allow nulls.

Error

When importing data within Rockton Pricing Management (RPM), the following error message can occur:

Cannot insert the value NULL into column ‘xxx’, table ‘PricingManagementdbo.RPMxxx’; column does not allow nulls. UPDATE fails. The statement has been terminated.

The error message varies based on the table or column referenced.

Cause

This issue can occur when importing a file into an RPM web page that was not exported and created in the correct format. Most likely, when the original file was created, the file was generated by selecting the option “No, just exporting”. This creates the export file in a slightly different format that cannot be imported back into RPM.

Resolution

To resolve this issue, a new file needs to be exported in the correct format, with any edits made to the new file. Then, an import can complete successfully. Following are the steps to do so using Pricing Filters as an example, but the same steps can be used for any page receiving the error when importing:

  1. Open Pricing Filters from Pricing menu.
  2. Click Export.
  3. Click Yes when asked if you want to re-import these records.

  1. The PricingFilters.xlsx file is generated.
  2. Open the PricingFilters.xlsx file in Excel, make any needed changes to the file.
  3. Click Save.
  4. Back in RPM, click Import from the Pricing Filters page.
  5. Select the PricingFilters.xlsx file and click Open.
  6. A prompt should appear to validate the import completed successfully.

  1. Records are imported and ready for use.