i2b2 Sponsored Project/s:
Reproduction Notes:
Hide
It appears the problem is the CRC Design document that is available on the i2b2 web site is an older version. This issue is fixed in version 1.7.02 of this document. The INSTANCE_NUM column is not a nullable field as it is part of the primary key. This holds true for all supported databases (oracle, postgresql, and sqlserver).
Show
It appears the problem is the CRC Design document that is available on the i2b2 web site is an older version. This issue is fixed in version 1.7.02 of this document. The INSTANCE_NUM column is not a nullable field as it is part of the primary key. This holds true for all supported databases (oracle, postgresql, and sqlserver).
I have verified that the correct version of the CRC Design document is included in the i2b2core-doc-1705.zip file that can be downloaded from the i2b2 web site. The file can be found with the other i2b2 Source files.
This issue will address updating the CRC Design document that displays when selecting it from the list of documentation that appears when hovering over the Data Repository cell in the hive image.
The document Data Repository Cell [1] says on page 8 that the field INSTANCE_NUM may be null (NULLABLE = YES in table column). In fact, the column instance_num in the table observation_fact is not nullable.
I could only test this in an Oracle database so I can't tell if Postgres is also affected by this documentation gap.
[1]
https://www.i2b2.org/software/files/PDF/current/CRC_Design.pdf
made changes -
08/Jun/15 11:38 AM
Field
Original Value
New Value
Affects Database/s
Oracle
[ 10187
]
All databases
[ 10219
]
Fix Version/s
1.7.06
[ 10200
]
Reproduction Notes
It appears the problem is the CRC Design document that is available on the i2b2 web site is an older version. This issue is fixed in version 1.7.02 of this document. The INSTANCE_NUM column is not a nullable field as it is part of the primary key. This holds true for all supported databases (oracle, postgresql, and sqlserver).
Assignee
Janice Donahoe
[ jmd86
]
i2b2 Sponsored Project/s
i2b2 Web Client
[ 10197
]
Status
New
[ 10000
]
Open
[ 1
]
made changes -
10/Jun/15 8:51 AM
Status
Open
[ 1
]
In Progress
[ 3
]
made changes -
21/Jul/15 3:45 PM
Status
In Progress
[ 3
]
Ready to Test
[ 10001
]
made changes -
21/Jul/15 3:45 PM
Status
Ready to Test
[ 10001
]
Testing
[ 10002
]
made changes -
23/Jul/15 8:51 AM
Resolution
Fixed
[ 1
]
Status
Testing
[ 10002
]
Resolved
[ 5
]
made changes -
18/Aug/15 9:29 AM
Status
Resolved
[ 5
]
Closed
[ 6
]
{"report":{"fcp":726.1999998092651,"ttfb":95.39999961853027,"pageVisibility":"visible","entityId":10443,"key":"jira.project.issue.view-issue","isInitial":true,"threshold":1000,"elementTimings":{},"userDeviceMemory":8,"userDeviceProcessors":64,"apdex":1,"journeyId":"39a80ba7-4335-433c-8424-06a9b80e9724","navigationType":0,"readyForUser":779.5999994277954,"redirectCount":0,"resourceLoadedEnd":1165.3999996185303,"resourceLoadedStart":109.39999961853027,"resourceTiming":[{"duration":5.300000190734863,"initiatorType":"link","name":"https://community.i2b2.org/jira/s/7fd763ecdf5ed1f47fc4d22fa8382e97-CDN/4x9nqn/820011/16zrvj4/49fa3aa3d35a2cc689cbf274e66cc41a/_/download/contextbatch/css/_super/batch.css","startTime":109.39999961853027,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":109.39999961853027,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":114.69999980926514,"responseStart":0,"secureConnectionStart":0},{"duration":5.40000057220459,"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":109.79999923706055,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":109.79999923706055,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":115.19999980926514,"responseStart":0,"secureConnectionStart":0},{"duration":264.5,"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":110,"connectEnd":140,"connectStart":117.39999961853027,"domainLookupEnd":117.39999961853027,"domainLookupStart":117.39999961853027,"fetchStart":110,"redirectEnd":0,"redirectStart":0,"requestStart":141.79999923706055,"responseEnd":374.5,"responseStart":165.39999961853027,"secureConnectionStart":127.09999942779541},{"duration":202.19999980926514,"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":110.5,"connectEnd":140.0999994277954,"connectStart":118.19999980926514,"domainLookupEnd":118.19999980926514,"domainLookupStart":118.19999980926514,"fetchStart":110.5,"redirectEnd":0,"redirectStart":0,"requestStart":143,"responseEnd":312.69999980926514,"responseStart":161.89999961853027,"secureConnectionStart":127.79999923706055},{"duration":69.60000038146973,"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":110.79999923706055,"connectEnd":167.5,"connectStart":147.89999961853027,"domainLookupEnd":147.89999961853027,"domainLookupStart":147.89999961853027,"fetchStart":110.79999923706055,"redirectEnd":0,"redirectStart":0,"requestStart":167.5999994277954,"responseEnd":180.39999961853027,"responseStart":179.5,"secureConnectionStart":157.5999994277954},{"duration":106.5,"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":110.89999961853027,"connectEnd":200,"connectStart":180.19999980926514,"domainLookupEnd":180.19999980926514,"domainLookupStart":180.19999980926514,"fetchStart":110.89999961853027,"redirectEnd":0,"redirectStart":0,"requestStart":200.0999994277954,"responseEnd":217.39999961853027,"responseStart":216.0999994277954,"secureConnectionStart":189.79999923706055},{"duration":143.19999980926514,"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":111.19999980926514,"connectEnd":240.0999994277954,"connectStart":217.19999980926514,"domainLookupEnd":217.19999980926514,"domainLookupStart":217.19999980926514,"fetchStart":111.19999980926514,"redirectEnd":0,"redirectStart":0,"requestStart":240.19999980926514,"responseEnd":254.39999961853027,"responseStart":253.5999994277954,"secureConnectionStart":228.5},{"duration":10.200000762939453,"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":111.29999923706055,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":111.29999923706055,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":121.5,"responseStart":0,"secureConnectionStart":0},{"duration":175,"initiatorType":"script","name":"https://community.i2b2.org/jira/rest/api/1.0/shortcuts/820011/a9e270f026ecabffc9a59343e5439391/shortcuts.js?context=issuenavigation&context=issueaction","startTime":111.5,"connectEnd":273.79999923706055,"connectStart":254.39999961853027,"domainLookupEnd":254.39999961853027,"domainLookupStart":254.39999961853027,"fetchStart":111.5,"redirectEnd":0,"redirectStart":0,"requestStart":273.79999923706055,"responseEnd":286.5,"responseStart":285.5999994277954,"secureConnectionStart":263.69999980926514},{"duration":53.89999961853027,"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":259.5,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":259.5,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":313.3999996185303,"responseStart":0,"secureConnectionStart":0},{"duration":422.30000019073486,"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":259.5999994277954,"connectEnd":669.0999994277954,"connectStart":649.6999998092651,"domainLookupEnd":649.6999998092651,"domainLookupStart":649.6999998092651,"fetchStart":259.5999994277954,"redirectEnd":0,"redirectStart":0,"requestStart":669.2999992370605,"responseEnd":681.8999996185303,"responseStart":681,"secureConnectionStart":659.3999996185303},{"duration":417.1000003814697,"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":298.5999994277954,"connectEnd":701.3999996185303,"connectStart":678.3999996185303,"domainLookupEnd":678.3999996185303,"domainLookupStart":678.3999996185303,"fetchStart":298.5999994277954,"redirectEnd":0,"redirectStart":0,"requestStart":701.5,"responseEnd":715.6999998092651,"responseStart":715,"secureConnectionStart":689.5999994277954},{"duration":784.1999998092651,"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":381.19999980926514,"connectEnd":1151.5999994277954,"connectStart":1128.6999998092651,"domainLookupEnd":1128.6999998092651,"domainLookupStart":1128.6999998092651,"fetchStart":381.19999980926514,"redirectEnd":0,"redirectStart":0,"requestStart":1151.7999992370605,"responseEnd":1165.3999996185303,"responseStart":1164.6999998092651,"secureConnectionStart":1140},{"duration":211.19999980926514,"initiatorType":"xmlhttprequest","name":"https://community.i2b2.org/jira/rest/webResources/1.0/resources","startTime":552.0999994277954,"connectEnd":743.0999994277954,"connectStart":731.5,"domainLookupEnd":731.5,"domainLookupStart":731.5,"fetchStart":552.0999994277954,"redirectEnd":0,"redirectStart":0,"requestStart":743.3999996185303,"responseEnd":763.2999992370605,"responseStart":762.5999994277954,"secureConnectionStart":733.0999994277954}],"fetchStart":0,"domainLookupStart":5,"domainLookupEnd":18,"connectStart":18,"connectEnd":54,"secureConnectionStart":29,"requestStart":54,"responseStart":95,"responseEnd":380,"domLoading":98,"domInteractive":1189,"domContentLoadedEventStart":1189,"domContentLoadedEventEnd":1227,"domComplete":1489,"loadEventStart":1489,"loadEventEnd":1489,"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","marks":[{"name":"bigPipe.sidebar-id.start","time":1167.6999998092651},{"name":"bigPipe.sidebar-id.end","time":1168.5},{"name":"bigPipe.activity-panel-pipe-id.start","time":1168.5999994277954},{"name":"bigPipe.activity-panel-pipe-id.end","time":1171.3999996185303},{"name":"activityTabFullyLoaded","time":1243}],"measures":[],"correlationId":"65acbe61820f33","effectiveType":"4g","downlink":9,"rtt":0,"serverDuration":310,"dbReadsTimeInMs":54,"dbConnsTimeInMs":76,"applicationHash":"0629dd8d260e3954ece49053e565d01dabe11609","experiments":[]}}
Documentation
Trivial