Questions and discussion about using ProcessMaker 2: user interface, running cases and functionality

Moderator: ArturoRobles

Forum rules: Please search to see if a question has already been asked before posting. Please don't ask the same question in multiple forums.
By duyvh0309
#828131
Hi All,

We have a requirement to avoid duplication of Task number (Which is an text box). To solve this issue i have created a report table by considering Task number as Unique key. I clicked on New Case, and try to provide duplicate Task number and the system has restricted the same, but an error is displayed. It is not allowing me to create a new case , Draft. I am looking for a solution to overcome this.

I am ideally looking for a solution by providing a pop-up message stating 'Task with the entered Task number is already created'. Also, the system should not restrict creating of New case or draft.

Please find below the error displayed by the tool
Error
Unable to execute UPDATE statement. [wrapped: Could not execute update [Native Error: Duplicate entry '8891' for key ' UNIQUE'] [User Info: UPDATE PMT_E2BNEWTABLE SET `TASKNO` = '8891' WHERE PMT_E2BNEWTABLE.APP_UID='118011474569f2b83460817028224164']]

and while clicking on inbox below error page will diaplay



RuntimeException:

The row '326873779568e5c32ebdcb3038267902, 2' in table AppDelegation doesn't exist!

At AppDelegation->Load()
in C:\Users\vijayalakshmi_m\AppData\Roaming\ProcessMaker-3_0_1_5_community\processmaker\workflow\engine\classes\class.case.php line 1173
At Cases->loadCase()
in C:\Users\vijayalakshmi_m\AppData\Roaming\ProcessMaker-3_0_1_5_community\processmaker\workflow\engine\methods\cases\open.php line 135
At require_once() in C:\Users\vijayalakshmi_m\AppData\Roaming\ProcessMaker-3_0_1_5_community\processmaker\workflow\public_html\sysGeneric.php line 1006
At include() in C:\Users\vijayalakshmi_m\AppData\Roaming\ProcessMaker-3_0_1_5_community\processmaker\workflow\public_html\app.php line 61


Regards,
Duyvh0309
Manual email send out did not run.

Dear All, Sometimes email stuck in pending when p[…]

DELETE A OUTPUT DOCUMENT

I solve the problem using this trigger $caseId =[…]

First off I am new to processmaker. I am trying to[…]

Total of grid in integer

Hi, Is there any better way to do it instead of c[…]