Type:
Improvement
Status:
Closed
Priority:
Major
Resolution:
Fixed
Affects Version/s:
None
Component/s:
None
Developer Notes:
fix has been made in several tables and some procedures .
Testing Notes:
Hide
TESTING STATUS: Completed (PassedTesting)
COMPLETION DATE: 12/29/2015
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
TEST DATE: 12/29/2015
TESTED BY: Janice Donahoe
BUILD NUMBER: 1.7.07.0008
TEST STATUS: Completed (Passed Testing)
CLIENTS TESTED:
Not applicable for this test.
ENVIRONMENTS TESTED:
Browsers: Not applicable for this test
Databases: SQL Server 2008, 2012, & 2014
Client OS: Not applicable for this test
TEST COMMENTS:
This was tested with the latest Web Client build (1.7.07.0008) and it appears to be working correctly. No issues were found while testing.
SCENARIOS TESTED
Verified the i2b2 demo data scripts for SQL Server ran correctly and the data was imported correctly. The scripts were run from Bamboo and verified the bamboo tests ran correctly.
ISSUES FOUND:
No issues were found during this test.
Show
TESTING STATUS: Completed (PassedTesting)
COMPLETION DATE: 12/29/2015
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
TEST DATE: 12/29/2015
TESTED BY: Janice Donahoe
BUILD NUMBER: 1.7.07.0008
TEST STATUS: Completed (Passed Testing)
CLIENTS TESTED:
Not applicable for this test.
ENVIRONMENTS TESTED:
Browsers: Not applicable for this test
Databases: SQL Server 2008, 2012, & 2014
Client OS: Not applicable for this test
TEST COMMENTS:
This was tested with the latest Web Client build (1.7.07.0008) and it appears to be working correctly. No issues were found while testing.
SCENARIOS TESTED
Verified the i2b2 demo data scripts for SQL Server ran correctly and the data was imported correctly. The scripts were run from Bamboo and verified the bamboo tests ran correctly.
ISSUES FOUND:
No issues were found during this test.
The installation scripts for the i2b2 demo data need to be updated to support Microsoft SQL Server 2012.
TEXT is no longer supported; change to VARCHAR(MAX)
Janice Donahoe
made changes -
18/Dec/15 12:24 PM
Field
Original Value
New Value
Assignee
Lori Phillips
[ lcp5
]
Status
New
[ 10000
]
Open
[ 1
]
Janice Donahoe
made changes -
18/Dec/15 12:24 PM
Fix Version/s
1.7.07
[ 10201
]
Lori Phillips
made changes -
18/Dec/15 1:41 PM
Status
Open
[ 1
]
In Progress
[ 3
]
Lori Phillips
made changes -
18/Dec/15 1:42 PM
Developer Notes
fix has been made in several tables and some procedures .
Status
In Progress
[ 3
]
Ready to Test
[ 10001
]
Janice Donahoe
made changes -
18/Dec/15 3:45 PM
Assignee
Lori Phillips
[ lcp5
]
Janice Donahoe
[ jmd86
]
Janice Donahoe
made changes -
18/Dec/15 3:45 PM
Status
Ready to Test
[ 10001
]
Testing
[ 10002
]
Janice Donahoe
made changes -
29/Dec/15 3:19 PM
Testing Notes
TESTING STATUS: Completed (PassedTesting)
COMPLETION DATE: 12/29/2015
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
TEST DATE: 12/29/2015
TESTED BY: Janice Donahoe
BUILD NUMBER: 1.7.07.0008
TEST STATUS: Completed (Passed Testing)
CLIENTS TESTED:
Not applicable for this test.
ENVIRONMENTS TESTED:
Browsers: Not applicable for this test
Databases: SQL Server 2008, 2012, & 2014
Client OS: Not applicable for this test
TEST COMMENTS:
This was tested with the latest Web Client build (1.7.07.0008) and it appears to be working correctly. No issues were found while testing.
SCENARIOS TESTED
Verified the i2b2 demo data scripts for SQL Server ran correctly and the data was imported correctly. The scripts were run from Bamboo and verified the bamboo tests ran correctly.
ISSUES FOUND:
No issues were found during this test.
Status
Testing
[ 10002
]
Testing
[ 10002
]
Janice Donahoe
made changes -
29/Dec/15 3:19 PM
Resolution
Fixed
[ 1
]
Status
Testing
[ 10002
]
Resolved
[ 5
]
Janice Donahoe
made changes -
25/Jan/16 11:19 AM
Status
Resolved
[ 5
]
Closed
[ 6
]
{"report":{"fcp":1069,"ttfb":337.19999980926514,"pageVisibility":"visible","entityId":10698,"key":"jira.project.issue.view-issue","isInitial":true,"threshold":1000,"elementTimings":{},"userDeviceMemory":8,"userDeviceProcessors":32,"apdex":0.5,"journeyId":"0c377e14-4dc7-4c8d-bce3-459eded1dda3","navigationType":0,"readyForUser":1145.6999998092651,"redirectCount":0,"resourceLoadedEnd":1267.3999996185303,"resourceLoadedStart":351,"resourceTiming":[{"duration":239.10000038146973,"initiatorType":"link","name":"https://community.i2b2.org/jira/s/7fd763ecdf5ed1f47fc4d22fa8382e97-CDN/4x9nqn/820011/16zrvj4/49fa3aa3d35a2cc689cbf274e66cc41a/_/download/contextbatch/css/_super/batch.css","startTime":351,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":351,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":590.1000003814697,"responseStart":0,"secureConnectionStart":0},{"duration":243.39999961853027,"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":351.30000019073486,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":351.30000019073486,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":594.6999998092651,"responseStart":0,"secureConnectionStart":0},{"duration":476.80000019073486,"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":351.5,"connectEnd":713.6000003814697,"connectStart":685.1999998092651,"domainLookupEnd":685.1999998092651,"domainLookupStart":685.1999998092651,"fetchStart":351.5,"redirectEnd":0,"redirectStart":0,"requestStart":714.8000001907349,"responseEnd":828.3000001907349,"responseStart":733.8999996185303,"secureConnectionStart":699.1000003814697},{"duration":475,"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":352,"connectEnd":736.3000001907349,"connectStart":715,"domainLookupEnd":715,"domainLookupStart":715,"fetchStart":352,"redirectEnd":0,"redirectStart":0,"requestStart":737.3999996185303,"responseEnd":827,"responseStart":752.5,"secureConnectionStart":726.1000003814697},{"duration":411.80000019073486,"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":352.19999980926514,"connectEnd":750.3000001907349,"connectStart":726.6999998092651,"domainLookupEnd":726.6999998092651,"domainLookupStart":726.6999998092651,"fetchStart":352.19999980926514,"redirectEnd":0,"redirectStart":0,"requestStart":750.3999996185303,"responseEnd":764,"responseStart":763.1999998092651,"secureConnectionStart":738.3000001907349},{"duration":405.70000076293945,"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":352.3999996185303,"connectEnd":745.1000003814697,"connectStart":725,"domainLookupEnd":725,"domainLookupStart":725,"fetchStart":352.3999996185303,"redirectEnd":0,"redirectStart":0,"requestStart":745.1999998092651,"responseEnd":758.1000003814697,"responseStart":756.8000001907349,"secureConnectionStart":735.1000003814697},{"duration":418.3999996185303,"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":352.5,"connectEnd":756.6999998092651,"connectStart":736.6000003814697,"domainLookupEnd":736.6000003814697,"domainLookupStart":736.6000003814697,"fetchStart":352.5,"redirectEnd":0,"redirectStart":0,"requestStart":758.3999996185303,"responseEnd":770.8999996185303,"responseStart":769.1999998092651,"secureConnectionStart":746.3000001907349},{"duration":247.60000038146973,"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":352.69999980926514,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":352.69999980926514,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":600.3000001907349,"responseStart":0,"secureConnectionStart":0},{"duration":449.80000019073486,"initiatorType":"script","name":"https://community.i2b2.org/jira/rest/api/1.0/shortcuts/820011/a9e270f026ecabffc9a59343e5439391/shortcuts.js?context=issuenavigation&context=issueaction","startTime":352.80000019073486,"connectEnd":781.8000001907349,"connectStart":757.8999996185303,"domainLookupEnd":757.8999996185303,"domainLookupStart":757.8999996185303,"fetchStart":352.80000019073486,"redirectEnd":0,"redirectStart":0,"requestStart":781.8999996185303,"responseEnd":802.6000003814697,"responseStart":800.8999996185303,"secureConnectionStart":769.8999996185303},{"duration":204.19999980926514,"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":461.5,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":461.5,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":665.6999998092651,"responseStart":0,"secureConnectionStart":0},{"duration":469.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":461.69999980926514,"connectEnd":914.3999996185303,"connectStart":894.5,"domainLookupEnd":894.5,"domainLookupStart":894.5,"fetchStart":461.69999980926514,"redirectEnd":0,"redirectStart":0,"requestStart":914.6000003814697,"responseEnd":931.3999996185303,"responseStart":927.5,"secureConnectionStart":904.5},{"duration":561,"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":485.5,"connectEnd":1032.1000003814697,"connectStart":1011.1000003814697,"domainLookupEnd":1011.1000003814697,"domainLookupStart":1011.1000003814697,"fetchStart":485.5,"redirectEnd":0,"redirectStart":0,"requestStart":1032.1999998092651,"responseEnd":1046.5,"responseStart":1044.6999998092651,"secureConnectionStart":1021.6999998092651},{"duration":706.8999996185303,"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":560.5,"connectEnd":1253.6000003814697,"connectStart":1229.3000001907349,"domainLookupEnd":1229.3000001907349,"domainLookupStart":1229.3000001907349,"fetchStart":560.5,"redirectEnd":0,"redirectStart":0,"requestStart":1253.6999998092651,"responseEnd":1267.3999996185303,"responseStart":1266.5,"secureConnectionStart":1241.1000003814697},{"duration":238.4000005722046,"initiatorType":"xmlhttprequest","name":"https://community.i2b2.org/jira/rest/webResources/1.0/resources","startTime":1006.8999996185303,"connectEnd":1230.8000001907349,"connectStart":1228.3999996185303,"domainLookupEnd":1228.3999996185303,"domainLookupStart":1228.3999996185303,"fetchStart":1006.8999996185303,"redirectEnd":0,"redirectStart":0,"requestStart":1230.8000001907349,"responseEnd":1245.3000001907349,"responseStart":1244.5,"secureConnectionStart":1228.3999996185303}],"fetchStart":0,"domainLookupStart":149,"domainLookupEnd":196,"connectStart":196,"connectEnd":239,"secureConnectionStart":210,"requestStart":239,"responseStart":337,"responseEnd":560,"domLoading":341,"domInteractive":1308,"domContentLoadedEventStart":1308,"domContentLoadedEventEnd":1352,"domComplete":1633,"loadEventStart":1633,"loadEventEnd":1634,"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","marks":[{"name":"bigPipe.sidebar-id.start","time":1269.1999998092651},{"name":"bigPipe.sidebar-id.end","time":1270.1000003814697},{"name":"bigPipe.activity-panel-pipe-id.start","time":1270.1999998092651},{"name":"bigPipe.activity-panel-pipe-id.end","time":1273.1999998092651},{"name":"activityTabFullyLoaded","time":1373.8000001907349}],"measures":[],"correlationId":"f964ccb0024bd9","effectiveType":"4g","downlink":9.8,"rtt":0,"serverDuration":305,"dbReadsTimeInMs":40,"dbConnsTimeInMs":58,"applicationHash":"0629dd8d260e3954ece49053e565d01dabe11609","experiments":[]}}
https://www.i2b2.org/software/
- zip files for release 1.7.07 are available on this site. This includes both the code and documentation.
https://github.com/i2b2
- source code has been tagged with v1.7.07.