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

Last updated on FEBRUARY 16, 2017

Applies to:

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

Symptoms

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
Call: UPDATE RAC_ICS_POLL SET SYNC_TO_CLOUD = ? WHERE (SEQUENCE_ID = ?)
bind => [2 parameters bound]
Query: DataModifyQuery(sql="UPDATE RACICS_POLL SET SYNC_TO_CLOUD = ?
WHERE (SEQUENCE_ID = ?)")
at org.eclipse.persistence.exceptions.DatabaseException.sqlException(DatabaseExce ption.java:331)
at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeDirectNoSelect(DatabaseAccessor.java:900)
at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeNoSelect(DatabaseAccessor.java:962) 

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




Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms