Uploaded image for project: 'i2b2 Core Software'
  1. i2b2 Core Software
  2. CORE-59

Upgrade scripts are missing tables

Details

    • Task
    • Status: Closed
    • Major
    • Resolution: Fixed
    • 1.6.00
    • 1.6.03
    • Data, Install
    • None
    • Unix

    Description

      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

      Attachments

        Activity

          mem61 Mike Mendis added a comment -
          Agree that modifier_dimension should be there, but for oracle the MASTER_QUERY_GLOBAL_TEMP does have the scripts. If you are using sql server, than this will be created dynamically by the database.

          The modifier dim will be in the next release
          mem61 Mike Mendis added a comment - Agree that modifier_dimension should be there, but for oracle the MASTER_QUERY_GLOBAL_TEMP does have the scripts. If you are using sql server, than this will be created dynamically by the database. The modifier dim will be in the next release

          People

            mem61 Mike Mendis
            kowalskg George Kowalski
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: