My Oracle Support Banner

DB Polling Is Not Working Properly In Integrated Cloud Service (ICS) (Doc ID 2232401.1)

Last updated on NOVEMBER 16, 2020

Applies to:

Integration Cloud Service - Version N/A and later
Oracle Integration-OIC - Version 18.2.5 and later
Information in this document applies to any platform.


This knowledge article reflects updated product names. Oracle Integration (OIC) was formerly known as Autonomous Oracle Integration Cloud (AOIC, A-OIC, AIC, OAIC,OIC, OAC). Please see KM document for the full list of recently renamed PaaS services.

DB adapter: ORA-00060: deadlock detected while polling records

An integration which polls records from Database using DB adapter has been created. Expected behavior is that after polling records from the table, DB adapter will update value of SYNC_TO_CLOUD column from 'N' to 'Y'. This logic works fine if there is only record in the table where value of SYNC_TO_CLOUD column is set to 'N'. But if there are multiple records with value of 'N' than DB adapter fails to process all the records with value'N'. For example:   

3 Records with polling status 'N' got inserted to polling table at the same time, 3 instances of ICS component should get triggered. But it is observed that only 1 or 2 instances are getting created.
In the agent logs we can see this error: 

Exception [EclipseLink-4002] (Eclipse Persistence Services -2.5.2.v20140319-9ad6abd): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: java.sql.SQLException: ORA-00060: deadlock detected while waiting for resource
Error Code: 60
bind => [2 parameters bound]
Query: DataModifyQuery(sql="UPDATE RACICS_POLL SET SYNC_TO_CLOUD = ?
at org.eclipse.persistence.exceptions.DatabaseException.sqlException(DatabaseExce
at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeDirectNoSelect(
at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeNoSelect( 

Caused By: java.sql.SQLException: ORA-00060: deadlock detected while waiting for resource
at oracle.jdbc.driver.T4CTTIoer.processError(
at oracle.jdbc.driver.T4CTTIoer.processError(


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.