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

Last updated on JUNE 21, 2016

Applies to:

Oracle Fusion Sales Cloud Service - Version 11.1.10.0.0 and later
Information in this document applies to any platform.

Symptoms

On : 11.1.10.0.0 version, Accounts, Contacts, Households

Unable to load Contacts in parallel threads "JBO-26092: Failed to lock the record"

Dear support,

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

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot upload the data quickly enough.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms