View ProjeQtOr On SourceForge.net
ProjeQtOr - Project Management Tool
Support us on Capterra
OIN - Open Invention Network
ProjeQtOr free project management software - [SOLVED] Real work allocation - Bad allocation after input - Page 2 - ProjeQtOr
 
 

[SOLVED] Real work allocation - Bad allocation after input

More
21 Aug 2016 23:30 #7 by babynus
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 Log in or Create an account to join the conversation.

More
22 Aug 2016 01:46 #8 by fredparis
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 Log in or Create an account to join the conversation.

More
24 Aug 2016 21:01 #9 by babynus
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 Log in or Create an account to join the conversation.

More
26 Aug 2016 17:43 - 26 Aug 2016 18:29 #10 by fredparis
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 Aug 2016 18:29 by fredparis.

Please Log in or Create an account to join the conversation.

Moderators: babynusprotion
Time to create page: 0.042 seconds

Cookies settings

×

Functional Cookies

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

Please login to see yours activities!

Other cookies

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