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

Excellent read, Positive site, where did u come up[…]

Hello ProcessMakers! We are extremely proud to an[…]

How processmaker load cases on home page of user? […]

Hey everyone, I'd appreciate any help you might be[…]