Prochaines Sessions
Les prochaines formations et démonstrations sont ouvertes, inscrivez-vous rapidement !
Démonstration de ProjeQtOr(gratuit, sur inscription)
13 mai 2025 (10h30-12h) 5 juin 2025 (16h-17h30) |
Les prochaines formations et démonstrations sont ouvertes, inscrivez-vous rapidement !
Démonstration de ProjeQtOr(gratuit, sur inscription)
13 mai 2025 (10h30-12h) 5 juin 2025 (16h-17h30) |
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]
Please Connexion or Create an account to join the conversation.
Please Connexion or Create an account to join the conversation.
Please Connexion or Create an account to join the conversation.
Please Connexion or Create an account to join the conversation.
I have created a few user id's with different access rights. In my workflow, specific users can take certain actions. An administrator can take all the actions. In this particular case of error, the ticket is created by Guest and the Administrator is trying to Cancel the ticket. That's the point when I get this error.babynus wrote: Czn you please give more hint.
For instance, about "approval stage" that leads to error : does the approval is done by user with specific access rights ?
Does this user see "work" data on the tickets ?
Does the "approval stage" lead to email sending ?
What you can do to help investigate : if approval profile is specific, try and change to use another one and tell us if it changes things. If so, give as amny information about profile as you can (access rights, specific access rights,...)
I am not sure about this. I will try that and will let you know if it improves things in any way.babynus wrote: Also try and disable email sending and tell us if it changes things.
Please Connexion or Create an account to join the conversation.
Does the admionistrator see "work" data on the tickets ?the ticket is created by Guest and the Administrator is trying to Cancel the ticket
Please Connexion or Create an account to join the conversation.
En poursuivant votre navigation, vous acceptez le dépôt de cookies tiers destinés au bon fonctionnement et à la sécurisation du site (gestion de session, reCaptcha) et à une analyse statistique anonymisée des accès sur notre site (Google Analytics). Si vous vous inscrivez, les informations que vous fournirez ne seront jamais divulguées à un tiers sous quelque forme que ce soit. En savoir plus
Ce site utilise des cookies pour assurer son bon fonctionnement et ne peuvent pas être désactivés de nos systèmes. Nous ne les utilisons pas à des fins publicitaires. Si ces cookies sont bloqués, certaines parties du site ne pourront pas fonctionner.
Ce site web utilise un certain nombre de cookies pour gérer, par exemple, les sessions utilisateurs.