[OOZIE-3310] SQL error during /v2/sla filtering

• Type: Bug
• Status: Closed
• Priority: Minor
• Resolution: Fixed
• Affects Version/s: 5.1.0
• Fix Version/s: 5.1.0
• Component/s: client
• Assignee: Andras Salamon
• Reporter: Andras Salamon
• Created: 26/Jul/18 10:51
• Updated: 18/Jan/19 09:02
• Resolved: 31/Jul/18 11:39

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
}

Issue Links

• is related to: OOZIE-3229 [client] [ui] Improved SLA filtering options