Error Message: Failure getting record lock on a record from table or Lock table is full. (7870)

These errors are associated with transaction isolation levels.

The default transaction isolation level for our SQL-89 drivers was READ UNCOMMITTED. The default for our SQL-92 drivers is REPEATABLE READ.

Follow these instructions to set the transaction isolation level as appropriate to your deployment.