Not sure what is wrong. This is occuring only in one of our projets. This happens for all users, so we know it is not a security issue. Each time a defect is added we get a "Failed to Post" error. Any ideas?
Answer by SammyH · Nov 28, 2011 at 04:38 PM
Here is the issue, the SEQUENCES table is out of sync with the BUG table.
This is always due to someone updating the database directly, NEVER a good idea.
Here is the fix.....
This SQL statement sets the next sequence to the next value after the last Defect ID (`BG_BUG_ID`).
Update SEQUENCES set SQ_SEQ_VALUE = (SELECT MAX(BG_BUG_ID) FROM BUG) + 1 where SQ_SEQ_NAME = 'BUG'