QC – Getting Failed to Post error when when creating new defects

  • Questions
  • QC - Getting Failed to Post error when when creating new defects
Question ID: 104417
3
0

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?

Marked as spam
Posted by (Questions: 70, Answers: 111)
Asked on November 28, 2011 3:18 pm
2 views
Answers (1)
3
Private answer

SOLUTION

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'

Marked as spam
Posted by (Questions: 0, Answers: 613)
Answered on November 28, 2011 4:38 pm
thanks sammy, worked like a charm!
( at November 28, 2011 4:43 pm)