search

codbex / codbex-aion

Timesheet Management Application
https://codbex.com
Eclipse Public License 2.0
1 stars 2 forks source link

[Jobs] Send weekly reminder issue with PostgreSQL #53

Closed ThuF closed 1 year ago

ThuF commented 1 year ago 
2022-12-14 08:42:02.220 [ERROR] [http-nio-8080-exec-3] o.e.d.r.c.s.GeneralExceptionHandler - org.graalvm.polyglot.PolyglotException: ERROR: syntax error at or near ")"
  Position: 336
java.lang.RuntimeException: org.graalvm.polyglot.PolyglotException: ERROR: syntax error at or near ")"
  Position: 336
        at org.eclipse.dirigible.graalium.handler.GraaliumJavascriptHandler.handleRequest(GraaliumJavascriptHandler.java:70) ~[dirigible-engine-graalium-execution-handler-6.3.28.jar:na]

Caused by: org.graalvm.polyglot.PolyglotException: ERROR: syntax error at or near ")"
  Position: 336
        at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2676) ~[remotecontent%3Ffilepath=org%252Fpostgresql%252Fpostgresql%252F42.5.0%252Fpostgresql-42.5.0.jar:42.5.0]
        at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2366) ~[remotecontent%3Ffilepath=org%252Fpostgresql%252Fpostgresql%252F42.5.0%252Fpostgresql-42.5.0.jar:42.5.0]
        at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:356) ~[remotecontent%3Ffilepath=org%252Fpostgresql%252Fpostgresql%252F42.5.0%252Fpostgresql-42.5.0.jar:42.5.0]
        at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:496) ~[remotecontent%3Ffilepath=org%252Fpostgresql%252Fpostgresql%252F42.5.0%252Fpostgresql-42.5.0.jar:42.5.0]
        at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:413) ~[remotecontent%3Ffilepath=org%252Fpostgresql%252Fpostgresql%252F42.5.0%252Fpostgresql-42.5.0.jar:42.5.0]
        at org.postgresql.jdbc.PgPreparedStatement.executeWithFlags(PgPreparedStatement.java:190) ~[remotecontent%3Ffilepath=org%252Fpostgresql%252Fpostgresql%252F42.5.0%252Fpostgresql-42.5.0.jar:42.5.0]
        at org.postgresql.jdbc.PgPreparedStatement.executeQuery(PgPreparedStatement.java:134) ~[remotecontent%3Ffilepath=org%252Fpostgresql%252Fpostgresql%252F42.5.0%252Fpostgresql-42.5.0.jar:42.5.0]
        at com.zaxxer.hikari.pool.ProxyPreparedStatement.executeQuery(ProxyPreparedStatement.java:52) ~[HikariCP-5.0.1.jar:na]
        at com.zaxxer.hikari.pool.HikariProxyPreparedStatement.executeQuery(HikariProxyPreparedStatement.java) ~[HikariCP-5.0.1.jar:na]
        at org.eclipse.dirigible.api.v3.db.DatabaseFacade.query(DatabaseFacade.java:272) ~[dirigible-api-facade-database-6.3.28.jar:na]
        at <js>.exports.execute(db/v4/query:22) ~[na:na]
        at <js>.:program(sendWeeklyReminder.js:27) ~[na:na]
        at org.graalvm.polyglot.Context.eval(Context.java:399) ~[graal-sdk-22.3.0.jar:na]
        at org.eclipse.dirigible.graalium.core.javascript.GraalJSCodeRunner.run(GraalJSCodeRunner.java:176) ~[dirigible-engine-graalium-execution-6.3.28.jar:na]
        at org.eclipse.dirigible.graalium.core.DirigibleJavascriptCodeRunner.run(DirigibleJavascriptCodeRunner.java:137) ~[dirigible-engine-graalium-execution-core-6.3.28.jar:na]
        at org.eclipse.dirigible.graalium.handler.GraaliumJavascriptHandler.handleRequest(GraaliumJavascriptHandler.java:64) ~[dirigible-engine-graalium-execution-handler-6.3.28.jar:na]
        ... 71 common frames omitted