Share ideas, ask questions, and get feedback about developing for ProcessMaker

Moderator: ArturoRobles

Forum rules: Please post new questions under "Developing processes & programming" for ProcessMaker 2 or 3.
By rkiransasi

The business scenario is as follows.

Requester submits the request and it goes for approval. The first approver approves and the 2nd step is 8 parallel approvers. So task will be sent to 8 users parallely and once all of them complete the same, the next step will be executed.

When I try with parallel gateway, task is getting assigned to parallel approvers, but on final approval, I am getting an error and its not moving to next step.

Error : Unable to execute INSERT statement. [wrapped: Could not execute update [Native Error: Duplicate entry '62392878458d4fe99b22155021990455-12' for key 'PRIMARY'] [User Info: INSERT INTO LIST_INBOX (`APP_UID`,`DEL_INDEX`,`USR_UID`,`TAS_UID`,`PRO_UID`,`APP_NUMBER`,`APP_STATUS`,`APP_TITLE`,`APP_PRO_TITLE`,`APP_TAS_TITLE`,`APP_UPDATE_DATE`,`DEL_PREVIOUS_USR_UID`,`DEL_PREVIOUS_USR_USERNAME`,`DEL_PREVIOUS_USR_FIRSTNAME`,`DEL_PREVIOUS_USR_LASTNAME`,`DEL_DELEGATE_DATE`,`DEL_DUE_DATE`,`DEL_RISK_DATE`,`DEL_PRIORITY`) VALUES ('62392878458d4fe99b22155021990455',12,'989657065564588e7c7db50064442439','57750138558d4f05e9e6ec6004386880','92868567558c8cdd224db63064282911',6134,'TO_DO','#6134','Bursa 4M Modification','Risk Insurance and Environment','2017-03-27 08:35:43','989657065564588e7c7db50064442439','dev.kiran.rajendran','Kiran','RAJENDRAN','2017-03-27 08:35:43','2017-03-27 17:00:00','2017-03-27 15:24:00','3')]]

Can you please help me out on this.

By zainab

Could you please attach your process, so that we could replicate this issue at our end and understand what is going on. There are duplicate entries in your database against the same case id, that is the reason it is throwing this error.

Best Regards,
Zainab Sabunwala

Sometimes the data comes from a user, like when a […]

Found the solution here:[…]

Learn what's new in ProcessMaker 3.6! We are proud[…]

Hello, I have a case that appears both as comple[…]