Hi,
there is a customer whose HFSQL C/S file system is ok, just a single record of a single file is permanently locked.
HLockInfo tells us, it's been locked by a user who left the institution some weeks ago.
HUnlockRecNum() of the record doesn't work
Re-indexing the file works but repairing it doesn't work because it says: record locked!
We cannot shut down the database and restart it - it's a hospital with about 100 screens always connected by day and night and we'd have to insert a maintanence window which is not seen as a favourite solution. We don't know whether that would help anyway.
Any suggestions for solving that riddle? Thanks in advance!
Kind regards,
Guenter Predl
office@windev.at