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'

What to do if you see a 'Publishing to SFDC failed. Cannot insert duplicate key row' error when trying to save the plan.

Written by Arthur Ashdown

When trying to save the plan, the following error may generate:

⚠️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 (number 1, number 2)

The Goods In resource needs removing from any views created.

Resolution

Complete the following steps to remove the Goods In resource from your SFDC views:

  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.

📌Note: 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.

Related Articles
Did this answer your question?