Type:
Bug
Status:
Closed
Priority:
Minor
Resolution:
Fixed
Affects Version/s:
None
Component/s:
None
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.
EXAMPLE:
lockout count = 7
obfuscated user runs same query 7 times and gets results returned each time.
The next time (8th time) the obfuscated user runs the query, the status of Cancelled will display in Show Query Status. However, when you look in the qt_query_master table the query doesn't have a DELETE_DATE or DELETE_FLAG which indicates the query was not cancelled as indicated in the Web Client.
{"report":{"fcp":484,"ttfb":72.70000000298023,"pageVisibility":"visible","entityId":11270,"key":"jira.project.issue.view-issue","isInitial":true,"threshold":1000,"elementTimings":{},"userDeviceMemory":8,"userDeviceProcessors":16,"apdex":1,"journeyId":"17db8f5e-b422-40a6-8b29-0a24333ddff9","navigationType":0,"readyForUser":529.6000000014901,"redirectCount":0,"resourceLoadedEnd":366.1000000014901,"resourceLoadedStart":78.60000000149012,"resourceTiming":[{"duration":60,"initiatorType":"link","name":"https://community.i2b2.org/jira/s/7fd763ecdf5ed1f47fc4d22fa8382e97-CDN/4x9nqn/820011/16zrvj4/49fa3aa3d35a2cc689cbf274e66cc41a/_/download/contextbatch/css/_super/batch.css","startTime":78.60000000149012,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":78.60000000149012,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":138.60000000149012,"responseStart":0,"secureConnectionStart":0},{"duration":60.399999998509884,"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":78.90000000223517,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":78.90000000223517,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":139.30000000074506,"responseStart":0,"secureConnectionStart":0},{"duration":104.59999999776483,"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":78.90000000223517,"connectEnd":78.90000000223517,"connectStart":78.90000000223517,"domainLookupEnd":78.90000000223517,"domainLookupStart":78.90000000223517,"fetchStart":78.90000000223517,"redirectEnd":0,"redirectStart":0,"requestStart":78.90000000223517,"responseEnd":183.5,"responseStart":183.5,"secureConnectionStart":78.90000000223517},{"duration":126.40000000223517,"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":79,"connectEnd":79,"connectStart":79,"domainLookupEnd":79,"domainLookupStart":79,"fetchStart":79,"redirectEnd":0,"redirectStart":0,"requestStart":79,"responseEnd":205.40000000223517,"responseStart":205.30000000074506,"secureConnectionStart":79},{"duration":128.19999999925494,"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":79.10000000149012,"connectEnd":79.10000000149012,"connectStart":79.10000000149012,"domainLookupEnd":79.10000000149012,"domainLookupStart":79.10000000149012,"fetchStart":79.10000000149012,"redirectEnd":0,"redirectStart":0,"requestStart":79.10000000149012,"responseEnd":207.30000000074506,"responseStart":207.30000000074506,"secureConnectionStart":79.10000000149012},{"duration":128.39999999850988,"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":79.20000000298023,"connectEnd":79.20000000298023,"connectStart":79.20000000298023,"domainLookupEnd":79.20000000298023,"domainLookupStart":79.20000000298023,"fetchStart":79.20000000298023,"redirectEnd":0,"redirectStart":0,"requestStart":79.20000000298023,"responseEnd":207.60000000149012,"responseStart":207.60000000149012,"secureConnectionStart":79.20000000298023},{"duration":130.19999999925494,"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":79.40000000223517,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":79.40000000223517,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":209.60000000149012,"responseStart":0,"secureConnectionStart":0},{"duration":128.59999999776483,"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":79.40000000223517,"connectEnd":79.40000000223517,"connectStart":79.40000000223517,"domainLookupEnd":79.40000000223517,"domainLookupStart":79.40000000223517,"fetchStart":79.40000000223517,"redirectEnd":0,"redirectStart":0,"requestStart":79.40000000223517,"responseEnd":208,"responseStart":208,"secureConnectionStart":79.40000000223517},{"duration":128.89999999850988,"initiatorType":"script","name":"https://community.i2b2.org/jira/rest/api/1.0/shortcuts/820011/5c69e534a30b62def7b98bda0f001346/shortcuts.js?context=issuenavigation&context=issueaction","startTime":79.60000000149012,"connectEnd":79.60000000149012,"connectStart":79.60000000149012,"domainLookupEnd":79.60000000149012,"domainLookupStart":79.60000000149012,"fetchStart":79.60000000149012,"redirectEnd":0,"redirectStart":0,"requestStart":79.60000000149012,"responseEnd":208.5,"responseStart":208.40000000223517,"secureConnectionStart":79.60000000149012},{"duration":110.30000000074506,"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":101,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":101,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":211.30000000074506,"responseStart":0,"secureConnectionStart":0},{"duration":110.19999999925494,"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":101.20000000298023,"connectEnd":101.20000000298023,"connectStart":101.20000000298023,"domainLookupEnd":101.20000000298023,"domainLookupStart":101.20000000298023,"fetchStart":101.20000000298023,"redirectEnd":0,"redirectStart":0,"requestStart":101.20000000298023,"responseEnd":211.40000000223517,"responseStart":211.40000000223517,"secureConnectionStart":101.20000000298023},{"duration":223,"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":109,"connectEnd":109,"connectStart":109,"domainLookupEnd":109,"domainLookupStart":109,"fetchStart":109,"redirectEnd":0,"redirectStart":0,"requestStart":109,"responseEnd":332,"responseStart":332,"secureConnectionStart":109},{"duration":252.39999999850988,"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":113.70000000298023,"connectEnd":113.70000000298023,"connectStart":113.70000000298023,"domainLookupEnd":113.70000000298023,"domainLookupStart":113.70000000298023,"fetchStart":113.70000000298023,"redirectEnd":0,"redirectStart":0,"requestStart":113.70000000298023,"responseEnd":366.1000000014901,"responseStart":366.1000000014901,"secureConnectionStart":113.70000000298023},{"duration":82.70000000298023,"initiatorType":"xmlhttprequest","name":"https://community.i2b2.org/jira/rest/webResources/1.0/resources","startTime":390.5,"connectEnd":390.5,"connectStart":390.5,"domainLookupEnd":390.5,"domainLookupStart":390.5,"fetchStart":390.5,"redirectEnd":0,"redirectStart":0,"requestStart":390.5,"responseEnd":473.20000000298023,"responseStart":473.20000000298023,"secureConnectionStart":390.5}],"fetchStart":0,"domainLookupStart":0,"domainLookupEnd":0,"connectStart":33,"connectEnd":45,"secureConnectionStart":34,"requestStart":46,"responseStart":73,"responseEnd":113,"domLoading":77,"domInteractive":577,"domContentLoadedEventStart":577,"domContentLoadedEventEnd":611,"domComplete":1101,"loadEventStart":1101,"loadEventEnd":1103,"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","marks":[{"name":"bigPipe.sidebar-id.start","time":558.7000000029802},{"name":"bigPipe.sidebar-id.end","time":559.5},{"name":"bigPipe.activity-panel-pipe-id.start","time":559.6000000014901},{"name":"bigPipe.activity-panel-pipe-id.end","time":562},{"name":"activityTabFullyLoaded","time":619.9000000022352}],"measures":[],"correlationId":"cf961eb40c1df8","effectiveType":"4g","downlink":10,"rtt":0,"serverDuration":55,"dbReadsTimeInMs":6,"dbConnsTimeInMs":9,"applicationHash":"0629dd8d260e3954ece49053e565d01dabe11609","experiments":[]}}