Page 1 of 1

Parallel gateway not working properly.

Posted: Thu Apr 20, 2017 12:56 am
by rkiransasi
Hi,

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.

Regards,
Kiran

Re: Parallel gateway not working properly.

Posted: Thu Apr 20, 2017 4:39 am
by zainab
Hello,

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

Re: Parallel gateway not working properly.

Posted: Thu Apr 20, 2017 9:37 pm
by amosbatto
You probably need to add a converging parallel gateway to match your diverging parallel gateway, like this:
sampleParallelGateways.png
sampleParallelGateways.png (15.49 KiB) Viewed 8447 times