My Oracle Support Banner

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

Last updated on AUGUST 02, 2018

Applies to:

Integration Cloud Service - Version N/A and later
Autonomous Integration Cloud - Version 18.2.5 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)




Changes

 

Cause

To view full details, 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 a vibrant support community of peers and Oracle experts.