Error: "com.atlassian.jira.issue.search.vsearch.SearchInternalException: Failed to run query" when running Worklog Report

[KMD9667]

Checklist before you being

• I am sure that I am already using latest version of Jira Assistant
• I had verified that, no similar issues are already reported in issue tracker
• I had tried reproducing this issue with with Web version of Jira Assistant to ensure that this issue is not recently fixed and yet to be published
• I had verified that, my query is not answered in FAQ section of website
• I had verified that, my issue is not listed as known bugs in website

How do you use Jira Assistant?

Browser extension

Are you using cloud version of Jira or self hosted (data center / server) of Jira.

Cloud Jira

Version of Jira Assistant

v2.58

What browser are you using?

Chrome

What OS are you using? You need not disclose this if you feel it is irr-relevant for your issue.

None

Bug Description

I have a Worklog report that contains 112 individuals across 11 groups that I run once a week for the prior week. This report has been running flawlessly for the past 4 weeks, until this week.

I tried to run it this week (both extension and web extension v2.59) and I get "Unknown Error. Check Console for details." When I check the console, I see "com.atlassian.jira.issue.search.vsearch.SearchInternalException: Failed to run query".

I have also tried to run the report for just a single day instead of a week and get the same result.

Checklist before you submit

• I have ensured not to paste any confidential information like Jira url, Mail id, etc.
• I have verified my browser console logs and added necessary details (if required)
• I have added required screenshots if the bug is related to UI (as necessary)

[KMD9667]

UPDATE 5-14-24: I have had a colleague attempt to run a Worklog report on a different PC (fewer people in the report). He is getting the same error as I am.

[shridhar-tl]

Hi @KMD9667, this is not a usual error or I have never seen this issue before. I did a quick research and no information is available regarding this error online. So as a first step, I would request you to take the query being executed in network tab and run it directly in Jira and check. That would give you an idea of whether that query can be executed in your Jira or not. based on that we can proceed further.

[KMD9667]

Hello Shridar, I went to the Network tab in Developer Tools and ran the report. I clear any entries before I run the report. When I run the report, nothing appears in the window. Here is a screen shot while it is running. Even when the error eventually appears, there are no entries in the Network tab - no filters enabled. Thanks - KMD9667 [image: image.png] <http://www.avg.com/email-signature?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail> Virus-free.www.avg.com <http://www.avg.com/email-signature?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail> <#DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2>

…

On Wed, May 15, 2024 at 10:42 PM Shridhar TL ***@***.***> wrote: Hi @KMD9667 <https://github.com/KMD9667>, this is not a usual error or I have never seen this issue before. I did a quick research and no information is available regarding this error online. So as a first step, I would request you to take the query being executed in network tab and run it directly in Jira and check. That would give you an idea of whether that query can be executed in your Jira or not. based on that we can proceed further. — Reply to this email directly, view it on GitHub <#356 (comment)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/ALPO3VIMRWDNMBCOCZVQFITZCQMJ5AVCNFSM6AAAAABHNGIUS6VHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMZDCMJTHEYDSNZYGI> . You are receiving this because you were mentioned.Message ID: ***@***.***>

[shridhar-tl]

Hi, I understand you have installed Browser Extension in Chrome and using JA. There is an option to switch to Web version for users who have installed extension. By any chance if you have switched to Web version earlier, you might be using Web version. In that case your AJAX requests would be routed through extension still. So you cannot see the requests through network tab.

Instead you need to open the network tab of extension.

How to know if you are using web version?
in tab if your url says "https://app.jiraassistant.com/", then you are using web version. If it starts with "chrome-extension://", then you are using extension already.

if you are using web version, then to check network requests, you can temporarily switch back to extension from top right corner by clicking on Extn button:

From extension network tab, you should definitely be able to view the network requests. Otherwise see if you have enabled some filters in your network tab which is hiding your requests.

[KMD9667]

Hi Shridar, I was able to capture the JQL and try submitting it directly via API and UI interface to Jira. Both cases failed with a 500 error. We opened a ticket with ira and they say this is a known issue: https://jira.atlassian.com/browse/JRACLOUD-83317 It might be helpful for others to upvote the fix on this issue so that Jira handles it quickly. I wanted to share that with you as I'm sure that others are experiencing the same issue. Thanks, Chris

…

On Mon, May 20, 2024 at 9:41 PM Shridhar TL ***@***.***> wrote: Hi, I understand you have installed Browser Extension in Chrome and using JA. There is an option to switch to Web version for users who have installed extension. By any chance if you have switched to Web version earlier, you might be using Web version. In that case your AJAX requests would be routed through extension still. So you cannot see the requests through network tab. Instead you need to open the network tab of extension. How to know if you are using web version? in tab if your url says "https://app.jiraassistant.com/", then you are using web version. If it starts with "chrome-extension://", then you are using extension already. if you are using web version, then to check network requests, you can temporarily switch back to extension from top right corner by clicking on Extn button: image.png (view on web) <https://github.com/shridhar-tl/jira-assistant/assets/37339683/19b0cb04-26e4-4fba-830b-c43883359064> From extension network tab, you should definitely be able to view the network requests. Otherwise see if you have enabled some filters in your network tab which is hiding your requests. image.png (view on web) <https://github.com/shridhar-tl/jira-assistant/assets/37339683/76329318-f473-484e-8497-353c01bebee5> — Reply to this email directly, view it on GitHub <#356 (comment)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/ALPO3VKSVPQAO4C5DHKLHATZDKQ4ZAVCNFSM6AAAAABHNGIUS6VHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMZDCMRRGU2DGOBYGA> . You are receiving this because you were mentioned.Message ID: ***@***.***>