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

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 Log in 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 Log in 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 Log in 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 Log in 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 Log in or Create an account to join the conversation.

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

Login Form