i2b2 Sponsored Project/s:
Affects Web Browser/s:
Chrome , Firefox , Internet Explorer , Safari
Reproduction Notes:
Hide
I am not able to reproduce it in the i2b2 development environment but I am able to reproduce it on the public webclient (i2b2.org site).
The problem may be with the data in the metadata tables. The database/schema information prefacing the calculations may be incorrect.
Show
I am not able to reproduce it in the i2b2 development environment but I am able to reproduce it on the public webclient (i2b2.org site).
The problem may be with the data in the metadata tables. The database/schema information prefacing the calculations may be incorrect.
An error is returned when running a query in which one of the concepts is an "Age at visit" term.
{"report":{"fcp":541.4000000059605,"ttfb":41.900000005960464,"pageVisibility":"visible","entityId":10273,"key":"jira.project.issue.view-issue","isInitial":true,"threshold":1000,"elementTimings":{},"userDeviceMemory":8,"userDeviceProcessors":16,"apdex":1,"journeyId":"52b924ac-54a8-4d3f-8f05-ed834635e4e0","navigationType":0,"readyForUser":592.5999999940395,"redirectCount":0,"resourceLoadedEnd":337.30000001192093,"resourceLoadedStart":46.599999994039536,"resourceTiming":[{"duration":5.9000000059604645,"initiatorType":"link","name":"https://community.i2b2.org/jira/s/7fd763ecdf5ed1f47fc4d22fa8382e97-CDN/4x9nqn/820011/16zrvj4/49fa3aa3d35a2cc689cbf274e66cc41a/_/download/contextbatch/css/_super/batch.css","startTime":46.599999994039536,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":46.599999994039536,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":52.5,"responseStart":0,"secureConnectionStart":0},{"duration":6.399999976158142,"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":46.80000001192093,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":46.80000001192093,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":53.19999998807907,"responseStart":0,"secureConnectionStart":0},{"duration":232.2999999821186,"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":46.900000005960464,"connectEnd":173,"connectStart":56.19999998807907,"domainLookupEnd":46.900000005960464,"domainLookupStart":46.900000005960464,"fetchStart":46.900000005960464,"redirectEnd":0,"redirectStart":0,"requestStart":173.09999999403954,"responseEnd":279.19999998807907,"responseStart":196.40000000596046,"secureConnectionStart":157.90000000596046},{"duration":288,"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":47,"connectEnd":256.40000000596046,"connectStart":231.69999998807907,"domainLookupEnd":47,"domainLookupStart":47,"fetchStart":47,"redirectEnd":0,"redirectStart":0,"requestStart":256.5,"responseEnd":335,"responseStart":277.5,"secureConnectionStart":244},{"duration":184.80000001192093,"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":47.099999994039536,"connectEnd":215.80000001192093,"connectStart":169.40000000596046,"domainLookupEnd":47.099999994039536,"domainLookupStart":47.099999994039536,"fetchStart":47.099999994039536,"redirectEnd":0,"redirectStart":0,"requestStart":215.90000000596046,"responseEnd":231.90000000596046,"responseStart":231,"secureConnectionStart":203.19999998807907},{"duration":194.80000001192093,"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":47.19999998807907,"connectEnd":220.19999998807907,"connectStart":181.59999999403954,"domainLookupEnd":47.19999998807907,"domainLookupStart":47.19999998807907,"fetchStart":47.19999998807907,"redirectEnd":0,"redirectStart":0,"requestStart":220.19999998807907,"responseEnd":242,"responseStart":240.40000000596046,"secureConnectionStart":208.09999999403954},{"duration":194.09999999403954,"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":47.400000005960464,"connectEnd":222.09999999403954,"connectStart":195.59999999403954,"domainLookupEnd":47.400000005960464,"domainLookupStart":47.400000005960464,"fetchStart":47.400000005960464,"redirectEnd":0,"redirectStart":0,"requestStart":222.19999998807907,"responseEnd":241.5,"responseStart":239.5,"secureConnectionStart":209.5},{"duration":10.5,"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":47.5,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":47.5,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":58,"responseStart":0,"secureConnectionStart":0},{"duration":234,"initiatorType":"script","name":"https://community.i2b2.org/jira/rest/api/1.0/shortcuts/820011/5c69e534a30b62def7b98bda0f001346/shortcuts.js?context=issuenavigation&context=issueaction","startTime":47.599999994039536,"connectEnd":265.59999999403954,"connectStart":241.40000000596046,"domainLookupEnd":47.599999994039536,"domainLookupStart":47.599999994039536,"fetchStart":47.599999994039536,"redirectEnd":0,"redirectStart":0,"requestStart":265.59999999403954,"responseEnd":281.59999999403954,"responseStart":280.69999998807907,"secureConnectionStart":253.30000001192093},{"duration":2.4000000059604645,"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":88.19999998807907,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":88.19999998807907,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":90.59999999403954,"responseStart":0,"secureConnectionStart":0},{"duration":203.5,"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":88.40000000596046,"connectEnd":271.59999999403954,"connectStart":242,"domainLookupEnd":88.40000000596046,"domainLookupStart":88.40000000596046,"fetchStart":88.40000000596046,"redirectEnd":0,"redirectStart":0,"requestStart":271.69999998807907,"responseEnd":291.90000000596046,"responseStart":290.59999999403954,"secureConnectionStart":255.80000001192093},{"duration":233.69999998807907,"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":95.80000001192093,"connectEnd":309.5,"connectStart":281.59999999403954,"domainLookupEnd":95.80000001192093,"domainLookupStart":95.80000001192093,"fetchStart":95.80000001192093,"redirectEnd":0,"redirectStart":0,"requestStart":309.5,"responseEnd":329.5,"responseStart":328.19999998807907,"secureConnectionStart":294.09999999403954},{"duration":167.7000000178814,"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":169.59999999403954,"connectEnd":323.40000000596046,"connectStart":291.80000001192093,"domainLookupEnd":169.59999999403954,"domainLookupStart":169.59999999403954,"fetchStart":169.59999999403954,"redirectEnd":0,"redirectStart":0,"requestStart":323.80000001192093,"responseEnd":337.30000001192093,"responseStart":336.5,"secureConnectionStart":308.90000000596046},{"duration":168.19999998807907,"initiatorType":"xmlhttprequest","name":"https://community.i2b2.org/jira/rest/webResources/1.0/resources","startTime":469.30000001192093,"connectEnd":620.3000000119209,"connectStart":595.9000000059605,"domainLookupEnd":469.30000001192093,"domainLookupStart":469.30000001192093,"fetchStart":469.30000001192093,"redirectEnd":0,"redirectStart":0,"requestStart":620.3000000119209,"responseEnd":637.5,"responseStart":636.8000000119209,"secureConnectionStart":608}],"fetchStart":0,"domainLookupStart":0,"domainLookupEnd":0,"connectStart":0,"connectEnd":0,"requestStart":14,"responseStart":42,"responseEnd":169,"domLoading":45,"domInteractive":655,"domContentLoadedEventStart":655,"domContentLoadedEventEnd":694,"domComplete":960,"loadEventStart":960,"loadEventEnd":960,"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","marks":[{"name":"bigPipe.sidebar-id.start","time":634.9000000059605},{"name":"bigPipe.sidebar-id.end","time":635.5999999940395},{"name":"bigPipe.activity-panel-pipe-id.start","time":635.6999999880791},{"name":"bigPipe.activity-panel-pipe-id.end","time":638.1999999880791},{"name":"activityTabFullyLoaded","time":703.1999999880791}],"measures":[],"correlationId":"855abb3a8efa91","effectiveType":"4g","downlink":10,"rtt":0,"serverDuration":141,"dbReadsTimeInMs":13,"dbConnsTimeInMs":18,"applicationHash":"0629dd8d260e3954ece49053e565d01dabe11609","experiments":[]}}