[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
|Project:||i2b2 Core Software|
|Reporter:||Janice Donahoe||Assignee:||Janice Donahoe|
|Remaining Estimate:||Not Specified|
|Time Spent:||Not Specified|
|Original Estimate:||Not Specified|
|i2b2 Sponsored Project/s:||
|Affects Web Browser/s:||
All Web Browsers
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.
|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.
- zip files for release 1.7.07 are available on this site. This includes both the code and documentation.
- 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?
|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.|