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

          Mike, has this been fixed?
          jmd86 Janice Donahoe added a comment - Mike, has this been fixed?
          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.
          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.
          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: