Error Messages (F)

A B C D E F G H I J K L M N O P Q R S T U V W X Y Z #

Failure getting record lock on a record from table

This error is associated with transaction isolation levels. The default transaction isolation level for older OpenLink drivers is READ UNCOMMITTED. OpenLink's current default is REAPETABLE READ.

Use the following instructions to change your transaction isolation level:

Multi-Tier Drivers

1. Login to the machine that hosts your OpenLink server components installation.
2. Use a text editor to open the oplrqb.ini file that resides in ~/openlink/bin.
3. Locate the [Environment PROGRESS100SQL] or [Environment PROGRESS91SQL] section.
4. Add the following parameter to the existing list of parameters:

DEFAULT_TXN_ISOLATION

5. Pass your desired transaction isolation level. The options are:

READ_UNCOMMITTED | READ_COMMITTED | REPEATABLE_READ | SERIALIZABLE

6. Save your changes and exit the file.
7. Restart or reinitialize your Request Broker service to initialize the change.

Single-Tier Drivers

1. Login to the machine that hosts your OpenLink drivers.
2. Locate & highlight your Data Source Name.
3. Click Configure.
4. Locate the Default Transaction Isolation: drop down.
5. Select your desired isolation level.
6. Save the changes to your DSN.