Skip to main content

Error: 'Publishing to SFDC failed. Cannot insert duplicate key row in object sfdc.operations with unique index IX_sfdc.operations_orderID_OpStep. The duplicate key value is'

Written by Charnjit Singh Dharival

When trying to save the plan the following error generates:
​
​Publishing to SFDC failed. Cannot insert duplicate key row in object sfdc.operations with unique index IX_sfdc.operations_orderID_OpStep. The duplicate key value is (number 1, number 2)


The GOODS IN resource needs removing from any views created. Please complete the following steps:

  1. Select View (or press the black camera button adjacent to Saved Views)

  2. Select View Manager

  3. From the saved views drop-down list select any SFDC view

  4. If the Goods In resource is in the Selected box, highlight Goods In

  5. Click Remove

  6. Click Save

  7. Click Exit

  8. Click the Floppy Disc button to save the plan

If the Goods In or Shipping resource (system resources) are not added to any views and your plan is still receiving this error, Please raise a new case online and reference the title of this article.

Did this answer your question?