Kbase P104898: Newly created record does not exist when accessed from different session
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
9/26/2005 |
|
Status: Unverified
FACT(s) (Environment):
Progress 9.x
SYMPTOM(s):
Newly created record does not exist when accessed from different session
Creating a new record in a table
Immediately looking for the newly created record in a different session
Record does not exist
No errors during the creation of the record
CAUSE:
A background process running on the database server machine was in a constant loop looking for records in the table then processing and deleting the records
FIX:
Maintain a record lock on the newly created record so that the background process is not able to delete it before it should