Uploaded image for project: 'JBoss BPMS Platform'
  1. JBoss BPMS Platform
  2. RHBPMS-963

SQLGrammarException when executing task query operations on various DBs

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Done
    • Icon: Blocker Blocker
    • 6.2.0
    • 6.2.0
    • Business Central
    • None

      Description of problem:
      When you try to execute some task query operations (either using REST or SOAP interface) on Oracle database, you will get SQLGrammarException.

      Version-Release number of selected component (if applicable):
      6.2.0 ER4

      Steps to Reproduce:
      1. Run some process with a task.
      2. Try to call for example http://localhost:8080/business-central/rest/query/task?processInstanceId=1
      3. See the response

      Actual results:
      java.sql.SQLSyntaxErrorException: ORA-00979: not a GROUP BY expression

      Expected results:
      No exception and valid result.

      Additional info:
      This bug was probably introduced when trying to fix bug 1265725.

        1. IBM DB2 9.7.log
          11 kB
        2. Microsoft SQL Server 2012.log
          11 kB
        3. Oracle 12c.log
          11 kB
        4. PostgreSQL 8.4.log
          10 kB

              marco.rietveld Marco Rietveld (Inactive)
              tlivora Tomáš Livora (Inactive)
              Tomáš Livora Tomáš Livora (Inactive)
              Tomáš Livora Tomáš Livora (Inactive)
              Kris Verlaenen, Tibor Zimányi
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

                Created:
                Updated:
                Resolved: