Kbase P89986: Sequence changes not saved to DB if no transaction takes place before a DB crash
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
20/01/2005 |
|
Status: Unverified
SYMPTOM(s):
Sequence changes not saved if no transaction takes place before a DB crash
Calling NEXT-VALUE(sequence) outside of a transaction
System wide no transactions take place
Database Crashes before next transaction
Current value of the sequence is not updated correctly
CAUSE:
No transaction is available to write the changes to the DB
FIX:
Explicitly create a transaction with a "DO TRANSACTION:" statement. For example:
i = NEXT-VALUE(sequence).
would become:
DO TRANSACTION:
i = NEXT-VALUE(sequence).
END.