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

JIRA Timesheet Reports and Gadgets plugin throwing error

Issue #627 resolved
Gavad Khan created an issue

JIRA Timesheet Reports and Gadgets plugin throwing following error. Frequency of error ir huge. Please look into and let us how we can fix this?

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ 2015-04-27 03:59:27,316 http-bio-8080-exec-103 ERROR ppuri3 239x157282x6 zgbfae 14.140.116.135,172.18.11.240,172.18.12.171 /rest/timesheet-gadget/1.0/timesheet.json [fdu.jira.util.TextUtil] Field 'customfield_21500' does not exist 2015-04-27 03:59:27,336 http-bio-8080-exec-103 ERROR ppuri3 239x157282x6 zgbfae 14.140.116.135,172.18.11.240,172.18.12.171 /rest/timesheet-gadget/1.0/timesheet.json [fdu.jira.util.TextUtil] Field 'customfield_21500' does not exist 2015-04-27 03:59:27,360 http-bio-8080-exec-103 ERROR ppuri3 239x157282x6 zgbfae 14.140.116.135,172.18.11.240,172.18.12.171 /rest/timesheet-gadget/1.0/timesheet.json [fdu.jira.util.TextUtil] Field 'customfield_21500' does not exist 2015-04-27 03:59:27,382 http-bio-8080-exec-103 ERROR ppuri3 239x157282x6 zgbfae 14.140.116.135,172.18.11.240,172.18.12.171 /rest/timesheet-gadget/1.0/timesheet.json [fdu.jira.util.TextUtil] Field 'customfield_21500' does not exist 2015-04-27 03:59:27,428 http-bio-8080-exec-103 ERROR ppuri3 239x157282x6 zgbfae 14.140.116.135,172.18.11.240,172.18.12.171 /rest/timesheet-gadget/1.0/timesheet.json [fdu.jira.util.TextUtil] Field 'customfield_21500' does not exist ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

See attached file for more error details

Comments (16)

  1. Andriy Zhdanov

    Hi Gavad,

    Looks there's timesheet gadget configured on system dashboard, so every user causes this message in log. Could you please check and probably fix the configuration of the problematic gadget. The point is that it refers to a custom field that is apparently removed.

    Thank you.

  2. Gavad Khan reporter

    Thanks for your update. That's really helpful.

    Can you please help me how I can quickly search problematic gadget & referenced dashboard? Is there a way I can make DB query (or text search JIRA full xml backup) based on custom field id?

    Thanks, Gavad

  3. Andriy Zhdanov

    Sorry, no. I think the easiest way is to look at System Dashboard gadgets, the one that is problematic shoud be reconfigured.

    Alternatively, you may try to work it out basing on the Migration guide wiki page.

  4. Andriy Zhdanov

    Hi Gavad,

    Version 2.8.3.4 is available with minor improvement in this concern. Now in gadgets if additional field is used, which is no longer available, it will be shown as N/A, so user can identify a problem sooner.

    Thank you.

    Thank you.

  5. Former user Account Deleted

    Hi Andriy

    We are using the version - "2.8.2.7-JRA-32510" and can see N/A in front end in the "Executive summary gadget" and still getting the Time-sheet errors.

    We have found ,the total no of gadgets in which 'customfield_21500' is used is 25 using the query -> select b., a. from gadgetuserpreference a, portletconfiguration b where b.id=a.PORTLETCONFIGURATION and b.GADGET_XML like '%timesheet-gadget/timesheet-gadget.xml%' and a.USERPREFVALUE like '%21500%'

    Kindly suggest how can we remove this field from the gadgets so that we do not get the error. I am attaching the screenshot for your reference on "Executive summary gadget".customfield_21500_NA.jpg

  6. Andriy Zhdanov

    Hi Ankur,

    I believe it should be possible to execute a query that updates gadget configuration to remove usage of the customfield_21500, e.g.: update gadgetuserpreference set userpefvalue="field1|field2..." where id=102012, wehre fieldN is all fields beside customfield_21500, and id is different for each of 25 occurencies, to make it absolutely accurately.

    Otherwise, you may look if it used on different dashsboards (see portalpage column) and configure gadgets on dashboard, just opening configuration and saving should be sufficient.

    Thank you.

  7. Former user Account Deleted

    Thanks for helping, need some more details.

    • If we update through the query , then we have to restart the JIRA application to reflect the changes, so is there any way the changes reflect without restarting the JIRA application after running the update query.

    • There are some users who have left the organization and they are the owners of those dashboard ,then please suggest how can we edit those dashboards from the front end so that the error gets resolved.

  8. Andriy Zhdanov

    Well, I'm not sure about all this, but

    • I think JIRA should pick up changes shortly, in other case, it should be safe to restart JIRA later at your convenience.

    • I think Administrator should have access to all dashboards.

  9. Gavad Khan reporter

    Hi Andriy,

    We have fixed all affected dashboard gadgets user preference value (removed deleted field) and with the help of below query, we have verified now none of the dashboard gadgets is referencing this deleted custom field 'customfield_21500' but why JIRA instance still throwing this error ("/rest/timesheet-gadget/1.0/timesheet.json [fdu.jira.util.TextUtil] Field 'customfield_21500' does not exist"). Considering the huge frequency of this error message, this is become a very IO sensitive matter and we need urgent fix for this issue. Can you please let us know how we can fix this? If you need any screen share session to investigate our JIRA instance data, please let us know we will arrange the same. Please help?

    select a.* from gadgetuserpreference a, portletconfiguration b
where b.id=a.PORTLETCONFIGURATION
and b.GADGET_XML like '%timesheet-gadget/timesheet-gadget.xml%'
and a.USERPREFVALUE like  '%21500%'

    Thanks, Gavad

  10. Andriy Zhdanov

    Hi Gavad,

    Was JIRA restarted already? Also I think user browser page needs to be reloaded to make changes into effect.

    Is exception the same now? It may be possible that Report link is bookmarked.From report it should have secure/ConfigureReport.jspa in stack trace.

    Thank you.

  11. Former user Account Deleted

    Hi Andriy

    • Yes the JIRA was restarted.
    • How can the user browser page be reloaded to make changes into effect for all the users in the instance.
    • Yes the exception is same,I am attaching the logs for your reference - 2015-08-06 10:22:59,938 http-bio-8080-exec-486 ERROR ssahay 621x294346x8 tmi445 14.140.116.135,172.18.11.240,172.18.12.169 /rest/timesheet-gadget/1.0/timesheet.json [fdu.jira.util.TextUtil] Field 'customfield_21500' does not exist
    • What do you mean by Report link is bookmarked & what is the solution of it.
  13. Andriy Zhdanov

    HI Ankur,

    Thank you for clarifying. I don't know how to make all users reload dashboard page.

    If exception is the same, no need to worry about report page.

    All I can do now, is to suppress those log messages in code. Update should be available next week.

    Thank you.

  16. Andriy Zhdanov

    Hi Ankur,

    Version 2.9.1 with the change to log INFO message if field is not find is released.

    Please let me know if you can update to latest version, instead of using patched old version.

    Thank you.

  17. Log in to comment
Assignee
–
Type
bug
Priority
critical
Status
resolved
Component
Time Sheet report and gadget
Version
2.8
Votes
0
Watchers
1