Question
· Nov 20, 2017

how to release row lock?

I have restored one database from backup, but when I query from some of tables,   prompt error :

this error remain after restart Caché service

I can skip this error with %nolock in select query.

 

My question is: 

1. why there were locks after restart service?

 

2. Can I release/rollback these locks by sql so I can query without %nolock?

Discussion (3)1
Log in or sign up to continue

It is hard to say, but i think the error is 'Invalid Name' and the reference to locks is just in the text of the long line of code where the error occurs. 

the name it says is invalid appears in the text but it doesn't look like valid COS to me so i can't see how it would compile. i would look at the cached query %sqlcq.DHCdAPP.892.INT and see what code it contains.