Forum

Erroneous Offset in...
 
Notifications
Retirer tout

Erroneous Offset in Work Reports

5 Posts
3 Utilisateurs
0 Reactions
2,830 Vu
(@nea)
Posts: 1
New Member
Début du sujet
 
[#2645]

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


 
Posté : 13 Oct PM 13:1010
(@babynus)
Posts: 14952
Membre Admin
 

Please check work table.
Check that in this table, wekk number really fits day of work.


 
Posté : 15 Oct PM 21:1010
(@staiger)
Posts: 3
Active Member
 

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.


 
Posté : 19 Oct PM 13:1010
(@staiger)
Posts: 3
Active Member
 

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?


 
Posté : 19 Oct PM 13:1010
(@babynus)
Posts: 14952
Membre Admin
 

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


 
Posté : 19 Oct PM 13:1010
Share:
Retour en haut