wx fg · 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?

0 447
Discussion (3)2
Log in or sign up to continue

Are there locks against this global?  You can check this with View Locks in the Management Portal

Also, are you sure that the Backup was taken using an appropriate backup tool?   Generally a backup will be taken from a consistent state, and would not include locking

no locks in the view locks.   I backuped with 

BACKUP^^DBACK("","F","backup","tplusn_db.cbk","Y","%bakPath%\backup.log", "NOISY","Y","Y","",60, "F")

and restored with 

do EXTSELCT^DBREST(1,0,"plusn_db.cbk","list.txt",4,"","")


and do not appy Journal Files

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.