Resolve "Violation of PRIMARY KEY constraint 'PK_CompositionIniEntry'. " in EngageOne Designer 6.0.1242

Issue

In Designer version 6.0.1242

When using the publish wizard to publish a document, customer is getting the following error when pressing the "Finish" button.

Primary key violation occurred, item already exists in the table.
Violation of PRIMARY KEY constraint 'PK_CompositionIniEntry'. 
Cannot insert duplicate key.



 

Cause

Customer upgraded from version 5.6. 

The publishing dialog was creating duplicate journal and lookup table entries (possibly related to the fact that an entry may have been renamed in the publication at some point). 

Resolution

UPDATED: November 6, 2017
This is fixed in version 6.0m4

Also, as a temporary fix, there is a workaround for this: If you select the production job directly, and then select publish for generate, it works OK.