Notifications

Retirer tout

[SOLVED] Error while saving details to workelement table for a Ticket workflow

Sagar · 2016-08-02T14:15:54Z

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!! Log file contents: 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:wampwwwprojeqtorV5.4.2modelpersistenceSqlElement.php:823] 2016-08-02 17:40:51.810 ***** ERROR ***** #1 SqlElement->insertSqlElement called at [C:wampwwwprojeqtorV5.4.2modelpersistenceSqlElement.php:630] 2016-08-02 17:40:51.810 ***** ERROR ***** #2 SqlElement->saveSqlElement called at [C:wampwwwprojeqtorV5.4.2modelpersistenceSqlElement.php:478] 2016-08-02 17:40:51.810 ***** ERROR ***** #3 SqlElement->save called at [C:wampwwwprojeqtorV5.4.2modelWorkElementMain.php:175] 2016-08-02 17:40:51.810 ***** ERROR ***** #4 WorkElementMain->save called at [C:wampwwwprojeqtorV5.4.2modelpersistenceSqlElement.php:1107] 2016-08-02 17:40:51.810 ***** ERROR ***** #5 SqlElement->saveDependantObjects called at [C:wampwwwprojeqtorV5.4.2modelpersistenceSqlElement.php:1065] 2016-08-02 17:40:51.826 ***** ERROR ***** #6 SqlElement->updateSqlElement called at [C:wampwwwprojeqtorV5.4.2modelpersistenceSqlElement.php:624] 2016-08-02 17:40:51.826 ***** ERROR ***** #7 SqlElement->saveSqlElement called at [C:wampwwwprojeqtorV5.4.2modelpersistenceSqlElement.php:478] 2016-08-02 17:40:51.826 ***** ERROR ***** #8 SqlElement->save called at [C:wampwwwprojeqtorV5.4.2modelcustomTicketMain.php:475] 2016-08-02 17:40:51.826 ***** ERROR ***** #9 TicketMain->save called at [C:wampwwwprojeqtorV5.4.2toolsaveObject.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:wampwwwprojeqtorV5.4.2modelpersistenceSqlElement.php:823] 2016-08-02 17:40:51.967 ***** ERROR ***** #1 SqlElement->insertSqlElement called at [C:wampwwwprojeqtorV5.4.2modelpersistenceSqlElement.php:630] 2016-08-02 17:40:51.967 ***** ERROR ***** #2 SqlElement->saveSqlElement called at [C:wampwwwprojeqtorV5.4.2modelpersistenceSqlElement.php:478] 2016-08-02 17:40:51.967 ***** ERROR ***** #3 SqlElement->save called at [C:wampwwwprojeqtorV5.4.2modelWorkElementMain.php:175] 2016-08-02 17:40:51.967 ***** ERROR ***** #4 WorkElementMain->save called at [C:wampwwwprojeqtorV5.4.2modelWorkElementMain.php:295] 2016-08-02 17:40:51.967 ***** ERROR ***** #5 WorkElementMain->save called at [C:wampwwwprojeqtorV5.4.2modelpersistenceSqlElement.php:1107] 2016-08-02 17:40:51.967 ***** ERROR ***** #6 SqlElement->saveDependantObjects called at [C:wampwwwprojeqtorV5.4.2modelpersistenceSqlElement.php:1065] 2016-08-02 17:40:51.967 ***** ERROR ***** #7 SqlElement->updateSqlElement called at [C:wampwwwprojeqtorV5.4.2modelpersistenceSqlElement.php:624] 2016-08-02 17:40:51.967 ***** ERROR ***** #8 SqlElement->saveSqlElement called at [C:wampwwwprojeqtorV5.4.2modelpersistenceSqlElement.php:478] 2016-08-02 17:40:51.967 ***** ERROR ***** #9 SqlElement->save called at [C:wampwwwprojeqtorV5.4.2modelcustomTicketMain.php:475] 2016-08-02 17:40:51.967 ***** ERROR ***** #10 TicketMain->save called at [C:wampwwwprojeqtorV5.4.2toolsaveObject.php:77]

Page 2 / 2 Retour

Ask questions

Dernier post par Sagar Il y a 10 ans

16 Posts

2 Utilisateurs

0 Reactions

11.6 {numéro}K Vu

RSS

Sagar

(@sagar-toshniwal)

Posts: 72

Estimable Member

Début du sujet

Thanks Babynus. This has resolved the issue. Now my workflow is functioning as desired.

I am an Eagle. On a mission to help those who want to help themselves...

Posté : 17/08/2016 10:11 am

Page 2 / 2 Retour

13 Forums
10.1 {numéro}K Sujets
39.7 {numéro}K Posts
3 En ligne
16.6 {numéro}K Membres

Icônes du forum: Le forum ne contient aucun message non lus Le forum contient des messages non lus

Icônes de sujet: Pas répondu Repondu Actif Important Épinglé Non approuvé Résolu Privé Fermé

Propulsé par wpForo version 3.1.4

Découvrez la roadmap de ProjeQtOr !

Retrouvez l'historique des mises à jour

Planifiez les projets & gérez le travail

Planning

Programme

Ticketing

Travail

Agile

Mesurez, ajustez, & maîtrisez

Pilotage

Financier

Administration

Collaboration

Découvrez toutes les fonctionnalités

Encore plus de ProjeQtOr

Démo gratuite

Formations

Boutique

Ressources

100% gratuit ? Où est le piège ?

Tout savoir sur notre business model !

Tous les plugins inclus et sans limite ?

Découvrez notre service d'hébergement qui inclut tous les plugins !

Services à abonnement

Hébergement

Support

Souscription

Qlub utilisateurs

Services ponctuels

Formation

Assistance

Évolution à la demande

Plugins

Découvrez tous les services

Encore plus de ProjeQtOr

Démo gratuite

Formations

Boutique

Ressources

Visitez notre Forum

Témoignages

Restez informé

Notre communauté

Nos blogs et articles​

Blog de gestion de projets

Rejoignez un écosystème vivant

Qlub utilisateurs

Roadmap ProjeQtOr

Suggestions

Découvrez notre communauté

Encore plus de ProjeQtOr

Démo gratuite

Formations

Boutique

Ressources

Dernière version

Besoin d'explications ?

Documentation & support

FAQ

Forum

Manuel en ligne

Installation & prérequis

Encore plus de ProjeQtOr

Démo gratuite

Formations

Boutique

Ressources

[SOLVED] Error while saving details to workelement table for a Ticket workflow

Planifiez les projets
& gérez le travail

Mesurez, ajustez,
& maîtrisez

Encore plus
de ProjeQtOr

100% gratuit ?
Où est le piège ?

Encore plus
de ProjeQtOr

Nos blogs et articles

Encore plus
de ProjeQtOr