Type:
Status:
Closed
Priority:
Resolution:
Fixed
Affects Version/s:
None
i2b2 Sponsored Project/s:
Developer Notes:
Hide
The reported problem is with the oracle script in that it is not allowing CONCEPT_DIMENSION.CONCEPT_CD to be null. The oracle script (crc_create_datamart_oracle.sql) has been updated to allow nulls.
Show
The reported problem is with the oracle script in that it is not allowing CONCEPT_DIMENSION.CONCEPT_CD to be null. The oracle script (crc_create_datamart_oracle.sql) has been updated to allow nulls.
Testing Notes:
Hide
Tested via Bamboo on 04/15/2015
Show
Tested via Bamboo on 04/15/2015
Status: Passed
Project: i2b2 Server
Plan: i2b2 Install Linux Oracle 11g
Build: #831
Revisions: Data 5327
I only checked Oracle and PostgreSQL, but the Oracle DDL requires concept_cd to be NOT NULL, while PostgreSQL allows it to be NULL.
{"report":{"fcp":961.8999999999069,"ttfb":315.79999999981374,"pageVisibility":"visible","entityId":10415,"key":"jira.project.issue.view-issue","isInitial":true,"threshold":1000,"elementTimings":{},"userDeviceMemory":8,"userDeviceProcessors":16,"apdex":0.5,"journeyId":"a0e53f8c-1a2c-4b8d-9648-84ed3f22748c","navigationType":0,"readyForUser":1013.7999999998137,"redirectCount":0,"resourceLoadedEnd":928.8999999999069,"resourceLoadedStart":330.60000000009313,"resourceTiming":[{"duration":76.5,"initiatorType":"link","name":"https://community.i2b2.org/jira/s/7fd763ecdf5ed1f47fc4d22fa8382e97-CDN/4x9nqn/820011/16zrvj4/49fa3aa3d35a2cc689cbf274e66cc41a/_/download/contextbatch/css/_super/batch.css","startTime":330.60000000009313,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":330.60000000009313,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":407.10000000009313,"responseStart":0,"secureConnectionStart":0},{"duration":77.20000000018626,"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":330.89999999990687,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":330.89999999990687,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":408.10000000009313,"responseStart":0,"secureConnectionStart":0},{"duration":321.79999999981374,"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":331,"connectEnd":523.6000000000931,"connectStart":496.60000000009313,"domainLookupEnd":331,"domainLookupStart":331,"fetchStart":331,"redirectEnd":0,"redirectStart":0,"requestStart":523.6000000000931,"responseEnd":652.7999999998137,"responseStart":544.5,"secureConnectionStart":510.60000000009313},{"duration":340.89999999990687,"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":331.29999999981374,"connectEnd":541.3999999999069,"connectStart":513.7999999998137,"domainLookupEnd":331.29999999981374,"domainLookupStart":331.29999999981374,"fetchStart":331.29999999981374,"redirectEnd":0,"redirectStart":0,"requestStart":541.5,"responseEnd":672.1999999997206,"responseStart":572,"secureConnectionStart":527.7999999998137},{"duration":274.5,"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":331.5,"connectEnd":587.6000000000931,"connectStart":553.5,"domainLookupEnd":331.5,"domainLookupStart":331.5,"fetchStart":331.5,"redirectEnd":0,"redirectStart":0,"requestStart":588,"responseEnd":606,"responseStart":604.2999999998137,"secureConnectionStart":573.8999999999069},{"duration":272,"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":331.6999999997206,"connectEnd":587.1999999997206,"connectStart":558.7999999998137,"domainLookupEnd":331.6999999997206,"domainLookupStart":331.6999999997206,"fetchStart":331.6999999997206,"redirectEnd":0,"redirectStart":0,"requestStart":587.6000000000931,"responseEnd":603.6999999997206,"responseStart":602.7999999998137,"secureConnectionStart":574.1999999997206},{"duration":281.20000000018626,"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":331.6999999997206,"connectEnd":594.6000000000931,"connectStart":566.6999999997206,"domainLookupEnd":331.6999999997206,"domainLookupStart":331.6999999997206,"fetchStart":331.6999999997206,"redirectEnd":0,"redirectStart":0,"requestStart":594.7999999998137,"responseEnd":612.8999999999069,"responseStart":609.6999999997206,"secureConnectionStart":581.2999999998137},{"duration":81.20000000018626,"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":331.89999999990687,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":331.89999999990687,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":413.10000000009313,"responseStart":0,"secureConnectionStart":0},{"duration":283.60000000009313,"initiatorType":"script","name":"https://community.i2b2.org/jira/rest/api/1.0/shortcuts/820011/766848d8ff8ea3676a80e44dfb51696a/shortcuts.js?context=issuenavigation&context=issueaction","startTime":332,"connectEnd":594.7999999998137,"connectStart":567.6000000000931,"domainLookupEnd":332,"domainLookupStart":332,"fetchStart":332,"redirectEnd":0,"redirectStart":0,"requestStart":594.8999999999069,"responseEnd":615.6000000000931,"responseStart":613.6999999997206,"secureConnectionStart":581.7999999998137},{"duration":53.89999999990687,"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":369.29999999981374,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":369.29999999981374,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":423.1999999997206,"responseStart":0,"secureConnectionStart":0},{"duration":347.60000000009313,"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":369.5,"connectEnd":700,"connectStart":672.1999999997206,"domainLookupEnd":369.5,"domainLookupStart":369.5,"fetchStart":369.5,"redirectEnd":0,"redirectStart":0,"requestStart":700.2999999998137,"responseEnd":717.1000000000931,"responseStart":716.1000000000931,"secureConnectionStart":686.7999999998137},{"duration":526.8000000002794,"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":398.1999999997206,"connectEnd":905,"connectStart":870.1999999997206,"domainLookupEnd":398.1999999997206,"domainLookupStart":398.1999999997206,"fetchStart":398.1999999997206,"redirectEnd":0,"redirectStart":0,"requestStart":907.5,"responseEnd":925,"responseStart":922.8999999999069,"secureConnectionStart":885},{"duration":522.3999999999069,"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":406.5,"connectEnd":910.6999999997206,"connectStart":876.2999999998137,"domainLookupEnd":406.5,"domainLookupStart":406.5,"fetchStart":406.5,"redirectEnd":0,"redirectStart":0,"requestStart":910.7999999998137,"responseEnd":928.8999999999069,"responseStart":926.6999999997206,"secureConnectionStart":896.3999999999069},{"duration":129.5,"initiatorType":"xmlhttprequest","name":"https://community.i2b2.org/jira/rest/webResources/1.0/resources","startTime":877.3999999999069,"connectEnd":988.6999999997206,"connectStart":960.5,"domainLookupEnd":877.3999999999069,"domainLookupStart":877.3999999999069,"fetchStart":877.3999999999069,"redirectEnd":0,"redirectStart":0,"requestStart":988.7999999998137,"responseEnd":1006.8999999999069,"responseStart":1005.8999999999069,"secureConnectionStart":974.6000000000931}],"fetchStart":0,"domainLookupStart":0,"domainLookupEnd":0,"connectStart":31,"connectEnd":272,"secureConnectionStart":244,"requestStart":272,"responseStart":316,"responseEnd":406,"domLoading":325,"domInteractive":1120,"domContentLoadedEventStart":1121,"domContentLoadedEventEnd":1176,"domComplete":1758,"loadEventStart":1758,"loadEventEnd":1759,"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","marks":[{"name":"bigPipe.sidebar-id.start","time":1085.6999999997206},{"name":"bigPipe.sidebar-id.end","time":1086.5},{"name":"bigPipe.activity-panel-pipe-id.start","time":1086.6999999997206},{"name":"bigPipe.activity-panel-pipe-id.end","time":1087.3999999999069},{"name":"activityTabFullyLoaded","time":1189.2999999998137}],"measures":[],"correlationId":"d7eb6a00768582","effectiveType":"4g","downlink":10,"rtt":0,"serverDuration":118,"dbReadsTimeInMs":18,"dbConnsTimeInMs":22,"applicationHash":"0629dd8d260e3954ece49053e565d01dabe11609","experiments":[]}}
Major