Kbase P83749: Records are not saved in database after receiving errors (3765), (2252) and (2253).
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
15/11/2004 |
|
Status: Unverified
FACT(s) (Environment):
WebSpeed 3.x
SYMPTOM(s):
Records in database are missing.
Database log file shows errors (3765), (2252) and (2253) for WebSpeed users.
Message recvd while waiting: uc_wait=1, msg=70 (3765)
Begin transaction backout. (2252)
Transaction backout completed. (2253)
CAUSE:
What error (3765) means with msg=70 is that the WebSpeed agent was waiting for a record (from the db engine) to send to the client, but the agent received another message from the user asking for another record, which isn't allowed to occur because it's still waiting to process the previous request. The previous request is therefore aborted.
This can happen with WebSpeed, given that a user can easily re-submit a request if it's taking longer than they would like. And in this situation the transaction that was previously active can be backed out without the user knowing.
FIX:
An application review is required, and you need to determine:
1. Why users are re-submitting requests. E.g. Is the system performing poorly?
2. Whether there should be an application mechanism in place whereby there is confirmation of request completion.
It may be that you are losing records because your end user is of the belief that their transaction had completed when in fact it could have been aborted.