Here is the description from the ANT build script:
[sql] Failed to execute: /* add an index on most of the observation_fact fields */ CREATE INDEX OF_IDX_ALLObservation_Fact ON Observation_Fact ( Encounter_Num , Patient_Num , Concept_Cd , Start_Date , Provider_Id , Modifier_Cd , inst
ance_num, ValType_Cd , TVal_Char , NVal_Num , ValueFlag_Cd , Quantity_Num , Units_Cd , End_Date , Location_Cd , Confidence_Num , Sourcesystem_Cd ) [sql] com.microsoft.sqlserver.jdbc.SQLServerException: The index 'OF_IDX_A
LLObservation_Fact' on table 'Observation_Fact' has 17 column names in index key list. The maximum limit for index or statistics key column list is 16.
Mike Mendis
made changes -
27/Oct/11 1:21 PM
Field
Original Value
New Value
Fix Version/s
1.6
[ 10051
]
Resolution
Fixed
[ 1
]
Status
Open
[ 1
]
Resolved
[ 5
]
Janice Donahoe
made changes -
22/May/14 5:58 PM
Workflow
classic default workflow
[ 10155
]
i2b2 Issues
[ 10377
]
Janice Donahoe
made changes -
23/May/14 11:48 AM
Component/s
Data
[ 10024
]
Janice Donahoe
made changes -
23/May/14 11:48 AM
Status
Resolved
[ 5
]
Closed
[ 6
]
Janice Donahoe
made changes -
29/May/14 4:07 PM
Workflow
i2b2 Issues
[ 10377
]
i2b2 Issues Workflow
[ 10550
]
Janice Donahoe
made changes -
05/Jun/14 5:37 PM
Component/s
Data
[ 10050
]
Component/s
Data
[ 10024
]
Fix Version/s
1.6.00
[ 10141
]
Fix Version/s
1.6.00
[ 10051
]
Key
LEOPARD-73
CORE-44
Project
i2b2
[ 10000
]
i2b2 Core Project
[ 10034
]
Affects Version/s
1.6.00-RC2
[ 10137
]
Affects Version/s
1.6.00-RC2
[ 10032
]
{"report":{"fcp":746.1999999880791,"ttfb":253.09999999403954,"pageVisibility":"visible","entityId":10155,"key":"jira.project.issue.view-issue","isInitial":true,"threshold":1000,"elementTimings":{},"userDeviceMemory":8,"userDeviceProcessors":16,"apdex":1,"journeyId":"fd5558ef-68b0-43d7-8a1b-f4ff04c65024","navigationType":0,"readyForUser":813.4000000059605,"redirectCount":0,"resourceLoadedEnd":867.5999999940395,"resourceLoadedStart":259.30000001192093,"resourceTiming":[{"duration":5.799999982118607,"initiatorType":"link","name":"https://community.i2b2.org/jira/s/7fd763ecdf5ed1f47fc4d22fa8382e97-CDN/4x9nqn/820011/16zrvj4/49fa3aa3d35a2cc689cbf274e66cc41a/_/download/contextbatch/css/_super/batch.css","startTime":259.30000001192093,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":259.30000001192093,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":265.09999999403954,"responseStart":0,"secureConnectionStart":0},{"duration":6.0999999940395355,"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":259.59999999403954,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":259.59999999403954,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":265.69999998807907,"responseStart":0,"secureConnectionStart":0},{"duration":172.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":259.69999998807907,"connectEnd":322.19999998807907,"connectStart":298.40000000596046,"domainLookupEnd":259.69999998807907,"domainLookupStart":259.69999998807907,"fetchStart":259.69999998807907,"redirectEnd":0,"redirectStart":0,"requestStart":322.19999998807907,"responseEnd":432.19999998807907,"responseStart":340.40000000596046,"secureConnectionStart":310.19999998807907},{"duration":190.7999999821186,"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":259.80000001192093,"connectEnd":431.59999999403954,"connectStart":402.5,"domainLookupEnd":259.80000001192093,"domainLookupStart":259.80000001192093,"fetchStart":259.80000001192093,"redirectEnd":0,"redirectStart":0,"requestStart":432.59999999403954,"responseEnd":450.59999999403954,"responseStart":447.80000001192093,"secureConnectionStart":418.59999999403954},{"duration":269.09999999403954,"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":259.80000001192093,"connectEnd":416.19999998807907,"connectStart":380.80000001192093,"domainLookupEnd":259.80000001192093,"domainLookupStart":259.80000001192093,"fetchStart":259.80000001192093,"redirectEnd":0,"redirectStart":0,"requestStart":419.5,"responseEnd":528.9000000059605,"responseStart":437.40000000596046,"secureConnectionStart":392.80000001192093},{"duration":197.80000001192093,"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":260,"connectEnd":442.69999998807907,"connectStart":417.90000000596046,"domainLookupEnd":260,"domainLookupStart":260,"fetchStart":260,"redirectEnd":0,"redirectStart":0,"requestStart":442.69999998807907,"responseEnd":457.80000001192093,"responseStart":456.69999998807907,"secureConnectionStart":430.80000001192093},{"duration":230.40000000596046,"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":260,"connectEnd":475.09999999403954,"connectStart":450.40000000596046,"domainLookupEnd":260,"domainLookupStart":260,"fetchStart":260,"redirectEnd":0,"redirectStart":0,"requestStart":476,"responseEnd":490.40000000596046,"responseStart":489.5,"secureConnectionStart":462.69999998807907},{"duration":15.900000005960464,"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":260.09999999403954,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":260.09999999403954,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":276,"responseStart":0,"secureConnectionStart":0},{"duration":215.09999999403954,"initiatorType":"script","name":"https://community.i2b2.org/jira/rest/api/1.0/shortcuts/820011/5c69e534a30b62def7b98bda0f001346/shortcuts.js?context=issuenavigation&context=issueaction","startTime":260.30000001192093,"connectEnd":459.5,"connectStart":432.09999999403954,"domainLookupEnd":260.30000001192093,"domainLookupStart":260.30000001192093,"fetchStart":260.30000001192093,"redirectEnd":0,"redirectStart":0,"requestStart":459.5,"responseEnd":475.40000000596046,"responseStart":474.30000001192093,"secureConnectionStart":447.5},{"duration":10,"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":315.59999999403954,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":315.59999999403954,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":325.59999999403954,"responseStart":0,"secureConnectionStart":0},{"duration":280.39999997615814,"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":315.80000001192093,"connectEnd":560.3000000119209,"connectStart":536.5,"domainLookupEnd":315.80000001192093,"domainLookupStart":315.80000001192093,"fetchStart":315.80000001192093,"redirectEnd":0,"redirectStart":0,"requestStart":560.3000000119209,"responseEnd":596.1999999880791,"responseStart":575.1999999880791,"secureConnectionStart":548.4000000059605},{"duration":508.90000000596046,"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":329,"connectEnd":820.4000000059605,"connectStart":794.5999999940395,"domainLookupEnd":329,"domainLookupStart":329,"fetchStart":329,"redirectEnd":0,"redirectStart":0,"requestStart":821.1999999880791,"responseEnd":837.9000000059605,"responseStart":836.9000000059605,"secureConnectionStart":807.0999999940395},{"duration":457.7999999821186,"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":409.80000001192093,"connectEnd":849,"connectStart":820.6999999880791,"domainLookupEnd":409.80000001192093,"domainLookupStart":409.80000001192093,"fetchStart":409.80000001192093,"redirectEnd":0,"redirectStart":0,"requestStart":849.1999999880791,"responseEnd":867.5999999940395,"responseStart":865.9000000059605,"secureConnectionStart":834.5999999940395},{"duration":184.30000001192093,"initiatorType":"xmlhttprequest","name":"https://community.i2b2.org/jira/rest/webResources/1.0/resources","startTime":663,"connectEnd":819.5999999940395,"connectStart":790.5,"domainLookupEnd":663,"domainLookupStart":663,"fetchStart":663,"redirectEnd":0,"redirectStart":0,"requestStart":821,"responseEnd":847.3000000119209,"responseStart":841.5,"secureConnectionStart":805.6999999880791}],"fetchStart":0,"domainLookupStart":0,"domainLookupEnd":0,"connectStart":47,"connectEnd":223,"secureConnectionStart":196,"requestStart":223,"responseStart":253,"responseEnd":403,"domLoading":258,"domInteractive":913,"domContentLoadedEventStart":913,"domContentLoadedEventEnd":974,"domComplete":1243,"loadEventStart":1243,"loadEventEnd":1243,"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","marks":[{"name":"bigPipe.sidebar-id.start","time":878.1999999880791},{"name":"bigPipe.sidebar-id.end","time":879.4000000059605},{"name":"bigPipe.activity-panel-pipe-id.start","time":879.5},{"name":"bigPipe.activity-panel-pipe-id.end","time":882.5999999940395},{"name":"activityTabFullyLoaded","time":1001.5}],"measures":[],"correlationId":"7573f0998a68d3","effectiveType":"4g","downlink":9.4,"rtt":0,"serverDuration":164,"dbReadsTimeInMs":17,"dbConnsTimeInMs":26,"applicationHash":"0629dd8d260e3954ece49053e565d01dabe11609","experiments":[]}}
CREATE INDEX OF_IDX_ALLObservation_Fact ON Observation_Fact
(
Encounter_Num ,
Patient_Num ,
Concept_Cd ,
Start_Date ,
Provider_Id ,
Modifier_Cd ,
instance_num,
ValType_Cd ,
TVal_Char ,
NVal_Num ,
ValueFlag_Cd ,
Quantity_Num ,
Units_Cd ,
End_Date ,
Location_Cd ,
Confidence_Num ,
Sourcesystem_Cd
)
;