Could not acquire a lock

[Former Member]

Hello,

I'm trying to activate and smartform but every time I'm getting this dump:

Error Text of the Database: "[ASE Error SQL12205]Could not acquire a lock

within the specified wait period. SERVER level wait period=2400 seconds,

spid=259, lock type=exclusive row, dbid=4, objid=1260735642, pageno=5821264,

rowno=5. Aborting the transaction.#"

I've checked the LWM and HWM, and this paramteres have default value 2147483647.

[former_member188958]

I don't think the LWM an HWM values will be relevant to this situation.  It sounds like some other process is holding an incompatible lock on this row for a long time, and your client is choosing to time out rather than continue to block.

Use a query against master..syslocks (or wade through the output of sp_lock) to look for such a process.

-bret