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

SQL error during /v2/sla filtering

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Closed
    • Minor
    • Resolution: Fixed
    • 5.1.0
    • 5.1.0
    • client
    • 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-1.patch
          2 kB
          Andras Salamon
        2. OOZIE-3310-2.patch
          3 kB
          Andras Salamon
        3. OOZIE-3310-3.patch
          3 kB
          Andras Salamon

        Issue Links

          Activity

            People

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

              Dates

                Created:
                Updated:
                Resolved: