Type:
Bug
Status:
Reopened
Priority:
Major
Resolution:
Unresolved
Affects Version/s:
None
Component/s:
None
Developer Notes:
Hide
The way to test this is to
1. Modify the crc properties file to use
# Paging method can be SUBDIVIDE_INPUT_METHOD/AVERAGE_OBSERVATION_METHOD
edu.harvard.i2b2.crc.pdo.paging.method=AVERAGE_OBSERVATION_METHOD
2. Request a PDO using a large data set that exceeds the observation fact page size of 5000. This method will converge on a page size much faster than the SUBDIVIDE method
Show
The way to test this is to
1. Modify the crc properties file to use
# Paging method can be SUBDIVIDE_INPUT_METHOD/AVERAGE_OBSERVATION_METHOD
edu.harvard.i2b2.crc.pdo.paging.method=AVERAGE_OBSERVATION_METHOD
2. Request a PDO using a large data set that exceeds the observation fact page size of 5000. This method will converge on a page size much faster than the SUBDIVIDE method
Server Plug-in/s Modified:
This method was converging on a page size that was over the page size limit. Fix was to alter the algorithm.
Lori Phillips
made changes -
23/Aug/18 1:22 PM
Field
Original Value
New Value
Status
New
[ 10000
]
Open
[ 1
]
Lori Phillips
made changes -
23/Aug/18 1:22 PM
Status
Open
[ 1
]
In Progress
[ 3
]
Lori Phillips
made changes -
23/Aug/18 1:27 PM
Developer Notes
The way to test this is to
1. Modify the crc properties file to use
# Paging method can be SUBDIVIDE_INPUT_METHOD/AVERAGE_OBSERVATION_METHOD
edu.harvard.i2b2.crc.pdo.paging.method=AVERAGE_OBSERVATION_METHOD
2. Request a PDO using a large data set that exceeds the observation fact page size of 5000. This method will converge on a page size much faster than the SUBDIVIDE method
Fix Version/s
1.7.11
[ 10703
]
Server Plug-in/s Modified
edu.harvard.i2b2.crc
[ 10114
]
Status
In Progress
[ 3
]
Ready to Test
[ 10001
]
Reeta Metta
made changes -
23/Jan/19 4:50 PM
Assignee
Lori Phillips
[ lcp5
]
Reeta Metta
[ rm302
]
Reeta Metta
made changes -
23/Jan/19 4:50 PM
Status
Ready to Test
[ 10001
]
Testing
[ 10002
]
Reeta Metta
made changes -
24/Jan/19 2:04 PM
Assignee
Reeta Metta
[ rm302
]
Mike Mendis
[ mem61
]
Status
Testing
[ 10002
]
Reopened
[ 4
]
Mike Mendis
made changes -
11/Feb/19 2:53 PM
Status
Reopened
[ 4
]
In Progress
[ 3
]
Mike Mendis
made changes -
26/Aug/19 2:41 PM
Fix Version/s
1.7.12
[ 10901
]
Reeta Metta
made changes -
25/Sep/19 5:59 PM
Assignee
Mike Mendis
[ mem61
]
Reeta Metta
[ rm302
]
Reeta Metta
made changes -
25/Sep/19 5:59 PM
Status
In Progress
[ 3
]
Ready to Test
[ 10001
]
Reeta Metta
made changes -
26/Sep/19 2:32 PM
Status
Ready to Test
[ 10001
]
Testing
[ 10002
]
Reeta Metta
made changes -
01/Oct/19 2:20 PM
Assignee
Reeta Metta
[ rm302
]
Mike Mendis
[ mem61
]
Status
Testing
[ 10002
]
Reopened
[ 4
]
Reeta Metta
made changes -
02/Oct/19 6:13 PM
Fix Version/s
1.7.13
[ 10902
]
Reeta Metta
made changes -
16/Oct/19 5:55 PM
Fix Version/s
1.7.12
[ 10901
]
Reeta Metta
made changes -
16/Mar/20 6:20 PM
Fix Version/s
TBD
[ 11005
]
Fix Version/s
1.7.11
[ 10703
]
Fix Version/s
1.7.13
[ 10902
]
{"report":{"fcp":502.39999997615814,"ttfb":75.39999997615814,"pageVisibility":"visible","entityId":11488,"key":"jira.project.issue.view-issue","isInitial":true,"threshold":1000,"elementTimings":{},"userDeviceMemory":8,"userDeviceProcessors":16,"apdex":1,"journeyId":"1adf7dff-7efe-4965-8f78-75a941832604","navigationType":0,"readyForUser":591.2999999821186,"redirectCount":0,"resourceLoadedEnd":612.2999999821186,"resourceLoadedStart":80.89999997615814,"resourceTiming":[{"duration":28.5,"initiatorType":"link","name":"https://community.i2b2.org/jira/s/7fd763ecdf5ed1f47fc4d22fa8382e97-CDN/4x9nqn/820011/16zrvj4/49fa3aa3d35a2cc689cbf274e66cc41a/_/download/contextbatch/css/_super/batch.css","startTime":80.89999997615814,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":80.89999997615814,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":109.39999997615814,"responseStart":0,"secureConnectionStart":0},{"duration":28.400000005960464,"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":81.19999998807907,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":81.19999998807907,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":109.59999999403954,"responseStart":0,"secureConnectionStart":0},{"duration":72.09999999403954,"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":81.59999999403954,"connectEnd":81.59999999403954,"connectStart":81.59999999403954,"domainLookupEnd":81.59999999403954,"domainLookupStart":81.59999999403954,"fetchStart":81.59999999403954,"redirectEnd":0,"redirectStart":0,"requestStart":81.59999999403954,"responseEnd":153.69999998807907,"responseStart":153.69999998807907,"secureConnectionStart":81.59999999403954},{"duration":98.69999998807907,"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":81.69999998807907,"connectEnd":81.69999998807907,"connectStart":81.69999998807907,"domainLookupEnd":81.69999998807907,"domainLookupStart":81.69999998807907,"fetchStart":81.69999998807907,"redirectEnd":0,"redirectStart":0,"requestStart":81.69999998807907,"responseEnd":180.39999997615814,"responseStart":180.39999997615814,"secureConnectionStart":81.69999998807907},{"duration":101.09999999403954,"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":81.7999999821186,"connectEnd":81.7999999821186,"connectStart":81.7999999821186,"domainLookupEnd":81.7999999821186,"domainLookupStart":81.7999999821186,"fetchStart":81.7999999821186,"redirectEnd":0,"redirectStart":0,"requestStart":81.7999999821186,"responseEnd":182.89999997615814,"responseStart":182.89999997615814,"secureConnectionStart":81.7999999821186},{"duration":101.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":81.89999997615814,"connectEnd":81.89999997615814,"connectStart":81.89999997615814,"domainLookupEnd":81.89999997615814,"domainLookupStart":81.89999997615814,"fetchStart":81.89999997615814,"redirectEnd":0,"redirectStart":0,"requestStart":81.89999997615814,"responseEnd":183.69999998807907,"responseStart":183.69999998807907,"secureConnectionStart":81.89999997615814},{"duration":102.19999998807907,"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":82,"connectEnd":82,"connectStart":82,"domainLookupEnd":82,"domainLookupStart":82,"fetchStart":82,"redirectEnd":0,"redirectStart":0,"requestStart":82,"responseEnd":184.19999998807907,"responseStart":184.19999998807907,"secureConnectionStart":82},{"duration":106.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":82.09999999403954,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":82.09999999403954,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":188.59999999403954,"responseStart":0,"secureConnectionStart":0},{"duration":102.59999999403954,"initiatorType":"script","name":"https://community.i2b2.org/jira/rest/api/1.0/shortcuts/820011/5c69e534a30b62def7b98bda0f001346/shortcuts.js?context=issuenavigation&context=issueaction","startTime":82.19999998807907,"connectEnd":82.19999998807907,"connectStart":82.19999998807907,"domainLookupEnd":82.19999998807907,"domainLookupStart":82.19999998807907,"fetchStart":82.19999998807907,"redirectEnd":0,"redirectStart":0,"requestStart":82.19999998807907,"responseEnd":184.7999999821186,"responseStart":184.7999999821186,"secureConnectionStart":82.19999998807907},{"duration":104.7999999821186,"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":119.09999999403954,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":119.09999999403954,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":223.89999997615814,"responseStart":0,"secureConnectionStart":0},{"duration":101,"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":119.19999998807907,"connectEnd":119.19999998807907,"connectStart":119.19999998807907,"domainLookupEnd":119.19999998807907,"domainLookupStart":119.19999998807907,"fetchStart":119.19999998807907,"redirectEnd":0,"redirectStart":0,"requestStart":119.19999998807907,"responseEnd":220.19999998807907,"responseStart":220.09999999403954,"secureConnectionStart":119.19999998807907},{"duration":389.7000000178814,"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":127.2999999821186,"connectEnd":127.2999999821186,"connectStart":127.2999999821186,"domainLookupEnd":127.2999999821186,"domainLookupStart":127.2999999821186,"fetchStart":127.2999999821186,"redirectEnd":0,"redirectStart":0,"requestStart":127.2999999821186,"responseEnd":517,"responseStart":517,"secureConnectionStart":127.2999999821186},{"duration":446,"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":166.2999999821186,"connectEnd":166.2999999821186,"connectStart":166.2999999821186,"domainLookupEnd":166.2999999821186,"domainLookupStart":166.2999999821186,"fetchStart":166.2999999821186,"redirectEnd":0,"redirectStart":0,"requestStart":166.2999999821186,"responseEnd":612.2999999821186,"responseStart":612.2999999821186,"secureConnectionStart":166.2999999821186},{"duration":228.09999999403954,"initiatorType":"xmlhttprequest","name":"https://community.i2b2.org/jira/rest/webResources/1.0/resources","startTime":394.19999998807907,"connectEnd":394.19999998807907,"connectStart":394.19999998807907,"domainLookupEnd":394.19999998807907,"domainLookupStart":394.19999998807907,"fetchStart":394.19999998807907,"redirectEnd":0,"redirectStart":0,"requestStart":394.19999998807907,"responseEnd":622.2999999821186,"responseStart":622.1999999880791,"secureConnectionStart":394.19999998807907}],"fetchStart":0,"domainLookupStart":0,"domainLookupEnd":0,"connectStart":0,"connectEnd":0,"requestStart":47,"responseStart":75,"responseEnd":166,"domLoading":79,"domInteractive":750,"domContentLoadedEventStart":750,"domContentLoadedEventEnd":793,"domComplete":859,"loadEventStart":859,"loadEventEnd":859,"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","marks":[{"name":"bigPipe.sidebar-id.start","time":674.3999999761581},{"name":"bigPipe.sidebar-id.end","time":675.1999999880791},{"name":"bigPipe.activity-panel-pipe-id.start","time":675.3999999761581},{"name":"bigPipe.activity-panel-pipe-id.end","time":679.8999999761581},{"name":"activityTabFullyLoaded","time":817.1999999880791}],"measures":[],"correlationId":"9fb4dbb0a6be50","effectiveType":"4g","downlink":10,"rtt":0,"serverDuration":106,"dbReadsTimeInMs":16,"dbConnsTimeInMs":23,"applicationHash":"0629dd8d260e3954ece49053e565d01dabe11609","experiments":[]}}