Blocking Sessions Created On FILEADAPTER_IN Table (Doc ID 2633550.1)

Last updated on NOVEMBER 22, 2023

Applies to:

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

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