on 01-08-2015 3:05 PM
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.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
91 | |
10 | |
10 | |
9 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.