Confluence Macros Error

[Kumar]

Hi Team,

In My confluence  I making a shift hand over report  so when i open my reports in confluence i'm receiving this error message as shown in screen short.

The query i search from jira is working and if i try that "View these issue in jira"  in jira the filter will copy only half of the query

so when i refresh that page in confluence some time its showing the macros report and some times it showing this error message. 

can anyone suggest me how to resolve this.

Thanks,

Kumar

[Andy Heinzer]

I'm not sure what would cause this to fail, but the fact that only half the JQL query appears to show would tend to indicate that Confluence's request to Jira might be getting truncated or the URL might be getting altered in some way.  Could you share with us the specific JQL query being used here?   Is it a particularly large JQL query with lots of terms and operators?

I'd be interested to see if perhaps you can save the JQL query into a filter in Jira, share that filter with all the groups/users that need to see those issues in Jira/Confluence and then in confluence just use a JQL syntax of

filter=12345

where 12345 is the id number of that filter in Jira.   The search results should be the same, but the query essentially is getting shortened.

Alternatively, I would be interested to see if you are getting any browser console errors when loading this page in Confluence.  I'm curious if the browser is encountering some kind of proxy error or alike that might be altering the request being made from Confluence to Jira. 

If nothing shows there, it might also help to look at both the Jira Server / Confluence Server application logs at the time this page loads to see if there are any ERROR or WARNING type messages that appear in the logs when this happens.

[Kumar]

Hi @Andy Heinzer 

Thanks for your response 

These are the queries that getting above error even the query is good when i copy this query and paste in the jira its working fine 

but when i click on the warn pop to open the issues in jira it's copying the query half only in the search issue bar.

project = "Test" AND status was in ("Create","In Progress",Remediation) during ("2018/12/1 10:30", "2018/12/1 19:30") AND "Group" in (-XYZ)

project = "Test" AND "Incident" = "Optional" AND status was not in (Done,Closed,Validation) DURING ("2018/12/1 10:30", "2018/12/1 19:30").

These are queries some times its displaying the queries in confluence and some time its showing the warn pop up screen as shown in above screen short.

can you please help me how to resolve it

Thanks,

Kumar

[Andy Heinzer]

I don't see a problem with the queries themselves.  You state that when clicking the link to jira, it only shows half the query.  Is this consistently truncating the query in the same spot?  If so, I'd like to better understand what that truncated JQL / URL looks like.  I have a suspicion that this problem could be caused by Confluence's inability to correctly communicate this information to the Jira server.

In addition to the JQL and URL being called, it might help to look at the browser console of confluence when loading this page.  If you're using Chrome you can turn this on to see if you get any errors when the page loads.  Details in https://developers.google.com/web/tools/chrome-devtools/console/

It might also help to Capture a HAR file when loading this page when this error happens.  This will tell us more about the HTTP/HTTPS requests being made and what is ultimately returned to the end user in their browser session when this error happens.