View Issue Details

Jump to NotesJump to History
IDProjectCategoryView StatusDate SubmittedLast Update
0000007SymmetricDSBugpublic2009-01-24 19:002014-02-04 15:05
ReporterAssigned Toelong  
Priorityhigh 
Status closedResolutionwon't fix 
Product Version1.5.1 
Target Version3.1.0Fixed in Version3.1.0 
Summary0000007: Data and batch tables rely on sequenced ids. When the number reaches its max value this can cause issues that are not yet handle
Description"The tables are using an ID field for primary key that is generated through a feature provided by the database. MySQL columns are using ""auto_increment"" and Oracle columns are using a ""sequence"". We need to reset the ID generator after it reaches its max value, otherwise inserts will start failing. Also, some of the code depends on the ID for ordering row results, which would create a problem when the values ""wrap around""."
TagsNo tags attached.

Activities

elong

2014-02-04 15:05

developer   ~0000439

ID field is larger now, so not as much of an issue. If max is reached, the data can be reset manually.

Issue History

Date Modified Username Field Change
2012-06-18 18:11 admin Target Version 3.1.0 =>
2014-02-04 15:05 elong Note Added: 0000439
2014-02-04 15:05 elong Status new => closed
2014-02-04 15:05 elong Assigned To => elong
2014-02-04 15:05 elong Resolution open => won't fix