My Oracle Support Banner

Blocking Sessions Created On FILEADAPTER_IN Table (Doc ID 2633550.1)

Last updated on FEBRUARY 15, 2021

Applies to:

Oracle SOA Suite - Version 12.2.1.1.0 and later
Information in this document applies to any platform.

Symptoms

On : 12.2.1.1.0 version, BPEL Service Engine

Blocking Sessions created on FILEADAPTER_IN table

Some SOA Composites using HAFileAdapter. polls for files and then process the files. Sometimes, the blocking sessions are created in the SOAINFRA schema with a row-level lock on the FILEADAPTER_IN table with the following SQL:

DELETE FROM FILEADAPTER_IN
WHERE FILE_PROCESSED = '2'
AND FILE_READONLY = 'N'
AND ROOT_DIRECTORY = :1;

 

When this happens, transactions fail. As soon as the block sessions are killed, the transactions go through normally.

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!


In this Document
Symptoms
Cause
Solution
References


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