Kbase P78217: Error 2624 when running multiple transactions simultaneously with MS SQL Server DataServer
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
13/03/2008 |
|
Status: Verified
FACT(s) (Environment):
MS SQL DataServer
Progress 9.x
OpenEdge 10.x
Windows NT 32 Intel/Windows 2000
SYMPTOM(s):
Error 2624 when running multiple transactions simultaneously with MS SQL Server DataServer
<file-name> in use by <user> on <tty>. Wait or choose CANCEL to stop. (2624)
The same application runs from two clients simultaneously.
The first application that inserting the data in the SQL Server Database locks the records.
After first one is done then second application can inserts the records.
The application is built on the Progress Database using the sequence in the table
Migrated the Progress database to the MS SQL Server Database
During the migration process Progress already created sequence table (_SEQT_<sequence_Name> and the Stored Procedure (_SEQP_<sequence_Name>) in the SQL Server Database.
In the Application a code block is added to duplicate the effort that the SQL Server is already internally.
CAUSE:
The added code block to duplicate the sequence generation is locking the sequence table by the application so the same application from another client can not acquire it until the first application is done inserting the records.
FIX:
Remove the code block that is duplicating the generation of the sequence that otherwise done internally by the stored procedure (_SEQP_<sequence_Name>).