Type:
Bug
Status:
Closed
Priority:
Major
Resolution:
Fixed
Affects Version/s:
None
Component/s:
None
i2b2 Sponsored Project/s:
Developer Notes:
Hide
This was commited along with a much larger commit for OMOP processing (
CORE-240 ) ... You may want to test them at same time
Show
This was commited along with a much larger commit for OMOP processing ( CORE-240 ) ... You may want to test them at same time
The sql that is built when a db is postgres is invalid.
The reason for this is that the sql is built in two parts: The first part combines postgres with oracle workflow;' the second combines postgres with sqlserver flow. The result is a query that is half oracle; half sqlserver.
The solution is to default postgres sql construction to the oracle flow.
Lori Phillips
made changes -
09/Nov/16 11:05 AM
Field
Original Value
New Value
Assignee
Lori Phillips
[ lcp5
]
Lori Phillips
made changes -
09/Nov/16 11:07 AM
Affects Database/s
PostgreSQL
[ 10188
]
Affects View/s
Timeline View
[ 10053
]
i2b2 Sponsored Project/s
i2b2 Core
[ 10196
]
Janice Donahoe
made changes -
09/Nov/16 11:10 AM
Status
New
[ 10000
]
Open
[ 1
]
Lori Phillips
made changes -
09/Nov/16 11:13 AM
Status
Open
[ 1
]
In Progress
[ 3
]
Lori Phillips
made changes -
16/Nov/16 3:07 PM
Developer Notes
This was commited along with a much larger commit for OMOP processing (CORE-240 ) ... You may want to test them at same time
Status
In Progress
[ 3
]
Ready to Test
[ 10001
]
Lori Phillips
made changes -
16/Nov/16 3:07 PM
Assignee
Lori Phillips
[ lcp5
]
Janice Donahoe
[ jmd86
]
Janice Donahoe
made changes -
08/Mar/17 2:58 PM
Fix Version/s
1.7.09
[ 10306
]
Janice Donahoe
made changes -
10/May/17 10:31 AM
Status
Ready to Test
[ 10001
]
Testing
[ 10002
]
Janice Donahoe
made changes -
15/Jun/17 3:55 PM
Resolution
Fixed
[ 1
]
Status
Testing
[ 10002
]
Resolved
[ 5
]
Janice Donahoe
made changes -
29/Jun/17 9:15 AM
Status
Resolved
[ 5
]
Closed
[ 6
]
{"report":{"fcp":1038.5,"ttfb":252,"pageVisibility":"visible","entityId":11060,"key":"jira.project.issue.view-issue","isInitial":true,"threshold":1000,"elementTimings":{},"userDeviceMemory":8,"userDeviceProcessors":64,"apdex":0.5,"journeyId":"fab350f3-6391-46ff-ac69-ae077ccdd95f","navigationType":0,"readyForUser":1087.3000001907349,"redirectCount":0,"resourceLoadedEnd":1042.9000005722046,"resourceLoadedStart":262.1000003814697,"resourceTiming":[{"duration":355.5,"initiatorType":"link","name":"https://community.i2b2.org/jira/s/7fd763ecdf5ed1f47fc4d22fa8382e97-CDN/4x9nqn/820011/16zrvj4/49fa3aa3d35a2cc689cbf274e66cc41a/_/download/contextbatch/css/_super/batch.css","startTime":262.1000003814697,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":262.1000003814697,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":617.6000003814697,"responseStart":0,"secureConnectionStart":0},{"duration":355.79999923706055,"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":262.4000005722046,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":262.4000005722046,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":618.1999998092651,"responseStart":0,"secureConnectionStart":0},{"duration":506.0999994277954,"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":262.6000003814697,"connectEnd":684.1999998092651,"connectStart":657.6999998092651,"domainLookupEnd":657.6999998092651,"domainLookupStart":657.6999998092651,"fetchStart":262.6000003814697,"redirectEnd":0,"redirectStart":0,"requestStart":684.3000001907349,"responseEnd":768.6999998092651,"responseStart":702.9000005722046,"secureConnectionStart":670.8000001907349},{"duration":524.8999996185303,"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":263.1000003814697,"connectEnd":677.1999998092651,"connectStart":653.9000005722046,"domainLookupEnd":653.9000005722046,"domainLookupStart":653.9000005722046,"fetchStart":263.1000003814697,"redirectEnd":0,"redirectStart":0,"requestStart":677.1999998092651,"responseEnd":788,"responseStart":700.6000003814697,"secureConnectionStart":665.1999998092651},{"duration":432,"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":263.30000019073486,"connectEnd":678.1999998092651,"connectStart":655.1999998092651,"domainLookupEnd":655.1999998092651,"domainLookupStart":655.1000003814697,"fetchStart":263.30000019073486,"redirectEnd":0,"redirectStart":0,"requestStart":678.3000001907349,"responseEnd":695.3000001907349,"responseStart":694.5,"secureConnectionStart":666.5},{"duration":436.80000019073486,"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":263.5,"connectEnd":685.1999998092651,"connectStart":659.8000001907349,"domainLookupEnd":659.8000001907349,"domainLookupStart":659.8000001907349,"fetchStart":263.5,"redirectEnd":0,"redirectStart":0,"requestStart":685.3000001907349,"responseEnd":700.3000001907349,"responseStart":699.6000003814697,"secureConnectionStart":672.3000001907349},{"duration":470.20000076293945,"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":263.69999980926514,"connectEnd":716.1000003814697,"connectStart":695.1999998092651,"domainLookupEnd":695.1999998092651,"domainLookupStart":695.1999998092651,"fetchStart":263.69999980926514,"redirectEnd":0,"redirectStart":0,"requestStart":717.8000001907349,"responseEnd":733.9000005722046,"responseStart":730.9000005722046,"secureConnectionStart":705.5},{"duration":358.80000019073486,"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":263.80000019073486,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":263.80000019073486,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":622.6000003814697,"responseStart":0,"secureConnectionStart":0},{"duration":474.69999980926514,"initiatorType":"script","name":"https://community.i2b2.org/jira/rest/api/1.0/shortcuts/820011/a9e270f026ecabffc9a59343e5439391/shortcuts.js?context=issuenavigation&context=issueaction","startTime":264,"connectEnd":724.1000003814697,"connectStart":700.1999998092651,"domainLookupEnd":700.1999998092651,"domainLookupStart":700.1999998092651,"fetchStart":264,"redirectEnd":0,"redirectStart":0,"requestStart":724.1000003814697,"responseEnd":738.6999998092651,"responseStart":737.8000001907349,"secureConnectionStart":712.1999998092651},{"duration":329,"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":398.9000005722046,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":398.9000005722046,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":727.9000005722046,"responseStart":0,"secureConnectionStart":0},{"duration":594.1999998092651,"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":399.1000003814697,"connectEnd":974.9000005722046,"connectStart":949.1999998092651,"domainLookupEnd":949.1999998092651,"domainLookupStart":949.1999998092651,"fetchStart":399.1000003814697,"redirectEnd":0,"redirectStart":0,"requestStart":975,"responseEnd":993.3000001907349,"responseStart":990.1000003814697,"secureConnectionStart":961.6999998092651},{"duration":576,"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":418.69999980926514,"connectEnd":980.6999998092651,"connectStart":957.6999998092651,"domainLookupEnd":957.6999998092651,"domainLookupStart":957.6999998092651,"fetchStart":418.69999980926514,"redirectEnd":0,"redirectStart":0,"requestStart":980.6999998092651,"responseEnd":994.6999998092651,"responseStart":993.6999998092651,"secureConnectionStart":968.9000005722046},{"duration":596.5,"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":446.4000005722046,"connectEnd":1030.3000001907349,"connectStart":1009.1999998092651,"domainLookupEnd":1009.1999998092651,"domainLookupStart":1009.1999998092651,"fetchStart":446.4000005722046,"redirectEnd":0,"redirectStart":0,"requestStart":1030.6999998092651,"responseEnd":1042.9000005722046,"responseStart":1041.9000005722046,"secureConnectionStart":1019.1999998092651},{"duration":146.5999994277954,"initiatorType":"xmlhttprequest","name":"https://community.i2b2.org/jira/rest/webResources/1.0/resources","startTime":944.4000005722046,"connectEnd":1074.5,"connectStart":1061.4000005722046,"domainLookupEnd":1061.4000005722046,"domainLookupStart":1061.4000005722046,"fetchStart":944.4000005722046,"redirectEnd":0,"redirectStart":0,"requestStart":1074.5,"responseEnd":1091,"responseStart":1090.1999998092651,"secureConnectionStart":1062.8000001907349}],"fetchStart":0,"domainLookupStart":123,"domainLookupEnd":146,"connectStart":146,"connectEnd":189,"secureConnectionStart":159,"requestStart":189,"responseStart":252,"responseEnd":446,"domLoading":255,"domInteractive":1160,"domContentLoadedEventStart":1160,"domContentLoadedEventEnd":1196,"domComplete":1468,"loadEventStart":1468,"loadEventEnd":1468,"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","marks":[{"name":"bigPipe.sidebar-id.start","time":1140.1000003814697},{"name":"bigPipe.sidebar-id.end","time":1140.6999998092651},{"name":"bigPipe.activity-panel-pipe-id.start","time":1140.8000001907349},{"name":"bigPipe.activity-panel-pipe-id.end","time":1143.6000003814697},{"name":"activityTabFullyLoaded","time":1215.4000005722046}],"measures":[],"correlationId":"293ca98a1079e8","effectiveType":"4g","downlink":9.5,"rtt":0,"serverDuration":234,"dbReadsTimeInMs":60,"dbConnsTimeInMs":81,"applicationHash":"0629dd8d260e3954ece49053e565d01dabe11609","experiments":[]}}