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

KMD9667 commented 1 month ago

Checklist before you being

[X] I am sure that I am already using latest version of Jira Assistant
[X] I had verified that, no similar issues are already reported in issue tracker
[X] 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
[X] I had verified that, my query is not answered in FAQ section of website
[X] 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

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

KMD9667 commented 1 month ago

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 commented 1 month ago

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 commented 1 month ago

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 https://github.com/shridhar-tl/jira-assistant/issues/356#issuecomment-2113909782, or unsubscribe https://github.com/notifications/unsubscribe-auth/ALPO3VIMRWDNMBCOCZVQFITZCQMJ5AVCNFSM6AAAAABHNGIUS6VHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMZDCMJTHEYDSNZYGI . You are receiving this because you were mentioned.Message ID: @.***>

shridhar-tl commented 1 month ago

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 commented 1 month ago

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 https://github.com/shridhar-tl/jira-assistant/issues/356#issuecomment-2121543880, or unsubscribe https://github.com/notifications/unsubscribe-auth/ALPO3VKSVPQAO4C5DHKLHATZDKQ4ZAVCNFSM6AAAAABHNGIUS6VHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMZDCMRRGU2DGOBYGA . You are receiving this because you were mentioned.Message ID: @.***>

shridhar-tl / jira-assistant