When updating the OAE Agent triggers in Applications Manager (AM) the update times out and the above error message is displayed.
The complete error message will look similar to this:
06:02:17.20 ASM0: .AxConnectionPool: getNamedConnection (sync) done update-OAEPRD jdbc:oracle:thin:@//automic.test.com:1525/Automic:apps
06:02:17.20 ASM5: SQL Error: 4021
06:02:17.20 ASM0: .DBAccess: doSql() sID-null [email protected] drop procedure aw_dbpipe_wait
ErrorMsg: AwE-5001 Database Query Error (8/22/17 6:02 AM)
Details: create or replace trigger XXAPPWORX_STATUS_NOTIF_TRG
before update on fnd_concurrent_requests for each row
when ( ( new.phase_code <> old.phase_code ) or
(new.status_code <> old.status_code ) or (new.hold_flag != old.hold_flag) )
begin
-- to trigger the pipe from appworx_oa_requests
update appworx_oa_requests set REQUEST_ID =REQUEST_ID
where request_id = :new.request_id;
end;
jdbc:oracle:thin:@//automic.test.com:1525/Automic:apps
java.sql.SQLException: ORA-04021: timeout occurred while waiting to lock object