Syntax Error of Spotfire

[Maimi Takahashi 2]

Hi,

The following error message was displayed onSpotfire Server.

I think it's a temporary errorsince we've been executing the same query for several years but not reproduced before/after then.

 

Could someone advise me about (1) the reason for the error, and (2) how I can confirm if there's no problem at this moment

 

ERROR 2021-03-09T09:10:39,764+0900 [*pool-3-thread-22, biuser, #83*] ds.sql.SQLQuerySession: Error running union all

select '' as "qe_code", 'transaction' as "qe_name", 'settlement' as "qe_type", t1."transaction_date" AS "qe_date", count(*) as "qe_count"

from "public"."trn_execution" t1

where

(t1."trade_type" = 1) AND (t1."deleted" = 0)

AND

group by t1."transaction_date"

org.postgresql.util.PSQLException: ERROR: Syntax error with "union" or near (10474) (10620)

Position: 1

at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2096)

at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1829)

at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)

at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:510)

at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:372)

at org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:300)

at com.spotfire.server.util.sql.WrappedStatement.executeUpdate(WrappedStatement.java:110)

at com.spotfire.ws.im.ds.sql.SQLQuerySession.close(SQLQuerySession.java:458)

at com.spotfire.ws.im.ds.sql.SQLQuerySession.getData(SQLQuerySession.java:382)

at com.spotfire.ws.im.ds.sql.SQLDataSource.doGetData(SQLDataSource.java:370)

at com.spotfire.ws.dat.AbstractOperator.getData(AbstractOperator.java:290)

at com.spotfire.ws.dat.Pipe.doGetData(Pipe.java:135)

at com.spotfire.ws.im.QueryPipe.doGetData(QueryPipe.java:201)

at com.spotfire.ws.dat.AbstractOperator.getData(AbstractOperator.java:290)

at com.spotfire.ws.dat.Formatter.getNextRow(Formatter.java:155)

at com.spotfire.ws.dat.sbdf.formatter.SpotfireBinaryDataFormatter.getDataForSlice(SpotfireBinaryDataFormatter.java:387)

at com.spotfire.ws.dat.sbdf.formatter.SpotfireBinaryDataFormatter.writeData(SpotfireBinaryDataFormatter.java:241)

at com.spotfire.ws.dat.sbdf.formatter.SpotfireBinaryDataFormatter.getData(SpotfireBinaryDataFormatter.java:193)

at com.spotfire.ws.dat.Job$GetDataTask.execute(Job.java:815)

at com.spotfire.ws.dat.Job$Task.run(Job.java:661)

at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)

at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)

at java.lang.Thread.run(Thread.java:745)

[Gaia Paolini]

I think it would be best to open a support case