[
https://issues.apache.org/jira/browse/OOZIE-3310?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Andras Salamon updated OOZIE-3310:
----------------------------------
Attachment: OOZIE-3310-3.patch
> SQL error during /v2/sla filtering
> ----------------------------------
>
> Key: OOZIE-3310
> URL: https://issues.apache.org/jira/browse/OOZIE-3310
> Project: Oozie
> Issue Type: Bug
> Components: client
> Affects Versions: 5.1.0
> Reporter: Andras Salamon
> Assignee: Andras Salamon
> Priority: Minor
> Attachments: OOZIE-3310-1.patch, OOZIE-3310-2.patch,
> OOZIE-3310-3.patch
>
>
> Filtering for both the id and the bundle field using /v2/sla servlet gives an
> SQL error:
> {noformat}
> // 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
> }{noformat}
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
