[Progress Communities] [Progress OpenEdge ABL] Forum Post: RE: Pro2 ReplQueue Record Locks

[mfurgal]

Dmitri: This is a lock on the pro2 target (Oracle or MSSQL). The Pro2 product checks to see if the target row is locked before it tries to update, and if it is, it skips the target row. However, during a create, if the target table is locked, it will block until the lock wait timeout is hit. Make sure all reporters on the Pro2 target have an isolation level of READ UNCOMMITTED so no queries escalate to table locks. Mike -- Mike Furgal Director – Database and Pro2 Services PROGRESS 617-803-2870 mfurgal@progress.com

Continue reading...