Return
-
Title
Post fails with ORA-04021 when trying to execute a DDL. -
Description
Post fails with ORA-04021 when trying to execute a DDL.
Errors in the event_log:Notice 2017-01-24 14:17:56.474071 30779 396588800 s:8 Poster: ORA-04021: timeout occurred while waiting to lock object . (posting from SRC, queue Target_queue, to Target) [module osp]Error 2017-01-24 14:17:56.474460 30779 396588800 s:8 Poster: que/seq = 8/ 37692227543 seqno/offset = 129629/2769936 Poster exit on ddl error due to ORA-04021: timeout occurred while waiting to lock object . on ALTER INDEX SAMPLE_NUK6 NOPARALLEL (posting from SRC, queue Target_queue, to Target) [module opo]Info 2017-01-24 14:17:56.479323 19128 806983520 Poster exited with code=1, pid = 30779 (posting from SRC, queue Target_queue, to Target) -
Cause
Possible external lock on the Object that SharePlex is trying to apply the DDL on. -
Resolution
Stop post manually and either wait for the lock on the database object to resolve on its own OR kill it manually and restart post.