Kbase P124595: Error 2624 with EXCLUSIVE-LOCK on MS-SQL 2005
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
06/01/2010 |
|
Status: Verified
SYMPTOM(s):
Error 2624 with EXCLUSIVE-LOCK on MS-SQL 2005
<file-name> in use by <user> on <tty>. Wait or choose CANCEL to stop. (2624)
Table locks are being set when finding records using progress recid
Problem occurs on MS-SQL Server 2005
Problem occurs on MS-SQL Server 2008
Problem does not occur in MS-SQL Server 2000
Issue is reproducible when running SQL Server 2005 in SQL Server 2000 mode.
The error does not occur on every tables.
FACT(s) (Environment):
OpenEdge 10.1x
Windows
MS SQL DataServer
MS SQL Server 2005
MS SQL Server 2008
CAUSE:
Bug# OE00135645
CAUSE:
This is a known issue caused by a change in behaviour starting with Microsoft SQL Server 2005
FIX:
As a workaround, set the PROGRESS_RECID index of your <tty> table as a clustered index from MS SQL Server Management Studio