Errors about report-template for one or some users

Question

Some users are not able to see their timesheet or report.

Answer

Errors below may be observed in console log or har file:

Error in xml<status><status-code>500</status-code><message>java.lang.IllegalStateException: Expected STRING but was BEGIN_ARRAY at path $[0]</message><stack-trace>com.google.gson.JsonSyntaxException: java.lang.IllegalStateException: Expected STRING but was BEGIN_ARRAY at path $[0]

at com.google.gson.Gson.fromJson(Gson.java:900)

at com.google.gson.Gson.fromJson(Gson.java:953)

at com.tempoplugin.report.template.service.ReportTemplateSettings$Builder.toArray(ReportTemplateSettings.java:408)

at com.tempoplugin.report.template.service.ReportTemplateSettings$Builder.getValue(ReportTemplateSettings.java:401)

at com.tempoplugin.report.template.service.ReportTemplateSettings$Builder.toMap(ReportTemplateSettings.java:390)

...

If this is the case, back up your Jira database (in case you need to restore it), run the queries below:

SELECT * FROM "AO_86ED1B_REPORT_TEMPLATE" where "OWNER" = "yyy"

where "yyy" is the username of the affected user. And

DELETE FROM "AO_86ED1B_REPORT_TEMPLATE" where "OWNER" = "yyy" and "NAME"="USER_TIMESHEETS_PAGE_SETTINGS"

The last request will delete the timesheet settings for that user. They will be re-made as soon as the user goes to his timesheet again.