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
Jeff Cox
created issue -
20/Mar/15 10:10 AM
Janice Donahoe
made changes -
23/Mar/15 2:30 PM
Field
Original Value
New Value
Affects Database/s
All databases
[ 10219
]
Component/s
Data
[ 10050
]
Fix Version/s
1.7.05
[ 10164
]
Affects Version/s
1.7.04
[ 10160
]
Assignee
Janice Donahoe
[ jmd86
]
i2b2 Sponsored Project/s
i2b2 Core
[ 10196
]
Status
New
[ 10000
]
Open
[ 1
]
Janice Donahoe
made changes -
23/Mar/15 2:31 PM
Status
Open
[ 1
]
In Progress
[ 3
]
Janice Donahoe
made changes -
23/Mar/15 2:33 PM
Developer Notes
This was fixed on 12/2/2014. Rev # 5285 and will be included in the 1.7.05 release.
SVN Revision Number
5285
Status
In Progress
[ 3
]
In Progress
[ 3
]
Janice Donahoe
made changes -
23/Mar/15 2:44 PM
Developer Notes
This was fixed on 12/2/2014. Rev # 5285 and will be included in the 1.7.05 release.
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
Status
In Progress
[ 3
]
Ready to Test
[ 10001
]
Janice Donahoe
made changes -
23/Mar/15 2:44 PM
Status
Ready to Test
[ 10001
]
Testing
[ 10002
]
Janice Donahoe
made changes -
30/Mar/15 11:02 AM
Resolution
Fixed
[ 1
]
Status
Testing
[ 10002
]
Resolved
[ 5
]
Janice Donahoe
made changes -
12/May/15 10:51 AM
Status
Resolved
[ 5
]
Closed
[ 6
]
{"report":{"fcp":802,"ttfb":148.69999980926514,"pageVisibility":"visible","entityId":10400,"key":"jira.project.issue.view-issue","isInitial":true,"threshold":1000,"elementTimings":{},"userDeviceMemory":8,"userDeviceProcessors":64,"apdex":1,"journeyId":"cdcabd14-849b-434c-adb4-1d58f5b94e26","navigationType":0,"readyForUser":853.9000005722046,"redirectCount":0,"resourceLoadedEnd":736.9000005722046,"resourceLoadedStart":157.10000038146973,"resourceTiming":[{"duration":5.199999809265137,"initiatorType":"link","name":"https://community.i2b2.org/jira/s/7fd763ecdf5ed1f47fc4d22fa8382e97-CDN/4x9nqn/820011/16zrvj4/49fa3aa3d35a2cc689cbf274e66cc41a/_/download/contextbatch/css/_super/batch.css","startTime":157.10000038146973,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":157.10000038146973,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":162.30000019073486,"responseStart":0,"secureConnectionStart":0},{"duration":5.399999618530273,"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":157.4000005722046,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":157.4000005722046,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":162.80000019073486,"responseStart":0,"secureConnectionStart":0},{"duration":383,"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":157.69999980926514,"connectEnd":452.4000005722046,"connectStart":432.6000003814697,"domainLookupEnd":432.6000003814697,"domainLookupStart":432.5,"fetchStart":157.69999980926514,"redirectEnd":0,"redirectStart":0,"requestStart":452.5,"responseEnd":540.6999998092651,"responseStart":470.9000005722046,"secureConnectionStart":442.4000005722046},{"duration":364.69999980926514,"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":158.10000038146973,"connectEnd":457.4000005722046,"connectStart":438.1000003814697,"domainLookupEnd":438.1000003814697,"domainLookupStart":438.1000003814697,"fetchStart":158.10000038146973,"redirectEnd":0,"redirectStart":0,"requestStart":457.4000005722046,"responseEnd":522.8000001907349,"responseStart":472.4000005722046,"secureConnectionStart":447.6000003814697},{"duration":311.8999996185303,"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":158.30000019073486,"connectEnd":457.6000003814697,"connectStart":438.5,"domainLookupEnd":438.5,"domainLookupStart":438.5,"fetchStart":158.30000019073486,"redirectEnd":0,"redirectStart":0,"requestStart":457.69999980926514,"responseEnd":470.19999980926514,"responseStart":469.1000003814697,"secureConnectionStart":447.80000019073486},{"duration":339.69999980926514,"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":158.5,"connectEnd":482.69999980926514,"connectStart":458.80000019073486,"domainLookupEnd":458.80000019073486,"domainLookupStart":458.80000019073486,"fetchStart":158.5,"redirectEnd":0,"redirectStart":0,"requestStart":482.9000005722046,"responseEnd":498.19999980926514,"responseStart":496,"secureConnectionStart":470.69999980926514},{"duration":338,"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":158.69999980926514,"connectEnd":483.19999980926514,"connectStart":463.9000005722046,"domainLookupEnd":463.9000005722046,"domainLookupStart":463.9000005722046,"fetchStart":158.69999980926514,"redirectEnd":0,"redirectStart":0,"requestStart":483.30000019073486,"responseEnd":496.69999980926514,"responseStart":495.1000003814697,"secureConnectionStart":473.30000019073486},{"duration":11.699999809265137,"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":158.80000019073486,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":158.80000019073486,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":170.5,"responseStart":0,"secureConnectionStart":0},{"duration":339.69999980926514,"initiatorType":"script","name":"https://community.i2b2.org/jira/rest/api/1.0/shortcuts/820011/a9e270f026ecabffc9a59343e5439391/shortcuts.js?context=issuenavigation&context=issueaction","startTime":159.10000038146973,"connectEnd":484.80000019073486,"connectStart":465.6000003814697,"domainLookupEnd":465.6000003814697,"domainLookupStart":465.5,"fetchStart":159.10000038146973,"redirectEnd":0,"redirectStart":0,"requestStart":484.80000019073486,"responseEnd":498.80000019073486,"responseStart":497.1000003814697,"secureConnectionStart":475},{"duration":54.69999980926514,"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":290.4000005722046,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":290.4000005722046,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":345.1000003814697,"responseStart":0,"secureConnectionStart":0},{"duration":439.69999980926514,"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":290.5,"connectEnd":714.6999998092651,"connectStart":692,"domainLookupEnd":692,"domainLookupStart":692,"fetchStart":290.5,"redirectEnd":0,"redirectStart":0,"requestStart":714.8000001907349,"responseEnd":730.1999998092651,"responseStart":728.8000001907349,"secureConnectionStart":703.1999998092651},{"duration":409.0999994277954,"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":319.4000005722046,"connectEnd":716.8000001907349,"connectStart":697.6999998092651,"domainLookupEnd":697.6999998092651,"domainLookupStart":697.6999998092651,"fetchStart":319.4000005722046,"redirectEnd":0,"redirectStart":0,"requestStart":716.9000005722046,"responseEnd":728.5,"responseStart":727.9000005722046,"secureConnectionStart":707.1000003814697},{"duration":331.1000003814697,"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":405.80000019073486,"connectEnd":725.1000003814697,"connectStart":705.6999998092651,"domainLookupEnd":705.6999998092651,"domainLookupStart":705.6000003814697,"fetchStart":405.80000019073486,"redirectEnd":0,"redirectStart":0,"requestStart":725.3000001907349,"responseEnd":736.9000005722046,"responseStart":736,"secureConnectionStart":715.1999998092651}],"fetchStart":0,"domainLookupStart":25,"domainLookupEnd":42,"connectStart":42,"connectEnd":73,"secureConnectionStart":51,"requestStart":73,"responseStart":149,"responseEnd":406,"domLoading":152,"domInteractive":908,"domContentLoadedEventStart":908,"domContentLoadedEventEnd":950,"domComplete":1591,"loadEventStart":1591,"loadEventEnd":1591,"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","marks":[{"name":"bigPipe.sidebar-id.start","time":882.8000001907349},{"name":"bigPipe.sidebar-id.end","time":883.6999998092651},{"name":"bigPipe.activity-panel-pipe-id.start","time":883.9000005722046},{"name":"bigPipe.activity-panel-pipe-id.end","time":887.8000001907349},{"name":"activityTabFullyLoaded","time":967.5}],"measures":[],"correlationId":"b42a99ee108464","effectiveType":"4g","downlink":9.2,"rtt":0,"serverDuration":318,"dbReadsTimeInMs":86,"dbConnsTimeInMs":113,"applicationHash":"0629dd8d260e3954ece49053e565d01dabe11609","experiments":[]}}