[JSDSERVER-13385] Assets issue count report on using aqlfunction throwing JQL Validation error

Type: Bug
Resolution: Fixed
Priority: High
Fix Version/s: 5.11.0, 5.4.10
Affects Version/s: 5.4.0, 5.4.2
Component/s: Assets - Report
Labels:
None

Support reference count:
1
Symptom Severity:
Severity 3 - Minor
Bug Fix Policy:
View Atlassian Server bug fix policy

Issue Summary

This is reproducible on Data Center: (yes) / (no)

Steps to Reproduce

Create any assets custom field and update a few issues to add assets objects to the custom field.
Run a search in Jira issue search screen using aqlfunction and retrieve the issues.
1. ```
project = ITSD AND "Service Contract" in aqlFunction("Name = Contract1")
```

It works as expected and displays the issues matching the JQL.
Now open Assets reports and select "New report" and "Issue Count" report.
Add all the mandatory fields, adn in the "Issue filter (JQL)" field, enter the JQL provided above that has aqlfunction.
Hit Generate preview.

Expected Results

A preview of the data is displayed.

Actual Results

A validation JQL error is displayed on the screen. Even if the report is saved without any preview, still the gadget that shows this filter in the dashboard fails with the same error in the log.

The below exception is thrown in the atlassian-jira.log file:

2023-06-19 11:05:30,208+0530 DefaultDispatcher-worker-2 ERROR admin     [i.r.j.p.i.widget.queue.GenerationDataCapabilityQueueImpl] Fail running a job-queue under user `admin`
io.riada.core.service.ServiceException: jql: {insight-widget.validation.jql.nonvalid}
        at io.riada.core.service.ServiceException$Companion.validationFailed(ServiceException.kt:110)
        at io.riada.core.service.ServiceException$Companion.validationFailed(ServiceException.kt:94)
        at io.riada.assetmgt.ticket.service.JiraIssueServiceImpl.parseJQL(JiraIssueServiceImpl.kt:109)
        at io.riada.assetmgt.ticket.service.JiraIssueServiceImpl.buildJQL(JiraIssueServiceImpl.kt:93)
        at io.riada.assetmgt.ticket.service.JiraIssueServiceImpl.findAllByObject(JiraIssueServiceImpl.kt:46)
        at io.riada.assetmgt.ticket.service.TicketServiceJiraImpl.findIssuesForObject(TicketServiceJiraImpl.kt:109)
        at io.riada.assetmgt.ticket.service.TicketServiceJiraImpl.findAllTicketsForObjects(TicketServiceJiraImpl.kt:69)
        at io.riada.jira.plugins.insight.reports.issuecount.IssueCountReport.findTicketsFrom(IssueCountReport.kt:113)
        at io.riada.jira.plugins.insight.reports.issuecount.IssueCountReport.generate(IssueCountReport.kt:93)
        at io.riada.jira.plugins.insight.reports.issuecount.IssueCountReport.generate(IssueCountReport.kt:26)
        at io.riada.jira.plugins.insight.widget.queue.GenerationDataCapabilityJobImpl.generate(GenerationDataCapabilityJobImpl.kt:42)
        at io.riada.jira.plugins.insight.widget.queue.GenerationDataCapabilityJobImpl.generateSample(GenerationDataCapabilityJobImpl.kt:26)
        at io.riada.jira.plugins.insight.widget.queue.GenerationDataCapabilityQueueImpl$generateSample$1.invoke(GenerationDataCapabilityQueueImpl.kt:181)
        at io.riada.jira.plugins.insight.widget.queue.GenerationDataCapabilityQueueImpl.runUnderContext(GenerationDataCapabilityQueueImpl.kt:193)
        at io.riada.jira.plugins.insight.widget.queue.GenerationDataCapabilityQueueImpl.generateSample(GenerationDataCapabilityQueueImpl.kt:179)
        at io.riada.jira.plugins.insight.widget.queue.GenerationDataCapabilityQueueImpl.previewOf$lambda-1(GenerationDataCapabilityQueueImpl.kt:117)
        at com.atlassian.jira.util.thread.JiraThreadLocalUtils.lambda$wrap$1(JiraThreadLocalUtils.java:156)
        at io.riada.jira.plugins.insight.widget.queue.GenerationDataCapabilityQueueRunnerJiraImpl$run$1$future$1.invokeSuspend(GenerationDataCapabilityQueueRunnerJiraImpl.kt:61)
        at kotlin.coroutines.jvm.internal.BaseContinuationImpl.resumeWith(ContinuationImpl.kt:33)
        at kotlinx.coroutines.DispatchedTask.run(DispatchedTask.kt:106)
        at kotlinx.coroutines.internal.LimitedDispatcher.run(LimitedDispatcher.kt:39)
        at kotlinx.coroutines.scheduling.TaskImpl.run(Tasks.kt:95)
        at kotlinx.coroutines.scheduling.CoroutineScheduler.runSafely(CoroutineScheduler.kt:571)
        at kotlinx.coroutines.scheduling.CoroutineScheduler$Worker.executeTask(CoroutineScheduler.kt:750)
        at kotlinx.coroutines.scheduling.CoroutineScheduler$Worker.runWorker(CoroutineScheduler.kt:678)
        at kotlinx.coroutines.scheduling.CoroutineScheduler$Worker.run(CoroutineScheduler.kt:665)
2023-06-19 11:05:30,228+0530 DefaultDispatcher-worker-2 ERROR anonymous     [i.r.j.p.i.widget.queue.GenerationDataCapabilityQueueRunnerJiraImpl] Oops
io.riada.core.service.ServiceException: jql: {insight-widget.validation.jql.nonvalid}
        at io.riada.core.service.ServiceException$Companion.validationFailed(ServiceException.kt:110)
        at io.riada.core.service.ServiceException$Companion.validationFailed(ServiceException.kt:94)
        at io.riada.assetmgt.ticket.service.JiraIssueServiceImpl.parseJQL(JiraIssueServiceImpl.kt:109)
        at io.riada.assetmgt.ticket.service.JiraIssueServiceImpl.buildJQL(JiraIssueServiceImpl.kt:93)
        at io.riada.assetmgt.ticket.service.JiraIssueServiceImpl.findAllByObject(JiraIssueServiceImpl.kt:46)
        at io.riada.assetmgt.ticket.service.TicketServiceJiraImpl.findIssuesForObject(TicketServiceJiraImpl.kt:109)
        at io.riada.assetmgt.ticket.service.TicketServiceJiraImpl.findAllTicketsForObjects(TicketServiceJiraImpl.kt:69)
        at io.riada.jira.plugins.insight.reports.issuecount.IssueCountReport.findTicketsFrom(IssueCountReport.kt:113)
        at io.riada.jira.plugins.insight.reports.issuecount.IssueCountReport.generate(IssueCountReport.kt:93)
        at io.riada.jira.plugins.insight.reports.issuecount.IssueCountReport.generate(IssueCountReport.kt:26)
        at io.riada.jira.plugins.insight.widget.queue.GenerationDataCapabilityJobImpl.generate(GenerationDataCapabilityJobImpl.kt:42)
        at io.riada.jira.plugins.insight.widget.queue.GenerationDataCapabilityJobImpl.generateSample(GenerationDataCapabilityJobImpl.kt:26)
        at io.riada.jira.plugins.insight.widget.queue.GenerationDataCapabilityQueueImpl$generateSample$1.invoke(GenerationDataCapabilityQueueImpl.kt:181)
        at io.riada.jira.plugins.insight.widget.queue.GenerationDataCapabilityQueueImpl.runUnderContext(GenerationDataCapabilityQueueImpl.kt:193)
        at io.riada.jira.plugins.insight.widget.queue.GenerationDataCapabilityQueueImpl.generateSample(GenerationDataCapabilityQueueImpl.kt:179)
        at io.riada.jira.plugins.insight.widget.queue.GenerationDataCapabilityQueueImpl.previewOf$lambda-1(GenerationDataCapabilityQueueImpl.kt:117)
        at com.atlassian.jira.util.thread.JiraThreadLocalUtils.lambda$wrap$1(JiraThreadLocalUtils.java:156)
        at io.riada.jira.plugins.insight.widget.queue.GenerationDataCapabilityQueueRunnerJiraImpl$run$1$future$1.invokeSuspend(GenerationDataCapabilityQueueRunnerJiraImpl.kt:61)
        at kotlin.coroutines.jvm.internal.BaseContinuationImpl.resumeWith(ContinuationImpl.kt:33)
        at kotlinx.coroutines.DispatchedTask.run(DispatchedTask.kt:106)
        at kotlinx.coroutines.internal.LimitedDispatcher.run(LimitedDispatcher.kt:39)
        at kotlinx.coroutines.scheduling.TaskImpl.run(Tasks.kt:95)
        at kotlinx.coroutines.scheduling.CoroutineScheduler.runSafely(CoroutineScheduler.kt:571)
        at kotlinx.coroutines.scheduling.CoroutineScheduler$Worker.executeTask(CoroutineScheduler.kt:750)
        at kotlinx.coroutines.scheduling.CoroutineScheduler$Worker.runWorker(CoroutineScheduler.kt:678)
        at kotlinx.coroutines.scheduling.CoroutineScheduler$Worker.run(CoroutineScheduler.kt:665)

Workaround

Currently there is no known workaround for this behavior. A workaround will be added here when available

- - Sort By Name
  - Sort By Date
  - Ascending
  - Descending
  - Thumbnails
  - List

Screenshot 2023-06-19 at 12.12.55 PM.png
19/Jun/2023 6:53 AM
432 kB
Sireesha

mentioned in: Page Failed to load; Page Failed to load

Form Name

Satej Mirpagar made changes - 30/Aug/2023 2:41 PM

Resolution		New: Fixed [ 1 ]
Status	Original: Waiting for Release [ 12075 ]	New: Closed [ 6 ]

Mingyi Yang made changes - 09/Aug/2023 11:01 PM

Remote Link

New: This issue links to "Page (Confluence)" [ 798169 ]

Christopher Bowles made changes - 04/Aug/2023 2:25 AM

Status

Original: In Progress [ 3 ]

New: Waiting for Release [ 12075 ]

Christopher Bowles made changes - 04/Aug/2023 2:24 AM

Fix Version/s		New: 5.4.10 [ 105719 ]
Fix Version/s		New: 5.11.0 [ 105890 ]

Christopher Bowles made changes - 04/Aug/2023 2:22 AM

Status

Original: Short Term Backlog [ 12074 ]

New: In Progress [ 3 ]

Alex Cooksey made changes - 03/Aug/2023 6:51 AM

Assignee

New: Christopher Bowles [ 12fbc3c722fa ]

Christopher Bowles made changes - 01/Aug/2023 2:53 AM

Remote Link

New: This issue links to "Page (Confluence)" [ 794852 ]

Alexandre Allart added a comment - 05/Jul/2023 6:39 AM

Hello,

Do you have an update or workaround for this problem?

Thank you for your help,

Alexandre

Alexandre Allart added a comment - 05/Jul/2023 6:39 AM Hello, Do you have an update or workaround for this problem? Thank you for your help, Alexandre

Marc Dacanay made changes - 21/Jun/2023 5:53 AM

Priority

Original: Low [ 4 ]

New: High [ 2 ]

Marc Dacanay made changes - 21/Jun/2023 5:53 AM

Status

Original: Needs Triage [ 10030 ]

New: Short Term Backlog [ 12074 ]

Assignee:: Christopher Bowles

Reporter:: Sireesha

Affected customers:: 2 This affects my team

Watchers:: 4 Start watching this issue

Created:: 19/Jun/2023 6:54 AM

Updated:: 30/Aug/2023 2:41 PM

Resolved:: 30/Aug/2023 2:41 PM

Details

Description

Issue Summary

Steps to Reproduce

Expected Results

Actual Results

Workaround

Attachments

Attachments

Issue Links

Forms

Activity

Collapse comment: Alexandre Allart added a comment - 05/Jul/2023 6:39 AM

Expand comment: Alexandre Allart added a comment - 05/Jul/2023 6:39 AM

People

Dates

Backbone Issue Sync