Type:
Bug
Status:
Closed
Priority:
Major
Resolution:
Fixed
Affects Version/s:
None
Component/s:
None
When canceling a query is the variable i2b2.CRC.ctrlr.deleteCurrentQuery is null than checking on a i2b2.CRC.ctrlr.deleteCurrentQuery.QM which result in a null pointer. Should check to see that i2b2.CRC.ctrlr.deleteCurrentQuery is not null first.
Mike Mendis
made changes -
01/Dec/17 12:17 PM
Field
Original Value
New Value
Status
New
[ 10000
]
Open
[ 1
]
Mike Mendis
made changes -
01/Dec/17 12:17 PM
Assignee
Mike Mendis
[ mem61
]
Mike Mendis
made changes -
01/Dec/17 12:17 PM
Status
Open
[ 1
]
In Progress
[ 3
]
Mike Mendis
made changes -
01/Dec/17 12:17 PM
Assignee
Mike Mendis
[ mem61
]
Janice Donahoe
[ jmd86
]
Status
In Progress
[ 3
]
Ready to Test
[ 10001
]
Janice Donahoe
made changes -
04/Dec/17 11:43 AM
Fix Version/s
1.7.09c
[ 10800
]
Janice Donahoe
made changes -
04/Dec/17 11:43 AM
Status
Ready to Test
[ 10001
]
Testing
[ 10002
]
Janice Donahoe
made changes -
07/Dec/17 10:50 AM
Summary
webclient failed to cancel query after informing obfuscated user he is locked out
Webclient failed to cancel query after informing obfuscated user he is locked out
Janice Donahoe
made changes -
07/Dec/17 11:02 AM
Description
RUnning a query as a locked out user, they cant cancel it.
When an obfuscated exceeds the allowed number of times they can repeat a query they will be "locked out" from running another query. When they receive the message telling them they have been locked out, the system should cancel the query they are trying to run. However, when they click on OK the Web Client continues to run the query.
The resolution is to have the Web Client "cancel" the query when the lockout message is received from the CRC.
GIT COMMIT 3ff17f73549eff306ead0fafdfb780f09ef018f0
Janice Donahoe
made changes -
07/Dec/17 11:03 AM
Resolution
Fixed
[ 1
]
Status
Testing
[ 10002
]
Resolved
[ 5
]
Janice Donahoe
made changes -
07/Dec/17 11:07 AM
Summary
Webclient failed to cancel query after informing obfuscated user he is locked out
Web Client doesn't cancel query when user receives lockout message
Janice Donahoe
made changes -
07/Dec/17 12:17 PM
Resolution
Fixed
[ 1
]
Status
Resolved
[ 5
]
Reopened
[ 4
]
Janice Donahoe
made changes -
07/Dec/17 12:17 PM
Status
Reopened
[ 4
]
In Progress
[ 3
]
Janice Donahoe
made changes -
07/Dec/17 1:19 PM
Assignee
Janice Donahoe
[ jmd86
]
Mike Mendis
[ mem61
]
Janice Donahoe
made changes -
08/Dec/17 9:12 AM
Link
This issue clone of WEBCLIENT-224
[ WEBCLIENT-224
]
Janice Donahoe
made changes -
08/Dec/17 9:12 AM
Link
This issue clone of WEBCLIENT-224
[ WEBCLIENT-224
]
Mike Mendis
made changes -
08/Dec/17 3:33 PM
Description
When an obfuscated exceeds the allowed number of times they can repeat a query they will be "locked out" from running another query. When they receive the message telling them they have been locked out, the system should cancel the query they are trying to run. However, when they click on OK the Web Client continues to run the query.
The resolution is to have the Web Client "cancel" the query when the lockout message is received from the CRC.
GIT COMMIT 3ff17f73549eff306ead0fafdfb780f09ef018f0
When canceling a query is the variable i2b2.CRC.ctrlr.deleteCurrentQuery is null than checking on a i2b2.CRC.ctrlr.deleteCurrentQuery.QM which result in a null pointer. Should check to see that i2b2.CRC.ctrlr.deleteCurrentQuery is not null first.
Summary
Web Client doesn't cancel query when user receives lockout message
Web Client possible null pointer
Janice Donahoe
made changes -
02/Feb/18 2:56 PM
Resolution
Fixed
[ 1
]
Status
In Progress
[ 3
]
Resolved
[ 5
]
Janice Donahoe
made changes -
02/Feb/18 4:13 PM
Status
Resolved
[ 5
]
Closed
[ 6
]
Reeta Metta
made changes -
14/Feb/18 4:14 PM
Attachment
dtconst_ptst.PNG
[ 11031
]
Reeta Metta
made changes -
14/Feb/18 4:14 PM
Attachment
dtconst_ptst.PNG
[ 11031
]
{"report":{"fcp":1015.5,"ttfb":205.79999923706055,"pageVisibility":"visible","entityId":11266,"key":"jira.project.issue.view-issue","isInitial":true,"threshold":1000,"elementTimings":{},"userDeviceMemory":8,"userDeviceProcessors":64,"apdex":0.5,"journeyId":"ef6745f8-087d-4d55-8f2d-7ac6bd385d69","navigationType":0,"readyForUser":1085.1999998092651,"redirectCount":0,"resourceLoadedEnd":1167.0999994277954,"resourceLoadedStart":222.69999980926514,"resourceTiming":[{"duration":107.09999942779541,"initiatorType":"link","name":"https://community.i2b2.org/jira/s/7fd763ecdf5ed1f47fc4d22fa8382e97-CDN/4x9nqn/820011/16zrvj4/49fa3aa3d35a2cc689cbf274e66cc41a/_/download/contextbatch/css/_super/batch.css","startTime":222.69999980926514,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":222.69999980926514,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":329.79999923706055,"responseStart":0,"secureConnectionStart":0},{"duration":107.09999942779541,"initiatorType":"link","name":"https://community.i2b2.org/jira/s/898b8076c5e82f53cd816ca393e45a56-CDN/4x9nqn/820011/16zrvj4/f614b50eeb842ebd1ea7ab2903699907/_/download/contextbatch/css/project.issue.navigator,jira.view.issue,jira.global,atl.general,-_super/batch.css?jira.create.linked.issue=true&richediton=true","startTime":223,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":223,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":330.0999994277954,"responseStart":0,"secureConnectionStart":0},{"duration":563.3999996185303,"initiatorType":"script","name":"https://community.i2b2.org/jira/s/4c9c503fe98f210445831b0d7b0cdc33-CDN/4x9nqn/820011/16zrvj4/49fa3aa3d35a2cc689cbf274e66cc41a/_/download/contextbatch/js/_super/batch.js?locale=en-US","startTime":223.19999980926514,"connectEnd":665.5,"connectStart":645.6999998092651,"domainLookupEnd":645.6999998092651,"domainLookupStart":645.6999998092651,"fetchStart":223.19999980926514,"redirectEnd":0,"redirectStart":0,"requestStart":666.0999994277954,"responseEnd":786.5999994277954,"responseStart":681.3999996185303,"secureConnectionStart":655.6999998092651},{"duration":550.9000005722046,"initiatorType":"script","name":"https://community.i2b2.org/jira/s/694e598c1ae48b0f96655173631cd247-CDN/4x9nqn/820011/16zrvj4/f614b50eeb842ebd1ea7ab2903699907/_/download/contextbatch/js/project.issue.navigator,jira.view.issue,jira.global,atl.general,-_super/batch.js?jira.create.linked.issue=true&locale=en-US&richediton=true","startTime":223.29999923706055,"connectEnd":675.5,"connectStart":656.2999992370605,"domainLookupEnd":656.2999992370605,"domainLookupStart":656.2999992370605,"fetchStart":223.29999923706055,"redirectEnd":0,"redirectStart":0,"requestStart":675.5999994277954,"responseEnd":774.1999998092651,"responseStart":691.7999992370605,"secureConnectionStart":665.7999992370605},{"duration":468.80000019073486,"initiatorType":"script","name":"https://community.i2b2.org/jira/s/53f54e0ac3f00bb56b136b4d2fff2853-CDN/4x9nqn/820011/16zrvj4/aae1242f5fc81cc6a5bb8bc963ccda29/_/download/contextbatch/js/atl.global,-_super/batch.js?locale=en-US","startTime":223.5999994277954,"connectEnd":679.2999992370605,"connectStart":657.7999992370605,"domainLookupEnd":657.7999992370605,"domainLookupStart":657.7999992370605,"fetchStart":223.5999994277954,"redirectEnd":0,"redirectStart":0,"requestStart":679.3999996185303,"responseEnd":692.3999996185303,"responseStart":690.6999998092651,"secureConnectionStart":667.0999994277954},{"duration":483,"initiatorType":"script","name":"https://community.i2b2.org/jira/s/d41d8cd98f00b204e9800998ecf8427e-CDN/4x9nqn/820011/16zrvj4/1.0/_/download/batch/jira.webresources:calendar-en/jira.webresources:calendar-en.js","startTime":223.69999980926514,"connectEnd":693.0999994277954,"connectStart":669.6999998092651,"domainLookupEnd":669.6999998092651,"domainLookupStart":669.6999998092651,"fetchStart":223.69999980926514,"redirectEnd":0,"redirectStart":0,"requestStart":693.2999992370605,"responseEnd":706.6999998092651,"responseStart":705.7999992370605,"secureConnectionStart":680.8999996185303},{"duration":500.6000003814697,"initiatorType":"script","name":"https://community.i2b2.org/jira/s/d41d8cd98f00b204e9800998ecf8427e-CDN/4x9nqn/820011/16zrvj4/1.0/_/download/batch/jira.webresources:calendar-localisation-moment/jira.webresources:calendar-localisation-moment.js","startTime":223.79999923706055,"connectEnd":711.5999994277954,"connectStart":692.2999992370605,"domainLookupEnd":692.2999992370605,"domainLookupStart":692.2999992370605,"fetchStart":223.79999923706055,"redirectEnd":0,"redirectStart":0,"requestStart":711.6999998092651,"responseEnd":724.3999996185303,"responseStart":723.2999992370605,"secureConnectionStart":701.7999992370605},{"duration":111.40000057220459,"initiatorType":"link","name":"https://community.i2b2.org/jira/s/30748292e4ca68be6947d7969829384b-CDN/4x9nqn/820011/16zrvj4/4f66da484ef7d95a2a604d3ab014374c/_/download/contextbatch/css/jira.global.look-and-feel,-_super/batch.css","startTime":224.0999994277954,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":224.0999994277954,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":335.5,"responseStart":0,"secureConnectionStart":0},{"duration":518.8999996185303,"initiatorType":"script","name":"https://community.i2b2.org/jira/rest/api/1.0/shortcuts/820011/a9e270f026ecabffc9a59343e5439391/shortcuts.js?context=issuenavigation&context=issueaction","startTime":224.19999980926514,"connectEnd":726,"connectStart":706.5999994277954,"domainLookupEnd":706.5999994277954,"domainLookupStart":706.5999994277954,"fetchStart":224.19999980926514,"redirectEnd":0,"redirectStart":0,"requestStart":726,"responseEnd":743.0999994277954,"responseStart":741.6999998092651,"secureConnectionStart":716.0999994277954},{"duration":147.5,"initiatorType":"link","name":"https://community.i2b2.org/jira/s/3ac36323ba5e4eb0af2aa7ac7211b4bb-CDN/4x9nqn/820011/16zrvj4/efa42a25652b26dfd802540c024826b3/_/download/contextbatch/css/com.atlassian.jira.projects.sidebar.init,-_super,-jira.view.issue,-project.issue.navigator/batch.css?jira.create.linked.issue=true&richediton=true","startTime":375.3999996185303,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":375.3999996185303,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":522.8999996185303,"responseStart":0,"secureConnectionStart":0},{"duration":447.80000019073486,"initiatorType":"script","name":"https://community.i2b2.org/jira/s/8087506fefd02b4096991c90836b49f6-CDN/4x9nqn/820011/16zrvj4/efa42a25652b26dfd802540c024826b3/_/download/contextbatch/js/com.atlassian.jira.projects.sidebar.init,-_super,-jira.view.issue,-project.issue.navigator/batch.js?jira.create.linked.issue=true&locale=en-US&richediton=true","startTime":375.5999994277954,"connectEnd":809.1999998092651,"connectStart":788,"domainLookupEnd":788,"domainLookupStart":788,"fetchStart":375.5999994277954,"redirectEnd":0,"redirectStart":0,"requestStart":810.5,"responseEnd":823.3999996185303,"responseStart":822.3999996185303,"secureConnectionStart":797.2999992370605},{"duration":750.6999998092651,"initiatorType":"script","name":"https://community.i2b2.org/jira/s/d41d8cd98f00b204e9800998ecf8427e-CDN/4x9nqn/820011/16zrvj4/1.0/_/download/batch/jira.webresources:bigpipe-js/jira.webresources:bigpipe-js.js","startTime":414.5999994277954,"connectEnd":1153.2999992370605,"connectStart":1134.0999994277954,"domainLookupEnd":1134.0999994277954,"domainLookupStart":1134.0999994277954,"fetchStart":414.5999994277954,"redirectEnd":0,"redirectStart":0,"requestStart":1153.3999996185303,"responseEnd":1165.2999992370605,"responseStart":1164.2999992370605,"secureConnectionStart":1143.5999994277954},{"duration":615.8999996185303,"initiatorType":"script","name":"https://community.i2b2.org/jira/s/d41d8cd98f00b204e9800998ecf8427e-CDN/4x9nqn/820011/16zrvj4/1.0/_/download/batch/jira.webresources:bigpipe-init/jira.webresources:bigpipe-init.js","startTime":551.1999998092651,"connectEnd":1154.8999996185303,"connectStart":1135.7999992370605,"domainLookupEnd":1135.7999992370605,"domainLookupStart":1135.7999992370605,"fetchStart":551.1999998092651,"redirectEnd":0,"redirectStart":0,"requestStart":1154.8999996185303,"responseEnd":1167.0999994277954,"responseStart":1165.5999994277954,"secureConnectionStart":1145.1999998092651},{"duration":195.89999961853027,"initiatorType":"xmlhttprequest","name":"https://community.i2b2.org/jira/rest/webResources/1.0/resources","startTime":955.8999996185303,"connectEnd":1137,"connectStart":1131.0999994277954,"domainLookupEnd":1131.0999994277954,"domainLookupStart":1131.0999994277954,"fetchStart":955.8999996185303,"redirectEnd":0,"redirectStart":0,"requestStart":1137,"responseEnd":1151.7999992370605,"responseStart":1151.1999998092651,"secureConnectionStart":1131.0999994277954}],"fetchStart":0,"domainLookupStart":78,"domainLookupEnd":120,"connectStart":120,"connectEnd":152,"secureConnectionStart":130,"requestStart":152,"responseStart":206,"responseEnd":551,"domLoading":221,"domInteractive":1199,"domContentLoadedEventStart":1199,"domContentLoadedEventEnd":1235,"domComplete":1440,"loadEventStart":1440,"loadEventEnd":1441,"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","marks":[{"name":"bigPipe.sidebar-id.start","time":1170.1999998092651},{"name":"bigPipe.sidebar-id.end","time":1171},{"name":"bigPipe.activity-panel-pipe-id.start","time":1171.1999998092651},{"name":"bigPipe.activity-panel-pipe-id.end","time":1176.2999992370605},{"name":"activityTabFullyLoaded","time":1258.5}],"measures":[],"correlationId":"d27e68b2607ee4","effectiveType":"4g","downlink":9.5,"rtt":0,"serverDuration":386,"dbReadsTimeInMs":93,"dbConnsTimeInMs":135,"applicationHash":"0629dd8d260e3954ece49053e565d01dabe11609","experiments":[]}}
In the Web Client the query appears to be cancelled. The query will appear in Show Query Status with a "Cancelled" status however when I look in the qt_query_master table it looks like the query was not cancelled. The query doesn't have a DELETE_DATE and the DELETE_FLAG is set to N. Also, an ERROR message is returned to the user instead of the locked out message.
2 screen shots attached
obfscUser-lockOut-qryError.png – shows ERROR message returned
obfscUser-lockOut-qryCancelled-2.png – shows query cancelled in Show Query Status
This issue is being returned to development.