After upgrading a previous 1.5.X installation to 1.6 , i2b2 would not work against them. It was found that the following tables were not created by the upgrade scripts:
modifier_dimension
MASTER_QUERY_GLOBAL_TEMP
in the i2b2demodata schema.
After creating thee by hand , the installation then worked.
G
{"report":{"fcp":624.1000000014901,"ttfb":68.30000000074506,"pageVisibility":"visible","entityId":10180,"key":"jira.project.issue.view-issue","isInitial":true,"threshold":1000,"elementTimings":{},"userDeviceMemory":8,"userDeviceProcessors":16,"apdex":1,"journeyId":"db2b725e-5897-490e-9e95-22f50c8b7bc9","navigationType":0,"readyForUser":716.6000000014901,"redirectCount":0,"resourceLoadedEnd":1004.3999999985099,"resourceLoadedStart":77,"resourceTiming":[{"duration":135.19999999925494,"initiatorType":"link","name":"https://community.i2b2.org/jira/s/7fd763ecdf5ed1f47fc4d22fa8382e97-CDN/4x9nqn/820011/16zrvj4/49fa3aa3d35a2cc689cbf274e66cc41a/_/download/contextbatch/css/_super/batch.css","startTime":77,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":77,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":212.19999999925494,"responseStart":0,"secureConnectionStart":0},{"duration":136.39999999850988,"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":77.60000000149012,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":77.60000000149012,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":214,"responseStart":0,"secureConnectionStart":0},{"duration":183.69999999925494,"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":77.80000000074506,"connectEnd":77.80000000074506,"connectStart":77.80000000074506,"domainLookupEnd":77.80000000074506,"domainLookupStart":77.80000000074506,"fetchStart":77.80000000074506,"redirectEnd":0,"redirectStart":0,"requestStart":77.80000000074506,"responseEnd":261.5,"responseStart":261.5,"secureConnectionStart":77.80000000074506},{"duration":196.69999999925494,"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":78.60000000149012,"connectEnd":78.60000000149012,"connectStart":78.60000000149012,"domainLookupEnd":78.60000000149012,"domainLookupStart":78.60000000149012,"fetchStart":78.60000000149012,"redirectEnd":0,"redirectStart":0,"requestStart":78.60000000149012,"responseEnd":275.30000000074506,"responseStart":275.30000000074506,"secureConnectionStart":78.60000000149012},{"duration":198.90000000223517,"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":78.69999999925494,"connectEnd":78.69999999925494,"connectStart":78.69999999925494,"domainLookupEnd":78.69999999925494,"domainLookupStart":78.69999999925494,"fetchStart":78.69999999925494,"redirectEnd":0,"redirectStart":0,"requestStart":78.69999999925494,"responseEnd":277.6000000014901,"responseStart":277.5,"secureConnectionStart":78.69999999925494},{"duration":199.30000000074506,"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":78.80000000074506,"connectEnd":78.80000000074506,"connectStart":78.80000000074506,"domainLookupEnd":78.80000000074506,"domainLookupStart":78.80000000074506,"fetchStart":78.80000000074506,"redirectEnd":0,"redirectStart":0,"requestStart":78.80000000074506,"responseEnd":278.1000000014901,"responseStart":278.1000000014901,"secureConnectionStart":78.80000000074506},{"duration":199.70000000298023,"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":78.89999999850988,"connectEnd":78.89999999850988,"connectStart":78.89999999850988,"domainLookupEnd":78.89999999850988,"domainLookupStart":78.89999999850988,"fetchStart":78.89999999850988,"redirectEnd":0,"redirectStart":0,"requestStart":78.89999999850988,"responseEnd":278.6000000014901,"responseStart":278.6000000014901,"secureConnectionStart":78.89999999850988},{"duration":201.59999999776483,"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":79.10000000149012,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":79.10000000149012,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":280.69999999925494,"responseStart":0,"secureConnectionStart":0},{"duration":200.5,"initiatorType":"script","name":"https://community.i2b2.org/jira/rest/api/1.0/shortcuts/820011/766848d8ff8ea3676a80e44dfb51696a/shortcuts.js?context=issuenavigation&context=issueaction","startTime":79.19999999925494,"connectEnd":79.19999999925494,"connectStart":79.19999999925494,"domainLookupEnd":79.19999999925494,"domainLookupStart":79.19999999925494,"fetchStart":79.19999999925494,"redirectEnd":0,"redirectStart":0,"requestStart":79.19999999925494,"responseEnd":279.69999999925494,"responseStart":279.69999999925494,"secureConnectionStart":79.19999999925494},{"duration":182.5,"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":99.39999999850988,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":99.39999999850988,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":281.8999999985099,"responseStart":0,"secureConnectionStart":0},{"duration":181.10000000149012,"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":99.5,"connectEnd":99.5,"connectStart":99.5,"domainLookupEnd":99.5,"domainLookupStart":99.5,"fetchStart":99.5,"redirectEnd":0,"redirectStart":0,"requestStart":99.5,"responseEnd":280.6000000014901,"responseStart":280.6000000014901,"secureConnectionStart":99.5},{"duration":411.80000000074506,"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":108.30000000074506,"connectEnd":108.30000000074506,"connectStart":108.30000000074506,"domainLookupEnd":108.30000000074506,"domainLookupStart":108.30000000074506,"fetchStart":108.30000000074506,"redirectEnd":0,"redirectStart":0,"requestStart":108.30000000074506,"responseEnd":520.1000000014901,"responseStart":520.1000000014901,"secureConnectionStart":108.30000000074506},{"duration":886.2999999970198,"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":118.10000000149012,"connectEnd":118.10000000149012,"connectStart":118.10000000149012,"domainLookupEnd":118.10000000149012,"domainLookupStart":118.10000000149012,"fetchStart":118.10000000149012,"redirectEnd":0,"redirectStart":0,"requestStart":118.10000000149012,"responseEnd":1004.3999999985099,"responseStart":1004.3999999985099,"secureConnectionStart":118.10000000149012},{"duration":480.5,"initiatorType":"xmlhttprequest","name":"https://community.i2b2.org/jira/rest/webResources/1.0/resources","startTime":525.1999999992549,"connectEnd":525.1999999992549,"connectStart":525.1999999992549,"domainLookupEnd":525.1999999992549,"domainLookupStart":525.1999999992549,"fetchStart":525.1999999992549,"redirectEnd":0,"redirectStart":0,"requestStart":525.1999999992549,"responseEnd":1005.6999999992549,"responseStart":1005.6999999992549,"secureConnectionStart":525.1999999992549}],"fetchStart":0,"domainLookupStart":0,"domainLookupEnd":0,"connectStart":0,"connectEnd":0,"requestStart":41,"responseStart":68,"responseEnd":118,"domLoading":72,"domInteractive":1056,"domContentLoadedEventStart":1056,"domContentLoadedEventEnd":1152,"domComplete":2121,"loadEventStart":2122,"loadEventEnd":2123,"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","marks":[{"name":"bigPipe.sidebar-id.start","time":1008.6000000014901},{"name":"bigPipe.sidebar-id.end","time":1009.3999999985099},{"name":"bigPipe.activity-panel-pipe-id.start","time":1009.6000000014901},{"name":"bigPipe.activity-panel-pipe-id.end","time":1011.8000000007451},{"name":"activityTabFullyLoaded","time":1169.8999999985099}],"measures":[],"correlationId":"2d2973dc21d5b8","effectiveType":"4g","downlink":9.2,"rtt":0,"serverDuration":62,"dbReadsTimeInMs":7,"dbConnsTimeInMs":8,"applicationHash":"0629dd8d260e3954ece49053e565d01dabe11609","experiments":[]}}
Major