-
Bug
-
Resolution: Fixed
-
High (View bug fix roadmap)
-
7.0.5, 7.0.10
-
7
-
Problem Definition
After migrate JIRA from 6.x to 7.0.x, the Created vs. Resolved gadget is not respecting the "Cumulative Totals" option previously set.
In JIRA 6.x, the gadget had the “Cumulative Totals” option where you can set "Yes" or "No", and in JIRA 7.x has a “Collection Operation” with “Count” or “Cumulative” options.
If you set "Yes" for the “Cumulative Totals” option in JIRA 6.x, after migrate you expect to see the Cumulative option there, however the system is changing it to "Count" instead, so you need to manually edit each Dashboard back to the Cumulative option, which can be a pain if you have a quite few Dashboards.
Steps to Reproduce
- Add a new "Created vs. Resolved gadget" in JIRA 6.4.12
- Select a desired project name (e.g TEST) and change Cumulative Totals: to YES value
- Save the gadget and create a backup out
- Restore the backup to JIRA 7.0.10
- Navigate back to the Dashboard page, you will get the error message below:
Unfortunately, one or more of your preferences are now unavailable. Please update your preferences, or remove gadget by clicking delete from the title bar above. Invalid field. Valid values are [count, cumulative].
Expected Results
If the previously version was configured with Cumulative Totals = Yes, it would be great if the new version (7.0.x) could keep the user's choice by setting Collection Operation = Cumulative.
Or maybe we can add an option to define the default value from this field in JIRA, so all dashboards can use the default value.
Actual Results
In JIRA 6, it was configured with Cumulative Totals = Yes but in the latest JIRA 7, it shows errors.
Workaround
Ask all users to manually edit their Dashboards in case they are using this gadget.
- was cloned as
-
JC-824 Failed to load
[JRASERVER-59364] Created vs. Resolved gadget should respect the Cumulative Totals option set before the upgrade
HI dsenecalb,
We estimate the fix to go out with JIRA Server 7.1.4 next week.
Regards,
Oswaldo Hernández.
JIRA Bugmaster.
[Atlassian].
Hi David:
Could you provide us an ETA for version 7.1.3?
Thanks
Hi everyone,
Thanks for your patience on this issue. We've identified the problem and have a fix that we are currently testing. We estimate that this will ship in JIRA 7.1.3. With the fix, you can expect that your gadgets will pick up the previous cumulative setting unless you have changed them already.
Regards,
David
I created the following T-SQL for SQL Server 2008 that fixes this issue. USE AT YOUR OWN RISK (it seems to have worked for me):
declare @seed NUMERIC(18)
set @seed = (select MAX(id) from gadgetuserpreference) + 1
declare @ID NUMERIC(18)
declare portletIDs cursor local for
select distinct portletconfiguration.ID
from portalpage
join portletconfiguration on portalpage.ID=portletconfiguration.PORTALPAGE
join cwd_user on portalpage.USERNAME=cwd_user.user_name
join app_user on cwd_user.user_name=app_user.user_key
join gadgetuserpreference on portletconfiguration.ID=gadgetuserpreference.PORTLETCONFIGURATION
where portletconfiguration.GADGET_XML like '%createdvsresolved%'
and gadgetuserpreference.USERPREFKEY='isCumulative' and gadgetuserpreference.USERPREFVALUE like 'true'
open portletIDs
fetch next from portletIDs into @ID
while @@FETCH_STATUS = 0
begin
fetch next from portletIDs into @ID
if (select COUNT(*) from gadgetuserpreference where portletconfiguration=@ID and USERPREFKEY='operation') = 0
begin
-- extract the preference type (project|filter) and ID
declare @name varchar(255)
declare @type varchar(255)
declare @projectOrFilterValue varchar(255)
set @name = (select userprefvalue from gadgetuserpreference where portletconfiguration=@ID and USERPREFKEY='projectOrFilterId')
set @type = (select SUBSTRING(@name, 0, CHARINDEX('-', @name)))
set @projectOrFilterValue = (select SUBSTRING(@name, charindex('-', @name) + 1, 100))
insert into gadgetuserpreference values (@seed, @ID, 'id', @projectOrFilterValue)
set @seed = @seed + 1
insert into gadgetuserpreference values (@seed, @ID, 'name', @name)
set @seed = @seed + 1
insert into gadgetuserpreference values (@seed, @ID, 'operation', 'cumulative')
set @seed = @seed + 1
insert into gadgetuserpreference values (@seed, @ID, 'type', @type)
set @seed = @seed + 1
end
else print 'Portlet gadget ' + convert(nvarchar(18), @ID) + ' already configured';
end
close portletIDs
deallocate portletIDs
Zakir Sikder
added a comment - My recommendation would be not to wait to upgrade just for this issue. After the upgrade, all you have to tell the user (whoever using this gadget) to manually change the cumulative total = yes and it will be fine.
Regards!
Zakir Sikder
added a comment - My recommendation would be not to wait to upgrade just for this issue. After the upgrade, all you have to tell the user (whoever using this gadget) to manually change the cumulative total = yes and it will be fine.
Regards! Hi Everyone,
I just want to know any update for this ticket? Keep in mind that this is taking long time for us to upgrade to the latest version of JIRA.
Hi everyone,
Thanks for your feedback. The team is scheduled to investigate the bug next week. We'll give an update as soon as we know more.
Sorry for any inconvenience caused.
Regards,
David
Hi All,
Keep in mind that there are +500 users in our company who rely hardly with this statistics. For us, this widget is very important for us to verify our work speed. Can you provide us an estimate for this fix or if this fix will included into the upcoming release.
Please advise.
Hi:
Also, we found out on version 7.0.10. Since we upgraded from version 7.0.5 (Which previously was upgraded from version 6.2.3). It should be a very fix candidate for 7.1.0. If this bug doesn't get fixed, it would make admin noise.
This affects 7.0.11 as well. Please update the issue. Saves some time