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

Increase number of queries that can be run in the "lifetime" of the database

Details

    • Improvement
    • Status: Closed
    • Major
    • Resolution: Fixed
    • 1.7.01
    • 1.7.07
    • Data
    • None
    • Queries
    • i2b2 Core
    • All databases
    • All Web Browsers

    Description

      When a query is run it receives a master id and each result instance of that query receives its own id. Currently, the columns that store these id's is limited to 5 digits so the maximum number of queries that can be run are 99,999.

      This limit needs to be increased in order to support those sites that are exceeding this limit.

      Attachments

        Activity

          Ascending order - Click to sort in descending order
          jmd86 Janice Donahoe created issue -
          jmd86 Janice Donahoe made changes -
          Field Original Value New Value
          Fix Version/s 1.7.03 [ 10156 ]
          i2b2 Sponsored Project/s i2b2 Core [ 10196 ]
          Status New [ 10000 ] Open [ 1 ]
          jmd86 Janice Donahoe made changes -
          Assignee Mike Mendis [ mem61 ]
          jmd86 Janice Donahoe made changes -
          Assignee Mike Mendis [ mem61 ] Janice Donahoe [ jmd86 ]
          jmd86 Janice Donahoe made changes -
          Fix Version/s 1.7.04 [ 10160 ]
          Fix Version/s 1.7.03 [ 10156 ]
          jmd86 Janice Donahoe made changes -
          Assignee Janice Donahoe [ jmd86 ] Mike Mendis [ mem61 ]
          jmd86 Janice Donahoe added a comment -
          Mike, has this been fixed?
          jmd86 Janice Donahoe added a comment - Mike, has this been fixed?
          jmd86 Janice Donahoe made changes -
          Fix Version/s 1.7.05 [ 10164 ]
          Fix Version/s 1.7.04 [ 10160 ]
          jmd86 Janice Donahoe made changes -
          Fix Version/s 1.7.06 [ 10200 ]
          Fix Version/s 1.7.05 [ 10164 ]
          jmd86 Janice Donahoe made changes -
          Fix Version/s 1.7.07 [ 10201 ]
          Fix Version/s 1.7.06 [ 10200 ]
          mem61 Mike Mendis made changes -
          Status Open [ 1 ] In Progress [ 3 ]
          mem61 Mike Mendis added a comment -
          This appears to only be part of Oracle. Fixing now.
          mem61 Mike Mendis added a comment - This appears to only be part of Oracle. Fixing now.
          mem61 Mike Mendis made changes -
          Assignee Mike Mendis [ mem61 ] Janice Donahoe [ jmd86 ]
          Status In Progress [ 3 ] Ready to Test [ 10001 ]
          jmd86 Janice Donahoe made changes -
          Status Ready to Test [ 10001 ] Testing [ 10002 ]
          jmd86 Janice Donahoe made changes -
          Resolution Fixed [ 1 ]
          Status Testing [ 10002 ] Resolved [ 5 ]
          jmd86 Janice Donahoe added a comment - - edited
          On 01/22/2016, the 1.7.07 Release was made available at the following locations.

          https://www.i2b2.org/software/
           - zip files for release 1.7.07 are available on this site. This includes both the code and documentation.

          https://github.com/i2b2
           - source code has been tagged with v1.7.07.
          jmd86 Janice Donahoe added a comment - - edited On 01/22/2016, the 1.7.07 Release was made available at the following locations. https://www.i2b2.org/software/  - zip files for release 1.7.07 are available on this site. This includes both the code and documentation. https://github.com/i2b2  - source code has been tagged with v1.7.07.
          jmd86 Janice Donahoe made changes -
          Status Resolved [ 5 ] Closed [ 6 ]
          anuv Anu added a comment -
          Is this property modified at source code level or at database level. Can you give details on where to look for this change.
          Also is this only for Oracle?
          Thanks
          Anu
          anuv Anu added a comment - Is this property modified at source code level or at database level. Can you give details on where to look for this change. Also is this only for Oracle? Thanks Anu
          anuv Anu added a comment -
          The limit on the no of ids that can be created in i2b21.7.07 is still limited to 99,999 on i2b2\i2b2-data-1.7.07\edu.harvard.i2b2.data\Release_1-7\NewInstall\Crcdata\scripts\crc_create_query_oracle.sql. Please verify if this has to be increased.
          anuv Anu added a comment - The limit on the no of ids that can be created in i2b21.7.07 is still limited to 99,999 on i2b2\i2b2-data-1.7.07\edu.harvard.i2b2.data\Release_1-7\NewInstall\Crcdata\scripts\crc_create_query_oracle.sql. Please verify if this has to be increased.

          People

            jmd86 Janice Donahoe
            jmd86 Janice Donahoe
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: