When DB Write to DS is giving locking issue saying it is Locked by some other process. Below is the error message.
com.appiancorp.rdbms.common.LockException: Could not write to the entities [XXXXXX] of data store "XXXXXXXXXXX", because the data is locked. (APNX-1-4180-00A): javax.persistence.OptimisticLockException: Row was updated or deleted by another transaction (or unsaved-value mapping was incorrect) : XXXXXXX
Discussion posts and replies are publicly visible
As an learn I think "The error indicates another process is modifying the same data you're trying to write to in Data Store (DS). Investigate which process holds the lock and adjust accordingly (e.g. retry logic, code synchronization).