Uploaded image for project: 'JS - JobScheduler'
  1. JS - JobScheduler
  2. JS-1712

syntax error at or near "not" is raised if JocOrderStatistics is called

    XMLWordPrintable

Details

    • Fix
    • Status: Released (View Workflow)
    • Major
    • Resolution: Fixed
    • None
    • 1.11.2, 1.12
    • None

    Description

      Current Situation

      In an environment with Postgres 9.5 the JobScheduler has no problems to access the database but the
      web service ./jobscheduler/master/api/order?return=JocOrderStatistics
      comes with

      com.sos.scheduler.engine.plugins.newwebservice.routes.ApiRoute [WARN ] - org.postgresql.util.PSQLException: ERROR: syntax error at or near "not"

   Position: 200
           at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2310)
           at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2023)
           at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:217)
           at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:421)

      Desired Behavior

      The web service ./jobscheduler/master/api/order?return=JocOrderStatistics should work properly.

      Attachments

        Issue Links

          is duplicated by

          Fix - JS-1710 HikariPool$PoolInitializationException if JocOrderStatistics is called

          • Major - Major loss of function.
          • Dismissed

          Activity

            People

              jz Joacim Zschimmer
              oh Oliver Haufe
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: