[WEBCLIENT-149] Query rerun is failing when run as query-in-query Created: 02/Dec/15  Updated: 25/Jan/16  Resolved: 18/Dec/15

Status: Closed
Project: i2b2 Web Client
Component/s: CRC Cell, Web Client
Affects Version/s: None
Fix Version/s: 1.7.07

Type: Bug Priority: Major
Reporter: Reeta Metta Assignee: Janice Donahoe
Resolution: Fixed Votes: 0
Labels: None
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Attachments: JPEG File previous query item showing as undefined after the query ran unsuccessfully.JPG     JPEG File previous query run as query in query.JPG     JPEG File query run as query-in-query.JPG    
i2b2 Feature/s:
Queries, Query-in-Query
i2b2 Sponsored Project/s:
i2b2 Web Client
Reproduction Notes: This can be reproduced in both the testing and demo environments.

The issue occurs when you run a previous query that has a previous query in one of the panels. The query will immediately time out and go into the small queue. It stays in the small queue indefinitely and never runs.

STEPS TO REPRODUCE:

1. Run a simple query by dragging a concept to the first panel / group.
2. Once the query runs, clear the query tool.
3. Drag the query you just ran from previous query to the first panel.
4. Feel free to add other concepts (not required).
5. Run the query.
6. Clear the query tool.
7. Drag the query you just ran from Previous Queries to the Query Name in the Query Tool.
8. Run the query.
9. Notice the timeout message appears saying it is going into the small queue.
10. The query will appear in Previous Queries as INCOMPLETE and WAITING IN QUEUE TO START PROCESS.
11. The query never runs.
Testing Notes: TEST STATUS: Completed
COMPLETION DATE: 12/18/2015

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Test Date: 12/18/2015
Build Number:1.7.07
Test Status: Completed (Passed Testing)
Clients Tested :
     i2b2 Web Client
     Environments Tested :
     Browsers: Chrome, Firefox, Internet Explorer, and Safari
     Databases: Not applicable for this test
     Client OS: Windows, Mac
Test Comments:
Working as expected
ISSUES FOUND:None
Participant/s:

 Description   
log into https://www.i2b2.org/webclient/ as demo user
navigate to shared folders =>folder 'Reeta_Test'=> drag and drop the previous query 'quey in query run_Acute Rheumatic@14:24:04 [12-2-2015] [demo]]' into query tool name text box and run the query
Note: the query has a previous query as the group item ( run as query in query)
Expected: query should run successfully
Actual: 'Your query has timed out 'msg is displayed.
After clicking ok then drag and drop the run query onto the query tool box
The previous query in the group panel displays as 'undefined'
xml logs shows the item name as ' undefined' for the previous query



 Comments   
Comment by Janice Donahoe [ 07/Dec/15 ]
Not sure if this is a Web Client or a CRC issue. If it is a CRC issue then an issue needs to be added to the CORE project so it can be fixed.
Comment by Nich [ 09/Dec/15 ]
This bug affects Previous Queries that contain a Previous Query. It has been fixed in 1.7.07
Comment by Reeta Metta [ 14/Dec/15 ]
reopened the issue because the previous query contained within the previous query is now missing after the run.
Comment by Nich [ 16/Dec/15 ]
Thanks Reeta, this is now fixed.
Comment by Reeta Metta [ 18/Dec/15 ]
query run with query in query -query ( previous query with query inside which has a previous query inside)
updates the inside previous query name as "undefined".
will enter separate issue for it
Comment by Janice Donahoe [ 25/Jan/16 ]
On 01/22/2016, the 1.7.07 Release was made available at the following locations.

https://www.i2b2.org/software/
 - zip files for release 1.7.07 are available on this site. This includes both the code and documentation.

https://github.com/i2b2
 - source code has been tagged with v1.7.07.
Generated at Fri Apr 03 20:11:33 UTC 2020 using JIRA 7.6.3#76005-sha1:8a4e38d34af948780dbf52044e7aafb13a7cae58.