OPT_LOCK_WAIT_TIME_IN_SECS is a load option that can be used to override the default object lock wait time in Workflow Orchestration.
Deployments and loads lock objects that they are processing. If there are multiple loads into a table and one (or more) of them is taking more than the default lock wait time to process, other loads will fail to get an object lock which will result in an error.
OPT_LOCK_WAIT_TIME_IN_SECS can be used with all table loads.
Increase wait time when a long-running load is causing others to fail
Let load A take on average 120 minutes to execute. Load B into the same entity often fails with error:
"error":"Conflict", "message":"Can't acquire lock"
OPT_LOCK_WAIT_TIME_IN_SECS is increased from default 90 minutes to 180 minutes in load B:
Load B will queue long enough for A to finish every time and errors will not be produced anymore.