Unable To Load Contacts In Parallel Threads "JBO-26092: Failed To Lock The Record" (Doc ID 2137972.1)

Last updated on SEPTEMBER 26, 2022

Applies to:

Symptoms

On : 11.1.10.0.0 version, Accounts, Contacts, Households

We are experiencing difficulties loading contacts via SOAP WS. As per oracle guidelines, we are using 48 threads to load contacts. Due to the known "account locking" issue (see our previous SR on this subject) we are gathering contacts in "account bins" and sending one request per account (one account usually has a few contacts) to avoid it.

However, now we are getting the same error, but for locking contacts:

JBO-26092: Failed to lock the record in table HZ_PERSON_PROFILES with key oracle.jbo.Key[300000742862449 ], another user holds the lock.

As a temporary workaround we will load the contacts one by one, but that limits us to 30 records / minute so the process will last for days instead of hours.

ERROR
-----------------------
JBO-26092: Failed to lock the record in table HZ_PERSON_PROFILES with key oracle.jbo.Key[300000742862449 ], another user holds the lock.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Create Several contacts under the same account using WSs
2. Some return an error saying the record is locked

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.