View ProjeQtOr On SourceForge.net
ProjeQtOr - Project Management Tool
Supportez nous sur Capterra
OIN - Open Invention Network
ProjeQtOr free project management software - [SOLVED] Real work allocation - Bad allocation after input - Page 2 - 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] Real work allocation - Bad allocation after input

More
21 Aoû 2016 23:30 #7 by babynus
Replied by babynus on topic Real work allocation - Bad allocation after input
Very strange that isse disepeared.
To have a hint, I would need copy of table "work" before correction (if you have some backup).
If seems there were "dupplicate" work input for same day and same assignment, that was summed up.
Babynus
Administrator of ProjeQtOr web site

Please Connexion or Create an account to join the conversation.

More
22 Aoû 2016 01:46 #8 by fredparis
Replied by fredparis on topic Real work allocation - Bad allocation after input
Hi Babynus,

Here are some copies of the table "work" (renamed "pj_work", PJ for ProJeqtor)
- 07/08 : the day just after the first creation of the allocation (which was 05/08/2016)
- 19/08 : the day I wrote my first post here,
- 22/08 : today, with the problem disappeared.

I hope it will be useful
Fred
Attachments:

Please Connexion or Create an account to join the conversation.

More
24 Aoû 2016 21:01 #9 by babynus
Replied by babynus on topic Real work allocation - Bad allocation after input
Hi,
Thanks for the dumps.
It is exactly what I thought
You have 2 lines for the same day (2016-08-05) and same assignment #209, so for same Acitivty #258 and Resource #3


Only way I can image this can happen is that 2 person same at the same time the same input...
But probability for this to happen is very very low...

Anyway, we'll add unique index on next version to avoid this happen again.
Babynus
Administrator of ProjeQtOr web site
Attachments:
The following user(s) said Thank You: fredparis

Please Connexion or Create an account to join the conversation.

More
26 Aoû 2016 17:43 - 26 Aoû 2016 18:29 #10 by fredparis
Replied by fredparis on topic Real work allocation - Bad allocation after input
Hi,

Thanks for analysis.
But I am the only one who use this instance of ProjeQtor. I'm the only user. I promise ! :huh:
And I am not double... unless I have drunk a little bit too much... :woohoo:

Moreover, the problem seems do be away now (cf my dump of the day 22/08).
So, adding a unique index is a good medicine to avoid this in the future.

Thanks !
Fred
Last edit: 26 Aoû 2016 18:29 by fredparis.

Please Connexion or Create an account to join the conversation.

Moderators: babynus, protion
Time to create page: 0.045 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