[Progress Communities] [Progress OpenEdge ABL] Forum Post: RE: Lock wait timeout of 1800 seconds expired (8812)

Status
Not open for further replies.
M

mfurgal

Guest
Dmitri: These Dataserver settings are for the client writing to MSSQL and will not solve the problem. The problem is that the pro2 client (thread) is trying to write to the MSSQL database to create a record, but some other process using the MSSQL database is doing a table lock because that clients ISOLATION LEVEL is wrong. If the clients connecting to MDSQL to read the data are not ODBC, then what clients are they and can you have them set their ISOLATION LEVEL to READ UNCOMMITTED? Mike -- Mike Furgal Director – Database and Pro2 Services PROGRESS Bravepoint 617-803-2870 mfurgal@progress.com

Continue reading...
 
Status
Not open for further replies.
Top