Errors about report-template for one or some users

This article is for Tempo for Data Center.

Question

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

Answer

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

XML

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:

SQL

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

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

SQL

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.