Skip to main content

Error when closing next action step

In this article, we explain how closing the next action step can trigger a duplicate key error due to a primary key conflict.

Y
Written by Yusef Abulaynain
Updated over 5 months ago

Error:
'Violation of PRIMARY KEY constraint 'DATAFEEDIMPORTHISTORY_PRIMARYKEY'. Cannot insert duplicate key in object 'dbo.DATAFEEDIMPORTHISTORY'. The duplicate key value is (Row0)
### Error updating database. Cause: com.microsoft.sqlserver.jdbc.SQLServerException: Violation of PRIMARY KEY constraint 'XPKMO_FORM_DATE_ANSWERS'. Cannot insert duplicate key in object 'dbo.MO_FORM_DATE_ANSWERS'. The duplicate key value is (Row0).'

If you’re getting this error when you try to close the next action step, it’s because you’re trying to add the same date more than once.

You can try this workaround:

  1. Reopen the step,

  2. Cancel it.

  3. Then redo it.

Did this answer your question?