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: 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.

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.