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

0 vote

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 Join to answer
Community showcase
Sarah Schuster
Posted Jan 29, 2018 in Jira

What are common themes you've seen across successful & failed Jira Software implementations?

Hey everyone! My name is Sarah Schuster, and I'm a Customer Success Manager in Atlassian specializing in Jira Software Cloud. Over the next few weeks I will be posting discussion topics (8 total) to ...

3,296 views 14 20
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
Atlassian Team Tour

Join us on the Team Tour

We're bringing product updates and pro tips on teamwork to ten cities around the world.

Save your spot