My Oracle Support Banner

LoadHier Exits With Status 0, but "Cannot obtain a write lock on database" Errror Occurs and Hierdatacleaner Log Shows Exit Status 6 (Doc ID 1590407.1)

Last updated on APRIL 13, 2021

Applies to:

Oracle Retail Predictive Application Server - Version 13.2.3 and later
Information in this document applies to any platform.


At the end of multi-process loadHier, the hierdatacleaner private utility is called in multi-process mode.  In the case of a large domain, one or more sub-processes may error out with lock timeouts on changearray.db or shadow.db of the primary domain.  The following error occurs:

Steps to Reproduce:

This is difficult to reproduce and is based on the number of positions being purged or reclassed in a particular load.  The following steps will increase the chance of the issue happening.

  1. Set the RPAS_LOCK_TIMEOUT to a shorter interval than 60000. For example, 3000.
  2. Create either a large number of reclass loads or purge a large number of partitioned positions without purging the full domain.
  3. Run loadHier with processes > 3.
  4. LoadHier will succeed, but check the hierdatacleaner log in the output for errors.


To view full details, 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 a vibrant support community of peers and Oracle experts.