View ProjeQtOr On SourceForge.net
ProjeQtOr - Project Management Tool
Supportez nous sur Capterra
OIN - Open Invention Network
ProjeQtOr free project management software - [SOLVED] planning calculation error - ProjeQtOr

Prochaines sessions de formation

Les prochaines formations et démonstrations sont ouvertes, inscrivez-vous rapidement !

 

Démonstration de ProjeQtOr

(gratuit, sur inscription)

Mardi 23 avril (10h30-12h)

Jeudi 16 mai (16h-17h30)

Jeudi 13 juin (10h30-12h)

  
 

Planifiez avec ProjeQtOr

3 et 4 avril (9h - 12h30)

  
 

Administrez avec ProjeQtOr

10 et 11 avril (9h - 12h30)

  

 

 
 

[SOLVED] planning calculation error

More
07 Jui 2018 10:57 #1 by Durou C
planning calculation error was created by Durou C
I have one project who doesn't want to calculate gantt planning. I don't why ? I have this on log file:

2018-06-07 10:42:51.243 ***** ERROR ***** [V7.1.1] Exception-[HY000] SQLSTATE[HY000]: General error: 1205 Lock wait timeout exceeded; try restarting transaction
2018-06-07 10:42:51.243 ***** ERROR ***** [V7.1.1] For query : update assignment set idle='1' where refType='Meeting' and refId=74
2018-06-07 10:42:51.243 ***** ERROR ***** [V7.1.1] Strack trace :
2018-06-07 10:42:51.243 ***** ERROR ***** [V7.1.1] #0 Sql->query called at [/var/www/projeqtor/model/persistence/SqlElement.php:1504]
2018-06-07 10:42:51.243 ***** ERROR ***** [V7.1.1] #1 SqlElement->updateSqlElement called at [/var/www/projeqtor/model/persistence/SqlElement.php:981]
2018-06-07 10:42:51.243 ***** ERROR ***** [V7.1.1] #2 SqlElement->saveSqlElement called at [/var/www/projeqtor/model/persistence/SqlElement.php:650]
2018-06-07 10:42:51.243 ***** ERROR ***** [V7.1.1] #3 SqlElement->save called at [/var/www/projeqtor/model/MeetingMain.php:438]
2018-06-07 10:42:51.243 ***** ERROR ***** [V7.1.1] #4 MeetingMain->save called at [/var/www/projeqtor/tool/saveObject.php:78]

I have try to restart the Projeqtor machine, nothing happen !
it is on V7.1.1 version

Please Connexion or Create an account to join the conversation.

More
07 Jui 2018 12:03 #2 by LeXav19
Replied by LeXav19 on topic planning calculation error
Hello, I have exactly the same problem since the update of V7.0.9. Version V7.1.1 is not in question.
So I'm waiting like you a little patch that will provide a solution.
See you.

Please Connexion or Create an account to join the conversation.

More
07 Jui 2018 12:05 #3 by babynus
Replied by babynus on topic planning calculation error
It is a lock issue : 2 users trying to update same item.
If transactions are long (many things to update on same operation) like on planning calculation, this may happen.
So if 2 project Leader plan 2 big projects at the same time, this may happen. On of the calculations can be an automated done (if enabled).

I've added an improvement on V7.1.2 to try and reduce transaction duration, starting transaction just before updates, at end of planning calculation instead of starting it at begining of calculation.... (Ticket #3426)
This may reduce locks.
If locks persits :
- try a cold restart of database
- try to calculate planning when no-one else in connected
Babynus
Administrator of ProjeQtOr web site
The following user(s) said Thank You: LeXav19

Please Connexion or Create an account to join the conversation.

More
14 Jui 2018 10:49 #4 by Durou C
Replied by Durou C on topic planning calculation error
this is very strange, i have some project with correct calculation planning, and other without !
I have close the projeqtor program, I'm alone connected.
I try to calculate planinig with just 3 activities open and it's failed!
Please help me because I have a meeting with Gantt update and I can't do it.

Please Connexion or Create an account to join the conversation.

Moderators: babynus, protion
Time to create page: 0.040 seconds

Paramétrages de cookies

×

Cookies fonctionnels

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.

Session

Veuillez vous connecter pour voir vos activités!

Autres cookies

Ce site web utilise un certain nombre de cookies pour gérer, par exemple, les sessions utilisateurs.

Login Form