search cancel

Jira Connector Error in the JQL Query

book

Article ID: 113485

calendar_today

Updated On:

Products

CA Agile Central On Premise (Rally) CA Agile Central SaaS (Rally)

Issue/Introduction

When a selector contains a key/value pair that has a set of parenthesis in its value, the connector does not format the JQL correctly.

This causes JQL parser to try and interpret the parenthesis as a grouping construct instead of a value to search for and an error is thrown:
[2018-06-27 20:54:59 Z] DEBUG : RallyJest::JiraComm.block in execute_request - issuing a GET request for endpoint: /rest/api/2/search?jql=type="Bug" AND project = "Project" AND "RallyFormattedID" = -1 AND "CustomDropDown" = Value (New Value)&startAt=0&fields=*all
[2018-06-27 20:54:59 Z] DEBUG : RallyJest::JiraComm.execute_request - {
"errorMessages": [
"Error in the JQL Query: Expecting ')' or ',' but got 'Value'. (line 1, character 90)"
],
"errors": {
}
}

Environment

Jira Connector v4.6.5

Cause

This is due to the way that the connector handles escaping the parenthesis in a Copy/Update selector.

Resolution

At the time there is no solution for this.

The recommended workaround is to 
  • Remove parenthesis from the fields
  • Use a different field for the copy/update selector