Any one knows the reason of Duplicate entry error for PRIMARY key for pmse_bpm_flow table? I am continuously getting these errors in sugarcrm.log.
Any thoughts will be really appreciated.
Run the following command:
SELECT id, COUNT(*) as cnt FROM pmse_bpm_flow group by ID having cnt > 1
This should tell you if there are any duplicate IDs in the pmse_bpm_flow table.
SHOW CREATE TABLE pmse_bpm_flow
In case for some weird reason ID isn't the primary ID.
Unfortunately I don't have duplicate ids inside 'pmse_bpm_flow' table. This is something happening on process author code level. At some point its trying to generate the a flow record with the same guid that already exists.
I'me having the same issue on a 18.104.22.168
Error inserting into table: pmse_bpm_flow: Query Failed: INSERT INTO pmse_bpm_flow (id,name,date_entered ... : MySQL error 1062: Duplicate entry '79ab504e-38c4-11e8-aa76-ae189f748161' for key 'PRIMARY'
Have you found the reason for this?
You need to upgrade to Sugar 7.9. Sugar has fixed lots of issues related to advanced workflows. This is also one of these issues.
This issue can come if you edit the running process.
Retrieving data ...