Jira Integration with Informatica Errors

I am trying to extract Project Related Details from JIRA-PROD using the JIRA API and our Informatica Cloud Platform.

* If I only filter on 1 particular project at a time (Project = 'R9000'), the integration works fine. I also ran it for (Project = 'A7000') with success.

* If I attempt to filter on two projects (Project = 'R9000') OR (Project = 'A7000'), the integration fails

* If I attempt to filter for projects that are not null (Project Is Not NULL), the integration fails

The error message I am getting is as follows:
Error Message: Failed : HTTP error code : 400,Message :{"errorMessages":["Error in the JQL Query: Expecting either 'OR' or 'AND' but got 's'. (line 1, character 56)"],"errors":{}}

Here is a summary of integrations that I ran in the JIRA-PROD environment:

Time Stamp Status Filter Criteria
--------------------------------- ------------- ------------------------
Jul 11, 2017 11:27:50 AM Successful (Project = 'R9000')
Jul 11, 2017 11:37:35 AM Successful (Project = 'A7000')
Jul 11, 2017 11:45:44 AM Failed (Project = 'R9000') OR (Project = 'A7000')
Jul 11, 2017 11:58:31 AM Failed (Project Is Not NULL)

When I perform the same integration tasks/filter criteria in the JIRA-DEV environment, the integrations are successful.

My ideal scenario is to be able to extract the Project details based on the filter "Project Is Not NULL". e.g. without having to specify a particular project name.

User Account: svc.informatica

Source Object: __ALL_PROJECTS

Fields I am trying to extract: Project and Key

Can someone on the JIRA Support Team help identify what might be the cause of the errors?

1 answer

This widget could not be displayed.

It sounds like there's some form of escaping or character problem with what Informatica is sending.

I'd want to see exactly what it is trying to send, in order to de-bug it.

Your last query is incorrect though, as there are no issues without a project.  You just leave the query blank, and it will return all issues.

Suggest an answer

Log in or Sign up to answer
Atlassian Summit 2018

Meet the community IRL

Atlassian Summit is an excellent opportunity for in-person support, training, and networking.

Learn more
Community showcase
Posted Wednesday in New to Jira

Are you planning to trial, or are currently trialling Jira Software? - We want to talk to you!

Hello! I'm Rayen, a product manager at Atlassian. My team and I are working hard to improve the trial experience for Jira Software Cloud. We are interested in   talking to 20 people planning t...

189 views 3 0
Join discussion

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you