To learn more about Tempo products, please visit our Help Center. For support, see our Support Portal.

Errors about report-template for one or some users

By Richie Zhu

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.

Related content