not undoing?

[kolonuk]

Hi all,

I got a strange message from one of our users logs yesterday:

WARNING: Could not read database record for undoing. (1750)

I have no idea what this means or how to diagnose the problem... It occurred in a regularly used, but minor, portion of the system we run, so it is not that important for now, but what if it occured in a vital section?

I assume it was caused by an undo statement, but I can't recreate it so can't be sure.

Any ideas?

PS. not sure if this is the right section, as it could be DBA and development both...?

 

[Casper]

KB P89767:

Status: Unverified
SYMPTOM(s):
Getting error 1750 when reading a record
Could not read database record for undoing. (1750)
Multiple user accessing database
Accessing records with NO-LOCK
CAUSE:
Record was delete by another user due to inconsistent program logic
FIX:
Use SHARE-LOCK or EXCLUSIVE-LOCK to prevent a user from deleting or
modifying the record while the program is using it

HTH,

Casper.

 

[kolonuk]

Thanks casper, I did think of something like that... but... I just searched through all our code and the table in question doesn't get deleted (it is quote headers, i could understand of it was quote lines...)