Need help with this error that just started popping up.. can't find fix


If you have any errors in the report and you would like to see more details on this, you can check out System Events and check the Payload information about a particular error.

The error “syntax error at or near” might refer to some database problems. Please try to disable and enable eazyBI add-on in Jira.

If the error still remains please send eazyBI log files. You can send them via email to email or upload them in our contact form. Please share a report definition to the email as well.

Daina /

Here is an example of the error in the system events log:
“cube”: “Issues”, “cube_table”: “jira_issues_measures”, “cube_report_id”: 23, “embed”: “gadget report”, “…
“cube”: “Issues”,
“cube_table”: “jira_issues_measures”,
“cube_report_id”: 23,
“embed”: “gadget report”,
“initial_query”: true,
“mdx”: “””
WITH MEMBER [Planned For].[AggregatePageMembers] AS ‘AGGREGATE({[Planned For].[Guardium Release 10.1.4],[Planned For].[Guardium Release 10.5],[Planned For].[Guardium Release 10.6],[Planned For].[Guardium Release 11.0],[Planned For].[Guardium Release 11.1],[Planned For].[Guardium Release 11.2]})’
SELECT {[Measures].[Average resolution days]} ON COLUMNS,
ORDER(FILTER(GENERATE(NONEMPTYCROSSJOIN([Reporter].[User].Members, ChildrenSet([Planned For].[AggregatePageMembers])), [Reporter].CurrentMember), ( ([Measures].[Average resolution days]) > 50 )), ([Measures].[Average resolution days]), BDESC) ON ROWS
FROM [Issues]
WHERE ([Planned For].[AggregatePageMembers])
“account_id”: 3,
“user_id”: 3,
“root_cause_message”: “”"
ERROR: syntax error at or near “Release”
Position: 712
“root_cause_backtrace”: [
“root cause: org.postgresql.util.PSQLException: ERROR: syntax error at or near “Release”\n Position: 712”,
“root cause: org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(”,
“root cause: org.postgresql.core.v3.QueryExecutorImpl.processResults(”,
“root cause: org.postgresql.core.v3.QueryExecutorImpl.execute(”,
“root cause: org.postgresql.jdbc.PgStatement.executeInternal(”,
“root cause: org.postgresql.jdbc.PgStatement.execute(”,
“root cause: org.postgresql.jdbc.PgStatement.executeWithFlags(”,
“root cause: org.postgresql.jdbc.PgStatement.executeCachedSql(”,
“root cause: org.postgresql.jdbc.PgStatement.executeWithFlags(”,
“root cause: org.postgresql.jdbc.PgStatement.executeQuery(”,
“root cause: org.apache.commons.dbcp.DelegatingStatement.executeQuery(”,
“mondrian/olap4j/mondrian/olap4j/ createException'", "mondrian/olap4j/mondrian/olap4j/ executeOlapQueryInternal’”,
“mondrian/olap4j/mondrian/olap4j/ executeQuery'", "mondrian/olap4j/mondrian/olap4j/ executeQuery’”,
“java/lang/reflect/java/lang/reflect/ `invoke’”
“exception”: [
“org.olap4j.OlapException: mondrian gave exception while executing query”

will send troubleshooting log file zip to support email next. thanks for help… really stuck here - Ed