V 5.4.2. I am getting an unusual error. The red-colored error pop-up does not have any text message! But the log file has captured error stack trace which I reproduce below.
Origin of error: I have customized a workflow for Tickets, along with certain actors at each stage. On one approval stage for this Ticket, I get this error.
Note: The only way I can move forward in my workflow is by deleting this particular row from the workelement database table. This obviously is not the solution. So please help!!
2016-08-02 17:40:51.810 ***** ERROR ***** Exception-[23000] SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry 'Ticket-16' for key 'workelementReference'
2016-08-02 17:40:51.810 ***** ERROR ***** For query : insert into workelement ( refType , refId , idProject , refName , idUser , ongoing , done , idle ) values ('Ticket', '16', '12', 'Request #3 raised by Samish on 0208', '24', '0', '0', '0')
2016-08-02 17:40:51.810 ***** ERROR ***** Strack trace :
2016-08-02 17:40:51.810 ***** ERROR ***** #0 Sql->query called at [C:\wamp\www\projeqtorV5.4.2\model\persistence\SqlElement.php:823]
2016-08-02 17:40:51.810 ***** ERROR ***** #1 SqlElement->insertSqlElement called at [C:\wamp\www\projeqtorV5.4.2\model\persistence\SqlElement.php:630]
2016-08-02 17:40:51.810 ***** ERROR ***** #2 SqlElement->saveSqlElement called at [C:\wamp\www\projeqtorV5.4.2\model\persistence\SqlElement.php:478]
2016-08-02 17:40:51.810 ***** ERROR ***** #3 SqlElement->save called at [C:\wamp\www\projeqtorV5.4.2\model\WorkElementMain.php:175]
2016-08-02 17:40:51.810 ***** ERROR ***** #4 WorkElementMain->save called at [C:\wamp\www\projeqtorV5.4.2\model\persistence\SqlElement.php:1107]
2016-08-02 17:40:51.810 ***** ERROR ***** #5 SqlElement->saveDependantObjects called at [C:\wamp\www\projeqtorV5.4.2\model\persistence\SqlElement.php:1065]
2016-08-02 17:40:51.826 ***** ERROR ***** #6 SqlElement->updateSqlElement called at [C:\wamp\www\projeqtorV5.4.2\model\persistence\SqlElement.php:624]
2016-08-02 17:40:51.826 ***** ERROR ***** #7 SqlElement->saveSqlElement called at [C:\wamp\www\projeqtorV5.4.2\model\persistence\SqlElement.php:478]
2016-08-02 17:40:51.826 ***** ERROR ***** #8 SqlElement->save called at [C:\wamp\www\projeqtorV5.4.2\model\custom\TicketMain.php:475]
2016-08-02 17:40:51.826 ***** ERROR ***** #9 TicketMain->save called at [C:\wamp\www\projeqtorV5.4.2\tool\saveObject.php:77]
2016-08-02 17:40:51.967 ***** ERROR ***** Exception-[23000] SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry 'Ticket-16' for key 'workelementReference'
2016-08-02 17:40:51.967 ***** ERROR ***** For query : insert into workelement ( refType , refId , idProject , refName , realCost , idUser , ongoing , done , idle ) values ('Ticket', '16', '12', 'Request #3 raised by Samish on 0208', '172042.22', '24', '0', '0', '0')
2016-08-02 17:40:51.967 ***** ERROR ***** Strack trace :
2016-08-02 17:40:51.967 ***** ERROR ***** #0 Sql->query called at [C:\wamp\www\projeqtorV5.4.2\model\persistence\SqlElement.php:823]
2016-08-02 17:40:51.967 ***** ERROR ***** #1 SqlElement->insertSqlElement called at [C:\wamp\www\projeqtorV5.4.2\model\persistence\SqlElement.php:630]
2016-08-02 17:40:51.967 ***** ERROR ***** #2 SqlElement->saveSqlElement called at [C:\wamp\www\projeqtorV5.4.2\model\persistence\SqlElement.php:478]
2016-08-02 17:40:51.967 ***** ERROR ***** #3 SqlElement->save called at [C:\wamp\www\projeqtorV5.4.2\model\WorkElementMain.php:175]
2016-08-02 17:40:51.967 ***** ERROR ***** #4 WorkElementMain->save called at [C:\wamp\www\projeqtorV5.4.2\model\WorkElementMain.php:295]
2016-08-02 17:40:51.967 ***** ERROR ***** #5 WorkElementMain->save called at [C:\wamp\www\projeqtorV5.4.2\model\persistence\SqlElement.php:1107]
2016-08-02 17:40:51.967 ***** ERROR ***** #6 SqlElement->saveDependantObjects called at [C:\wamp\www\projeqtorV5.4.2\model\persistence\SqlElement.php:1065]
2016-08-02 17:40:51.967 ***** ERROR ***** #7 SqlElement->updateSqlElement called at [C:\wamp\www\projeqtorV5.4.2\model\persistence\SqlElement.php:624]
2016-08-02 17:40:51.967 ***** ERROR ***** #8 SqlElement->saveSqlElement called at [C:\wamp\www\projeqtorV5.4.2\model\persistence\SqlElement.php:478]
2016-08-02 17:40:51.967 ***** ERROR ***** #9 SqlElement->save called at [C:\wamp\www\projeqtorV5.4.2\model\custom\TicketMain.php:475]
2016-08-02 17:40:51.967 ***** ERROR ***** #10 TicketMain->save called at [C:\wamp\www\projeqtorV5.4.2\tool\saveObject.php:77]
Support us on Capterra
