Post fails with ORA-04021 when trying to execute a DDL. (4305123)

Chat now with support

Return

Feedback Submitted

Did this article solve an issue for you?

Select Rating

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.

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title