Details
Major 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.
An AgeAtVisitUpgrade.sql script was created that should run on sqlserver only.
Attachments
Activity
This script should run on SQLSERVER only. Postgres computes age differently and oracle does not have the bug.
| Field | Original Value | New Value |
|---|---|---|
| Attachment | AgeAtVisitUpdate.sql [ 10433 ] | |
| Component/s | Data [ 10050 ] | |
| Affects Version/s | 1.7.07 [ 10201 ] |
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
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
| Assignee | Janice Donahoe [ jmd86 ] | |
| Status | New [ 10000 ] | Open [ 1 ] |
| Affects Database/s | SQL Server [ 10189 ] | |
| Developer Notes | Affects SQLSERVER ontology metadata table i2b2 only. |
| Assignee | Janice Donahoe [ jmd86 ] | Lori Phillips [ lcp5 ] |
| Status | Open [ 1 ] | In Progress [ 3 ] |
| Assignee | Lori Phillips [ lcp5 ] | Janice Donahoe [ jmd86 ] |
| Status | In Progress [ 3 ] | Ready to Test [ 10001 ] |
| Status | Ready to Test [ 10001 ] | Testing [ 10002 ] |
| Fix Version/s | 1.7.08 [ 10204 ] |
| Resolution | Fixed [ 1 ] | |
| Status | Testing [ 10002 ] | Resolved [ 5 ] |
This change was included in version 1.7.08, which was released on 10/07/2016.
| Status | Resolved [ 5 ] | Closed [ 6 ] |