Uploaded image for project: 'Oozie'
  1. Oozie
  2. OOZIE-3310

SQL error during /v2/sla filtering

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Minor
    • Resolution: Fixed
    • Affects Version/s: 5.1.0
    • Fix Version/s: 5.1.0
    • Component/s: client
    • Labels:
      None

      Description

      Filtering for both the id and the bundle field using /v2/sla servlet gives an SQL error:

      // 20180726124649
      // http://localhost:11000/oozie/v2/sla?timezone=GMT&filter=id=0000001-180726123600112-oozie-andr-C;bundle=0000000-180726123600112-oozie-andr-B
      
      {
      "errorMessage": "E0603: SQL error in operation, "Encountered "." at character 63, but expected: ["*", "+", "-", "/", "GROUP", "HAVING", "ORDER", <EOF>]." while parsing JPQL "SELECT OBJECT(s) FROM SLASummaryBean s WHERE s.jobId = :jobIds.parentId in (:parentId0) ORDER BY s.nominalTimeTS". See nested stack trace for original parse error.",
      "httpStatusCode": 500
      }

        Attachments

        1. OOZIE-3310-3.patch
          3 kB
          Andras Salamon
        2. OOZIE-3310-2.patch
          3 kB
          Andras Salamon
        3. OOZIE-3310-1.patch
          2 kB
          Andras Salamon

          Issue Links

            Activity

              People

              • Assignee:
                asalamon74 Andras Salamon
                Reporter:
                asalamon74 Andras Salamon
              • Votes:
                0 Vote for this issue
                Watchers:
                3 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: