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

SqlServer Age at Visit incorrect for 24, 80, 81 and 89

Details

    • Bug
    • Status: Closed
    • Major
    • Resolution: Fixed
    • 1.7.07
    • 1.7.08
    • Data
    • None
    • SQL Server
    • Affects SQLSERVER ontology metadata table i2b2 only.

    Description

      The c_dimcode field for Age at visit is incorrect for ages 24, 80, 81 and 89.
      An AgeAtVisitUpgrade.sql script was created that should run on sqlserver only.

      Attachments

        Activity

          Ascending order - Click to sort in descending order
          lcp5 Lori Phillips added a comment -
          This script should run on SQLSERVER only. Postgres computes age differently and oracle does not have the bug.
          lcp5 Lori Phillips added a comment - This script should run on SQLSERVER only. Postgres computes age differently and oracle does not have the bug.
          lcp5 Lori Phillips added a comment -
          on new installs no new data install path is needed

          However release notes need to mention a new data upgrade path for SQLSERVER only.

          ant –f data_build.xml upgrade_sqlserver_metadata_tables_release_1-7_08



          lcp5 Lori Phillips added a comment - on new installs no new data install path is needed However release notes need to mention a new data upgrade path for SQLSERVER only. ant –f data_build.xml upgrade_sqlserver_metadata_tables_release_1-7_08
          jmd86 Janice Donahoe added a comment -
          This change was included in version 1.7.08, which was released on 10/07/2016.
          jmd86 Janice Donahoe added a comment - This change was included in version 1.7.08, which was released on 10/07/2016.

          People

            jmd86 Janice Donahoe
            lcp5 Lori Phillips
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: