My Oracle Support Banner

Distributed Polling - SQL Server DB (Doc ID 2544471.1)

Last updated on MAY 28, 2019

Applies to:

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

Symptoms

On : 11.1.1.7.8 version, BPEL Service Engine

ACTUAL BEHAVIOR
---------------
Distributed Polling - SQL Server DB


We have configured distributed polling in a SOA composite which is polling SQL server DB for the records and whenever the record is available to poll, it is picked by different servers in our production clustered environment. Due to this issue same record is sent multiple times to the target application which is creating lot of load on SOA servers and the destination applications as well.


EXPECTED BEHAVIOR
-----------------------
Distributed Polling - SQL Server DB should work.


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.