My Oracle Support Banner

User Defined Dimension (UDD) and ASAP Commit Takes a Very Long Time (Doc ID 2233756.1)

Last updated on MARCH 08, 2019

Applies to:

Oracle Retail Advanced Inventory Planning - Version 14.1.2 and later
Oracle Retail Predictive Application Server - Version 14.1.3 and later
Information in this document applies to any platform.


The error "Cannot obtain a read lock on database '/u01/aip/rpas/domain/AIP/data/hmaint.db.lck', 194. Another process has the database locked." occurs when a user performs User Defined Dimension (UDD) and commits under ASAP queue.  This is because the UDD commit is taking an excessively long time.


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.