Timesheep plugin don't show old records after update
Hello,
After upgrading Jira from 5.x to 6.1.5 and Timesheet plugin to v2.7.5#629:7101d086c859 we're experiencing with worklog issues - can't see before-upgrade worklog for some users, but new ones are displayed well. We've found, that before upgrade, those users were logged in Jira DB worklog table in AUTHOR column with Uppercase usernames, but after update - with lowercase. e.g:
mysql> select * from worklog where AUTHOR='Bohdan.Hotskyy' order by UPDATED desc limit 10; +-------+---------+----------------+------------+-----------+--------------------------------+---------------------+----------------+---------------------+---------------------+------------+ | ID | issueid | AUTHOR | grouplevel | rolelevel | worklogbody | CREATED | UPDATEAUTHOR | UPDATED | STARTDATE | timeworked | +-------+---------+----------------+------------+-----------+--------------------------------+---------------------+----------------+---------------------+---------------------+------------+ | 61804 | 43882 | bohdan.hotskyy | NULL | NULL | | 2014-01-21 09:44:04 | bohdan.hotskyy | 2014-01-21 09:44:04 | 2014-01-21 09:43:00 | 28800 | | 61803 | 43882 | bohdan.hotskyy | NULL | NULL | | 2014-01-21 09:41:19 | bohdan.hotskyy | 2014-01-21 09:41:19 | 2014-01-20 09:41:00 | 28800 | | 61451 | 28542 | Bohdan.Hotskyy | NULL | NULL | Big Data Sprint 5 presentation | 2014-01-17 09:48:30 | Bohdan.Hotskyy | 2014-01-17 09:48:30 | 2014-01-17 09:48:00 | 7200 | | 61398 | 43506 | Bohdan.Hotskyy | NULL | NULL | | 2014-01-17 04:07:15 | Bohdan.Hotskyy | 2014-01-17 04:07:15 | 2014-01-17 04:07:00 | 7200 | | 61397 | 43506 | Bohdan.Hotskyy | NULL | NULL | | 2014-01-17 04:06:59 | Bohdan.Hotskyy | 2014-01-17 04:06:59 | 2014-01-16 04:06:00 | 12600 | | 61300 | 43374 | Bohdan.Hotskyy | NULL | NULL | | 2014-01-16 06:59:36 | Bohdan.Hotskyy | 2014-01-16 06:59:36 | 2014-01-16 06:59:00 | 7200 | | 61268 | 43508 | Bohdan.Hotskyy | NULL | NULL | | 2014-01-16 04:11:07 | Bohdan.Hotskyy | 2014-01-16 04:11:07 | 2014-01-16 04:11:00 | 9000 | | 61267 | 43508 | Bohdan.Hotskyy | NULL | NULL | | 2014-01-16 04:08:23 | Bohdan.Hotskyy | 2014-01-16 04:08:23 | 2014-01-15 04:08:00 | 28800 | | 61266 | 43508 | Bohdan.Hotskyy | NULL | NULL | | 2014-01-16 04:07:54 | Bohdan.Hotskyy | 2014-01-16 04:07:54 | 2014-01-14 04:07:00 | 21600 | | 61025 | 43508 | Bohdan.Hotskyy | NULL | NULL | | 2014-01-14 03:44:50 | Bohdan.Hotskyy | 2014-01-14 03:44:50 | 2014-01-13 03:44:00 | 5400 | +-------+---------+----------------+------------+-----------+--------------------------------+---------------------+----------------+---------------------+---------------------+------------+ 10 rows in set (0.03 sec)
As you can see, after 2014-01-17 AUTHOR field has been changed to lowercase. We've updated one record to lowercase and after that this record is availbale in Timesheet plugin, so, to display all records we have to update all users and their records. Is there any other more high-level workaround on this?
Thanks in advance.
P.S. this issue is a blocker for us.
Comments (8)
-
-
reporter - attached timesheet_configuration.png
- attached timesheet_gadget_configuration.png
Timesheet configuration
-
reporter Hi Andriy,
We're using this plugin for Time reporting. I've checked Pivot and it doesn't show old records as well. Attached screenshots are timesheet configuration. Thanks.
-
Looks like in this particular case (timesheet_gadget_configuration.png) you need to fix records in database.
Actually I believe they should have changed upon JIRA upgrade automatically, see JRA-33074, there must be an upgrade task for this.
However it's strange that Pivot does not show all records. In all other cases plugin just gets all records, but when you specify user name, it filters them by that name, and it's not possible to use toLowerCase on that case (TimesheetService#line 92)
So, strictly, I'm not sure why it's not working, thus I can't think of proper solution, beside the workaround you've suggested. Sorry.
-
reporter Andriy,
I forgot to mention, that Pivot report shows users, but with "0" in worklog column.
Ok, we'll update fields directly in Jira DB. Thanks for your help.
P.S. Please decide whether to close this ticket.
-
- changed status to resolved
-
- changed status to resolved
-
- removed version
Removing version: 2.7 (automated comment)
- Log in to comment
Hi Roman,
Could you please clarify plugin use case, is it Timesheet with some configuration options?
Have you checked if Pivot is showing all data?
Note, I thought it is solved for all cases, see Issue
#347for example.Thank you.