Blocking Sessions Created On FILEADAPTER_IN Table
(Doc ID 2633550.1)
Last updated on FEBRUARY 15, 2021
Applies to:Oracle SOA Suite - Version 22.214.171.124.0 and later
Information in this document applies to any platform.
On : 126.96.36.199.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.
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