Details
Minor Description
The table qt_privilege in the crc schema doesn’t have primary key. However, in the document, it’s asserted that the ‘PROTECTION_LABEL_CD’ is the primary key. It’s a little error, but it could give some hard times (when the ant command is used too many time, duplicate appears, and error pops up in the webclient). Not a big issue, but worth being noted
Attachments
Activity
| Field | Original Value | New Value |
|---|---|---|
| Component/s | Data [ 10050 ] | |
| Fix Version/s | 1.7.08 [ 10204 ] | |
| Affects Version/s | 1.7.07 [ 10201 ] | |
| Assignee | Janice Donahoe [ jmd86 ] | |
| i2b2 Sponsored Project/s | i2b2 Core [ 10196 ] | |
| Status | New [ 10000 ] | Open [ 1 ] |
| Status | Open [ 1 ] | In Progress [ 3 ] |
| Developer Notes | This was fixed for both PostgreSQL and SQL Server scripts. The oracle script already had the PROTECTION_LABEL_CD defined as the primary key. | |
| Status | In Progress [ 3 ] | In Progress [ 3 ] |
| Status | In Progress [ 3 ] | Ready to Test [ 10001 ] |
| Status | Ready to Test [ 10001 ] | Testing [ 10002 ] |
| Testing Notes |
Verified via Bamboo that the following scripts ran without errors and the primary key was set correctly.
crc_create_query_oracle.sql crc_create_query_postgresql.sql crc_create_query_sqlserver.sql |
|
| Status | Testing [ 10002 ] | Testing [ 10002 ] |
PROTECTION_LABEL_CD is now the primary key for the QT_PRIVILEGE table.
| Resolution | Fixed [ 1 ] | |
| Status | Testing [ 10002 ] | Resolved [ 5 ] |
| Assignee | Janice Donahoe [ jmd86 ] | Mike Mendis [ mem61 ] |
| Assignee | Mike Mendis [ mem61 ] | Janice Donahoe [ jmd86 ] |
This change was included in version 1.7.08, which was released on 10/07/2016.
| Status | Resolved [ 5 ] | Closed [ 6 ] |