i2b2 Sponsored Project/s:
Developer Notes:
Hide
This was fixed on 12/2/2014. Rev # 5285 and will be included in the 1.7.05 release.
"I2B2DEMODATA"." was removed from the following oracle scripts:
INSERT_EID_MAP_FROMTEMP.sql
UPDATE_OBSERVATION_FACT.sql
Show
This was fixed on 12/2/2014. Rev # 5285 and will be included in the 1.7.05 release.
"I2B2DEMODATA"." was removed from the following oracle scripts:
INSERT_EID_MAP_FROMTEMP.sql
UPDATE_OBSERVATION_FACT.sql
The following two files have hard coded references to I2B2DEMODATA in the linux oracle script files which causes the install to fail (ORA-01031: insufficient privileges) if you are trying to use the scripts for schemas other than I2B2DEMODATA
edu.harvard.i2b2.data/Release_1-7/NewInstall/Crcdata/scripts/procedures/oracle/INSERT_EID_MAP_FROMTEMP.sql
edu.harvard.i2b2.data/Release_1-7/NewInstall/Crcdata/scripts/procedures/oracle/UPDATE_OBSERVATION_FACT.sql
{"report":{"fcp":914,"ttfb":154.5999994277954,"pageVisibility":"visible","entityId":10400,"key":"jira.project.issue.view-issue","isInitial":true,"threshold":1000,"elementTimings":{},"userDeviceMemory":8,"userDeviceProcessors":32,"apdex":1,"journeyId":"7c7af154-19e6-42e0-ad0f-c01d50b2c793","navigationType":0,"readyForUser":967.3999996185303,"redirectCount":0,"resourceLoadedEnd":700.8000001907349,"resourceLoadedStart":165.0999994277954,"resourceTiming":[{"duration":32.40000057220459,"initiatorType":"link","name":"https://community.i2b2.org/jira/s/7fd763ecdf5ed1f47fc4d22fa8382e97-CDN/4x9nqn/820011/16zrvj4/49fa3aa3d35a2cc689cbf274e66cc41a/_/download/contextbatch/css/_super/batch.css","startTime":165.0999994277954,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":165.0999994277954,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":197.5,"responseStart":0,"secureConnectionStart":0},{"duration":35.5,"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":165.39999961853027,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":165.39999961853027,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":200.89999961853027,"responseStart":0,"secureConnectionStart":0},{"duration":461.9000005722046,"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":165.5999994277954,"connectEnd":516,"connectStart":497,"domainLookupEnd":497,"domainLookupStart":497,"fetchStart":165.5999994277954,"redirectEnd":0,"redirectStart":0,"requestStart":516.0999994277954,"responseEnd":627.5,"responseStart":531.3000001907349,"secureConnectionStart":506.30000019073486},{"duration":445.1000003814697,"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":166.0999994277954,"connectEnd":523.0999994277954,"connectStart":503.69999980926514,"domainLookupEnd":503.69999980926514,"domainLookupStart":503.69999980926514,"fetchStart":166.0999994277954,"redirectEnd":0,"redirectStart":0,"requestStart":523.3000001907349,"responseEnd":611.1999998092651,"responseStart":538.0999994277954,"secureConnectionStart":513},{"duration":388.30000019073486,"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":166.19999980926514,"connectEnd":542,"connectStart":522.0999994277954,"domainLookupEnd":522.0999994277954,"domainLookupStart":522.0999994277954,"fetchStart":166.19999980926514,"redirectEnd":0,"redirectStart":0,"requestStart":542.0999994277954,"responseEnd":554.5,"responseStart":553.1999998092651,"secureConnectionStart":532.1999998092651},{"duration":397.19999980926514,"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":166.5,"connectEnd":549.3000001907349,"connectStart":526.5,"domainLookupEnd":526.5,"domainLookupStart":526.3999996185303,"fetchStart":166.5,"redirectEnd":0,"redirectStart":0,"requestStart":549.3999996185303,"responseEnd":563.6999998092651,"responseStart":562.5999994277954,"secureConnectionStart":537.8000001907349},{"duration":420.30000019073486,"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":166.5999994277954,"connectEnd":574,"connectStart":554.3999996185303,"domainLookupEnd":554.3999996185303,"domainLookupStart":554.3999996185303,"fetchStart":166.5999994277954,"redirectEnd":0,"redirectStart":0,"requestStart":574,"responseEnd":586.8999996185303,"responseStart":585.3000001907349,"secureConnectionStart":564},{"duration":38.69999980926514,"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":166.69999980926514,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":166.69999980926514,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":205.39999961853027,"responseStart":0,"secureConnectionStart":0},{"duration":435.4000005722046,"initiatorType":"script","name":"https://community.i2b2.org/jira/rest/api/1.0/shortcuts/820011/a9e270f026ecabffc9a59343e5439391/shortcuts.js?context=issuenavigation&context=issueaction","startTime":166.89999961853027,"connectEnd":586.6999998092651,"connectStart":563.5999994277954,"domainLookupEnd":563.5999994277954,"domainLookupStart":563.5999994277954,"fetchStart":166.89999961853027,"redirectEnd":0,"redirectStart":0,"requestStart":587.5,"responseEnd":602.3000001907349,"responseStart":600.5,"secureConnectionStart":574.8000001907349},{"duration":44,"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":234,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":234,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":278,"responseStart":0,"secureConnectionStart":0},{"duration":385.19999980926514,"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":234.19999980926514,"connectEnd":606,"connectStart":586.8000001907349,"domainLookupEnd":586.8000001907349,"domainLookupStart":586.8000001907349,"fetchStart":234.19999980926514,"redirectEnd":0,"redirectStart":0,"requestStart":606,"responseEnd":619.3999996185303,"responseStart":617.8999996185303,"secureConnectionStart":596.0999994277954},{"duration":428.19999980926514,"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":262.80000019073486,"connectEnd":678.3999996185303,"connectStart":658.6999998092651,"domainLookupEnd":658.6999998092651,"domainLookupStart":658.6999998092651,"fetchStart":262.80000019073486,"redirectEnd":0,"redirectStart":0,"requestStart":678.3999996185303,"responseEnd":691,"responseStart":689.5,"secureConnectionStart":668.0999994277954},{"duration":297.4000005722046,"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":403.3999996185303,"connectEnd":686.6999998092651,"connectStart":663.5,"domainLookupEnd":663.5,"domainLookupStart":663.5,"fetchStart":403.3999996185303,"redirectEnd":0,"redirectStart":0,"requestStart":686.6999998092651,"responseEnd":700.8000001907349,"responseStart":699.6999998092651,"secureConnectionStart":675}],"fetchStart":0,"domainLookupStart":16,"domainLookupEnd":75,"connectStart":75,"connectEnd":110,"secureConnectionStart":86,"requestStart":110,"responseStart":154,"responseEnd":403,"domLoading":160,"domInteractive":1013,"domContentLoadedEventStart":1013,"domContentLoadedEventEnd":1049,"domComplete":1486,"loadEventStart":1486,"loadEventEnd":1488,"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","marks":[{"name":"bigPipe.sidebar-id.start","time":994.3000001907349},{"name":"bigPipe.sidebar-id.end","time":995},{"name":"bigPipe.activity-panel-pipe-id.start","time":995.1999998092651},{"name":"bigPipe.activity-panel-pipe-id.end","time":997.6999998092651},{"name":"activityTabFullyLoaded","time":1060.6999998092651}],"measures":[],"correlationId":"b3fd3d380350f","effectiveType":"4g","downlink":9,"rtt":0,"serverDuration":278,"dbReadsTimeInMs":24,"dbConnsTimeInMs":27,"applicationHash":"0629dd8d260e3954ece49053e565d01dabe11609","experiments":[]}}