Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Include Page
Tempo for Data Center Header
Tempo for Data Center Header
Page Properties

Question

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

Answer

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

Code Block
languagexml
Error in
xml
<status><status
 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:

Code Block
languagesql
SELECT * FROM "AO_86ED1B_REPORT_TEMPLATE" where "OWNER" = "yyy"

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


and

And

Code Block
languagesql
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.