Kbase 15752: Error 4407 Why does this occur?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
5/10/1998 |
|
Error 4407 Why does this occur?
Error 4407 '<table-name> RECID <RECID> was deleted by another user'
occurs when a RECID is referenced that no longer exists or
belongs in the table you are trying to access. For instance,
let's say that your program (Program1) tries to find a Customer
Record that happens to have RECID 111. Now, program1 has to wait for
it because Program2 has it locked. Let's say this Program2
deletes the Customer Record with RECID 111 and then creates a new
Item Record. Progress recycles RECIDs so it re-assigns RECID 111 to the
new Item Record. Now, Program2 is done and releases all the
record locks. Now it is time for Program1 to find the
record that no longer exists; however, the new Item record does
exist with that same RECID. This is when the error 4407 will
display since Progress cannot maintain two records with the same
RECID.
This error can happen frequently if users are running archive
programs that delete lots of records at the same time that
other users are querying the same database. This is a usability issue
and customers should avoid running these types of applications
at the same time.
Progress Software Technical Support Note # 15752