[CORE-118] Increase number of queries that can be run in the "lifetime" of the database Created: 09/Jun/14  Updated: 06/Oct/16  Resolved: 14/Dec/15

Status: Closed
Project: i2b2 Core Software
Component/s: Data
Affects Version/s: 1.7.01
Fix Version/s: 1.7.07

Type: Improvement Priority: Major
Reporter: Janice Donahoe Assignee: Janice Donahoe
Resolution: Fixed Votes: 0
Labels: None
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Rank: 0|i000e7:
i2b2 Feature/s:
Queries
i2b2 Sponsored Project/s:
i2b2 Core
Affects Database/s:
All databases
Affects Web Browser/s:
All Web Browsers
Participant/s:

 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.



 Comments   
Comment by Janice Donahoe [ 02/Oct/14 ]
Mike, has this been fixed?
Comment by Mike Mendis [ 23/Sep/15 ]
This appears to only be part of Oracle. Fixing now.
Comment by Janice Donahoe [ 25/Jan/16 ]
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.
Comment by Anu [ 28/Sep/16 ]
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
Comment by Anu [ 06/Oct/16 ]
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.
Generated at Sun Apr 05 16:33:40 UTC 2020 using JIRA 7.6.3#76005-sha1:8a4e38d34af948780dbf52044e7aafb13a7cae58.