Timesheep plugin don't show old records after update

[Roman Melko]

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.

[Andriy Zhdanov]

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#347 for example.

Thank you.

[Roman Melko]

Timesheet configuration

[Roman Melko]

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.

[Andriy Zhdanov]

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.

[Roman Melko]

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.