[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. |