Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Getting error ORA-00054: resource busy and acquire with NOWAIT specified or timeout expired

ksmith611Aug 7 2018 — edited Aug 21 2018

We have several ODI mappings that are failing randomly with error - ORA-00054: resource busy and acquire with NOWAIT specified or timeout expired on the Truncate Table step of IKM Oracle Insert. The mappings run early in the morning and there are no other jobs that are querying the tables.

The code is

truncate table ODSMGR.MST_BU_IDCARD

Sometimes the truncate is successful and other times it gets the resource busy error. We are using Data Integrator Version 12.2.1. When a mapping fails, I do look in gv$access and V$LOCKED_OBJECT to see if there is a lock, and I do not see anything. I am a beginner with ODI and am not sure what I am overlooking.

Thanks

Locked Post

New comments cannot be posted to this locked post.

Locked on Sep 18 2018

Added on Aug 7 2018

#business-intelligence-applications, #data-integrator, #system-management-and-integration

3 comments

3,746 views