Kbase P186053: The same stored procedure run from two separate machines hangs up one of them
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
15/04/2011 |
|
Status: Unverified
SYMPTOM(s):
The same stored procedure is run from two separate machines at the same time
The procedure sometimes gets hung up and never completes for one user.
The process on the Microsoft SQL server cannot be killed
Microsoft SQL server has to be restarted
Using a linked server in SQL 2005
No errors
FACT(s) (Environment):
Windows
Progress 9.1E
CAUSE:
The DSN is set to the default isolation level, READ COMMITTED. Note that although nothing is selected for default
isolation when looking at the advanced tab in the ODBC data source, READ COMMITTED is actually what the isolation level is.
FIX:
Change the default isolation level for the OpenEdge ODBC driver to READ UNCOMMITTED using these steps:
1. Open Adminstrative Tools from the Windows Program menu
2. Select Data Sources (ODBC)
3. Choose the System DSN tab
4. Select the DATADIRECT 4.1 driver
5. Choose configure
6. On the Advanced tab, change the default isolation level to READ UNCOMMITTED
7. Run the procedures again.