View ProjeQtOr On SourceForge.net
ProjeQtOr - Project Management Tool
Supportez nous sur Capterra
OIN - Open Invention Network
ProjeQtOr free project management software - Erroneous Offset in Work Reports - ProjeQtOr

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)

  
 

Planifiez avec ProjeQtOr

14 et 15 mai 2025 (9h-12h30)

18 et 19 juin 2025 (9h-12h30)

  
 

Administrez avec ProjeQtOr

20 et 21 mai (9h-12h30)

25 et 26 juin (9h-12h30)

  

 

 

Erroneous Offset in Work Reports

More
13 Oct 2015 11:50 #1 by Nea
Erroneous Offset in Work Reports was created by Nea
Hello babynus,
I detected an error in the work reports, all but Overview of Work per Activity. The error belongs to one task in one week, where 9.5 hours too much are indicated, see screenshots. This value is added, independent of the specified work in that week.
I do not know where to correct this offset in hours, please help.

Kind regards
Attachments:

Please Connexion or Create an account to join the conversation.

More
15 Oct 2015 19:06 #2 by babynus
Replied by babynus on topic Erroneous Offset in Work Reports
Please check work table.
Check that in this table, wekk number really fits day of work.
Babynus
Administrator of ProjeQtOr web site

Please Connexion or Create an account to join the conversation.

More
19 Oct 2015 11:31 #3 by Staiger
Replied by Staiger on topic Erroneous Offset in Work Reports
I just had a look into the database.
The entry into the work table seems to be correct:
+------+------------+-----------+----------+-------+--------------+---------+------------+----------+--------+--------+------+-----------+--------+--------+---------------+
| id   | idResource | idProject | refType  | refId | idAssignment | work    | workDate   | day      | week   | month  | year | dailyCost | cost   | idBill | idWorkElement |
+------+------------+-----------+----------+-------+--------------+---------+------------+----------+--------+--------+------+-----------+--------+--------+---------------+
| 6332 |         30 |        35 | Activity |  2030 |         1747 | 1.18750 | 2015-07-31 | 20150731 | 201531 | 201507 | 2015 |    680.00 | 807.50 |   NULL |          NULL |
+------+------------+-----------+----------+-------+--------------+---------+------------+----------+--------+--------+------+-----------+--------+--------+---------------+
But the assignment for this entry does not exist any more.
It seems that work allocated to deleted assignments can exist in the database and is displayed in the reports but not in the real work allocation page.
The assignment was broken after a server shutdown during a commit by a user.
After that the assignment could be deleted while work was still associated with this assignment.
No manual database manipulation has been made.

Please Connexion or Create an account to join the conversation.

More
19 Oct 2015 11:34 #4 by Staiger
Replied by Staiger on topic Erroneous Offset in Work Reports
Is it safe for us to delete the line from the work table without any side-effects?
Is there a kind of integrity check tool for the database?

Please Connexion or Create an account to join the conversation.

More
19 Oct 2015 11:40 #5 by babynus
Replied by babynus on topic Erroneous Offset in Work Reports

Is it safe for us to delete the line from the work table without any side-effects?

Yes.
Then you should make some change on Activity #2030 to be sure that all consolidated data is correctly updated.

Is there a kind of integrity check tool for the database?

No
Babynus
Administrator of ProjeQtOr web site

Please Connexion or Create an account to join the conversation.

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