1. Tempo Avatar Tempo
  2. Prime
  3. servertimesheet
  4. Issues

Wrong sums for different iterations in a time period

Issue #1172 resolved
Niklaus Hählen created an issue

Hi there We are using your great plugin since ca. 1 year and it really helps for invoicing our external team. On saturday we recognized that the amount of hours over the whole September is not the same like if we report it for each week and summarize the iterations.

Our case: 3 Developer * Whole September = 343.42 hrs (Screenshot 1) * Sum of iterations 1.-3. / 4.-10. / 11.-17. / 18.-24. / 25.-30. = 395.51 hrs (Screenshots 2 - 6)

We tessted also different iterations: * 1.-15. / 16.-30. = 395.42 hrs * 1.-24. / 25.-30. = 357.08 hrs

Strange.... Which data are correct? At least it's a show stopper, because we need to trust these data...

Added the csv file.

THx for any investigation and solution in advance... Niklaus

Comments (34)

  1. Andriy Zhdanov

    Hi Niklaus,

    Could you please try to collect support data, 3 times, to let me reproduce it locally?

    1) Whole Semptember 2) 1 - 15 3) 16 - 30

    Enable Track Support Data option in add-on configuration, then reload report and click Download Support Zip button.

    Send it to support@jiratimesheet.com. Note, you may need to change extension to something else to let it pass through. Or create private service request here

    Thank you.

  2. Marcel van den Bos

    We are experiencing the same problem. The totals for weekview are different from the monthview when using 'All Users'. A worked user has in last week of september: - 17.52h in weekview - 0h in monthview (more in other weeks) When adding the user to the filter the totals are correct, but when switching back to all users it's wrong again. We are in big problems now since we have to close the month so please fix this asap!

  3. Oleksandr Velytchenko

    Hi Marcel

    seems you have similar but not the same issue, could you please try to collect support data, 2 times (user and no user), to let us reproduce it locally? Send it please to support@jiratimesheet.com

    Best regards.

  5. Andriy Zhdanov

    Hi Marcel,

    It's more important if you send supportData.zip as requested. Separate issue is not required, though.

    Thank you.

  8. Andriy Zhdanov

    Hi Marcel,

    Could you please try if running monthly report several times produces the same Total result all the time?

    And also please clarify, whether you use Store Worklog option in add-on configuration?

    Thank you.

  10. Andriy Zhdanov

    Hi Marcel, Niklaus,

    I seem have found a problem, and fixed it, could you please try if it works better?

    Thank you.

  11. Marcel van den Bos

    Still the same for us I am afraid.

    Verzonden: 04 October 2017 13:16 Onderwerp: Re: [Bitbucket] Issue #1172: Wrong sums for different iterations in a time period (azhdanov/jiratimesheet)

    [azhdanov] Andriy Zhdanov commented on issue #1172: Wrong sums for different iterations in a time periodhttps://bitbucket.org/azhdanov/jiratimesheet/issues/1172/wrong-sums-for-different-iterations-in-a

    Hi Marcel, Niklaus,

    I seem have found a problem, and fixed it, could you please try now if it works better?

    Thank you.

    View this issuehttps://bitbucket.org/azhdanov/jiratimesheet/issues/1172/wrong-sums-for-different-iterations-in-a or add a comment by replying to this email.

    Unwatch this issuehttps://bitbucket.org/api/1.0/repositories/azhdanov/jiratimesheet/issue/1172/unwatch/WoningNet/b799b67ef3991ece777a1016c7b43d3ec8f26614/ to stop receiving email updates. [Bitbucket] https://bitbucket.org

  12. Andriy Zhdanov

    Hi Marcel,

    Sorry for bothering in vain, I've realised that too, and have just applied another fix, could you please try again?

    Thank you.

  13. Marcel van den Bos

    No problem, love to help out. Still the same. All requests some to have status 200 except 1

    1. Request URL: https://activity.atlassian.io/api/client/recent/containers?cloudId=dc5a6a2b-c603-4e17-9bf7-a2c639547f51
    2. Request Method: GET
    3. Status Code: 401 Unauthorized
    4. Remote Address: 34.234.151.90:443
    5. Referrer Policy: no-referrer-when-downgrade
    6. Response Headersview source
    7. Access-Control-Allow-Credentials: true
    8. Access-Control-Allow-Origin: https://woningnet2.atlassian.net
    9. Connection: keep-alive
    10. Content-Encoding: gzip
    11. Content-Type: application/json;charset=UTF-8 Wed, 04 Oct 2017 13:09:18 GMT
    12. transfer-encoding: chunked
    13. Vary: Origin
    14. WWW-Authenticate: Unauthorized
    15. Request Headersview source
    16. Accept: application/json,text/javascript,/
    17. Accept-Encoding: gzip, deflate, br
    18. Accept-Language: nl-NL,nl;q=0.8,en-US;q=0.6,en;q=0.4
    19. Connection: keep-alive
    20. Content-Type: application/json
    21. Host: activity.atlassian.io
    22. Origin: https://woningnet2.atlassian.net
    23. Referer: https://woningnet2.atlassian.net/plugins/servlet/ac/jira-timesheet-plugin/timereports
    24. User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/61.0.3163.100 Safari/537.36
    25. Query String Parametersview sourceview URL encoded
    26. cloudId: dc5a6a2b-c603-4e17-9bf7-a2c639547f51

    Verzonden vanuit Mailhttps://go.microsoft.com/fwlink/?LinkId=550986 voor Windows 10

    Verzonden: 04 October 2017 15:06 Onderwerp: Re: [Bitbucket] Issue #1172: Wrong sums for different iterations in a time period (azhdanov/jiratimesheet)

    [azhdanov] Andriy Zhdanov commented on issue #1172: Wrong sums for different iterations in a time periodhttps://bitbucket.org/azhdanov/jiratimesheet/issues/1172/wrong-sums-for-different-iterations-in-a

    Hi Marcel,

    Sorry for bothering in vain, I've realised that too, and have just applied another fix, could you please try again?

    Thank you.

    View this issuehttps://bitbucket.org/azhdanov/jiratimesheet/issues/1172/wrong-sums-for-different-iterations-in-a or add a comment by replying to this email.

    Unwatch this issuehttps://bitbucket.org/api/1.0/repositories/azhdanov/jiratimesheet/issue/1172/unwatch/WoningNet/b799b67ef3991ece777a1016c7b43d3ec8f26614/ to stop receiving email updates. [Bitbucket] https://bitbucket.org

  14. Andriy Zhdanov

    Could you please try once more? You may need to reload page without cache, e.g. with Ctrl+Shift+R

  15. Marcel van den Bos

    Still the same, without the 401

    Verzonden: 04 October 2017 15:26 Onderwerp: Re: [Bitbucket] Issue #1172: Wrong sums for different iterations in a time period (azhdanov/jiratimesheet)

    [azhdanov] Andriy Zhdanov commented on issue #1172: Wrong sums for different iterations in a time periodhttps://bitbucket.org/azhdanov/jiratimesheet/issues/1172/wrong-sums-for-different-iterations-in-a

    Could you please try once more? You may need to reload page without cache, e.g. with Ctrl+Shift+R

    View this issuehttps://bitbucket.org/azhdanov/jiratimesheet/issues/1172/wrong-sums-for-different-iterations-in-a or add a comment by replying to this email.

    Unwatch this issuehttps://bitbucket.org/api/1.0/repositories/azhdanov/jiratimesheet/issue/1172/unwatch/WoningNet/b799b67ef3991ece777a1016c7b43d3ec8f26614/ to stop receiving email updates. [Bitbucket] https://bitbucket.org

  16. Niklaus Hählen Account Deactivated reporter

    Here still strange...

    I did a few refreshs of the monthly report, just with F5 and CTRL+F5 and reloaded the report. Output check here, please: https://web.tresorit.com/l#SO8OmCaBnsAJ4nm3EDut6A

    Excel-Sheet: Outputs and assigned Support Data. Please check: In the first case is the reported sum different from the calculated sum!

    BTW: The output is far away from the expected result for Napora for example, he has worked ~160 hours - I guess he logged them, his salary depends on that...

    Thx for your support! Niklaus

  17. Andriy Zhdanov

    Hi Marcel,

    Sorry, I forgot you're using Timesheet Reports and Gadgets, and fix was not applied there, until now. Could you please try again?

    Note, I think Niklaus is using Time Reports, and both plugins are the same, beside some features, as described here

    Thank you.

  18. Marcel van den Bos

    Ah ok, well still the same 😉

    Verzonden: 04 October 2017 16:34 Onderwerp: Re: [Bitbucket] Issue #1172: Wrong sums for different iterations in a time period (azhdanov/jiratimesheet)

    [azhdanov] Andriy Zhdanov commented on issue #1172: Wrong sums for different iterations in a time periodhttps://bitbucket.org/azhdanov/jiratimesheet/issues/1172/wrong-sums-for-different-iterations-in-a

    Hi Marcel,

    Sorry, I forgot you're using Timesheet Reports and Gadgets, and fix was not applied there, until now. Could you please try again?

    Note, I think Niklaus is using Time Reports, and both plugins are the same, beside some features, as described herehttps://www.jiratimesheet.com/cloud/

    Thank you.

    View this issuehttps://bitbucket.org/azhdanov/jiratimesheet/issues/1172/wrong-sums-for-different-iterations-in-a or add a comment by replying to this email.

    Unwatch this issuehttps://bitbucket.org/api/1.0/repositories/azhdanov/jiratimesheet/issue/1172/unwatch/WoningNet/b799b67ef3991ece777a1016c7b43d3ec8f26614/ to stop receiving email updates. [Bitbucket] https://bitbucket.org

  19. Andriy Zhdanov

    Oh no!

    Well, would you be able to provide supportData.zip?

    You need to enable Track Support Data option in add-on configuration, then reload report and click Download Support Zip button.

    Thank you.

  20. Niklaus Hählen Account Deactivated reporter

    Hi there The issue seems to be solved in our case :)

    Thx @ Andriy for his quick and competent support! Have a big beer and a nice evening.

    Best regards Niklaus

  28. Andriy Zhdanov

    Could you please try switching off Store Worklog option in add-on configuration as workaround?

  30. Andriy Zhdanov

    Sure, I will try to get it working too, but might be not that fast, too many troubles, sorry.

  31. Marcel van den Bos

    And it would be good to think about ways to prevent these kind of problems. There are ways to automatically validate results after changes or you can make one. But perhaps you are aware of this 😉 Thanks again for the support.

    Verzonden: 05 October 2017 13:37 Onderwerp: Re: [Bitbucket] Issue #1172: Wrong sums for different iterations in a time period (azhdanov/jiratimesheet)

    [azhdanov] Andriy Zhdanov commented on issue #1172: Wrong sums for different iterations in a time periodhttps://bitbucket.org/azhdanov/jiratimesheet/issues/1172/wrong-sums-for-different-iterations-in-a

    Sure, I will try to get it working too, but might be not that fast, too many troubles, sorry.

    View this issuehttps://bitbucket.org/azhdanov/jiratimesheet/issues/1172/wrong-sums-for-different-iterations-in-a or add a comment by replying to this email.

    Unwatch this issuehttps://bitbucket.org/api/1.0/repositories/azhdanov/jiratimesheet/issue/1172/unwatch/WoningNet/b799b67ef3991ece777a1016c7b43d3ec8f26614/ to stop receiving email updates. [Bitbucket] https://bitbucket.org

  32. Oleksandr Velytchenko

    Hi Marcel

    I have just noticed discrepancy in periods in your very first screenshoots (1-30 and 24-30) I have tried to check it on my jira instance and find out period changing on pressing month/week view button. But if i manually correct period, I have received same totals.

    The same with 'Store Worklog' option.

    Could you please doublecheck if manual period correction returns ptoper totals.

    Thank you.

  33. Marcel van den Bos

    No it does not

    Verzonden: 05 October 2017 16:20 Onderwerp: Re: [Bitbucket] Issue #1172: Wrong sums for different iterations in a time period (azhdanov/jiratimesheet)

    [avelytchenko] Oleksandr Velytchenko commented on issue #1172: Wrong sums for different iterations in a time periodhttps://bitbucket.org/azhdanov/jiratimesheet/issues/1172/wrong-sums-for-different-iterations-in-a

    Hi Marcel

    I have just noticed discrepancy in periods in your very first screenshoots (1-30 and 24-30) I have tried to check it on my jira instance and find out period changing on pressing month/week view button. But if i manually correct period, I have received same totals.

    The same with 'Store Worklog' option.

    Could you please doublecheck if manual period correction returns ptoper totals.

    Thank you.

    View this issuehttps://bitbucket.org/azhdanov/jiratimesheet/issues/1172/wrong-sums-for-different-iterations-in-a or add a comment by replying to this email.

    Unwatch this issuehttps://bitbucket.org/api/1.0/repositories/azhdanov/jiratimesheet/issue/1172/unwatch/WoningNet/b799b67ef3991ece777a1016c7b43d3ec8f26614/ to stop receiving email updates. [Bitbucket] https://bitbucket.org

  35. Log in to comment
Assignee
–
Type
bug
Priority
blocker
Status
resolved
Component
Time Reports
Version
2.9
Votes
1
Watchers
1