[CORE-220] SqlServer Age at Visit incorrect for 24, 80, 81 and 89 Created: 10/Aug/16 Updated: 17/Oct/16 Resolved: 21/Sep/16 |
|
Status: | Closed |
Project: | i2b2 Core Software |
Component/s: | Data |
Affects Version/s: | 1.7.07 |
Fix Version/s: | 1.7.08 |
Type: | Bug | Priority: | Major |
Reporter: | Lori Phillips | Assignee: | Janice Donahoe |
Resolution: | Fixed | Votes: | 0 |
Labels: | None | ||
Remaining Estimate: | Not Specified | ||
Time Spent: | Not Specified | ||
Original Estimate: | Not Specified |
Attachments: |
![]() |
Affects Database/s: |
SQL Server
|
Developer Notes: | Affects SQLSERVER ontology metadata table i2b2 only. |
Participant/s: |
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. |
Comments |
Comment by Lori Phillips [ 10/Aug/16 ] |
This script should run on SQLSERVER only. Postgres computes age differently and oracle does not have the bug. |
Comment by Lori Phillips [ 10/Aug/16 ] |
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 |
Comment by Janice Donahoe [ 17/Oct/16 ] |
This change was included in version 1.7.08, which was released on 10/07/2016. |