MaxRaiseSize and MaxTransactionSize Not Working As Expected In OSB 12214 (Doc ID 2904588.1)

Last updated on JANUARY 30, 2024

Applies to:

Goal

On : 12.2.1.4.0 version, OSB Transports

DB Adapter record pulling not working as expected in OSB 12214

The following JCA file was used but it's not pulling desired number of records from DB2 database. Ideally it should pull 20 records at a time and process.

<activation-spec className="oracle.tip.adapter.db.DBActivationSpec">
<property name="DescriptorName" value="XXXXXXXXX"/>
<property name="QueryName" value="XXXXXXXXX"/>
<property name="MappingsMetaDataURL" value="XXXXXXXXX-or-mappings.xml"/>
<property name="PollingStrategy" value="LogicalDeletePollingStrategy"/>
<property name="MarkReadColumn" value="XXXXXXXXX"/>
<property name="MarkReadValue" value="XXXXXXXXX"/>
<property name="MarkUnreadValue" value="XXXXXXXXX"/>
<property name="PollingInterval" value="45"/>
<property name="MaxRaiseSize" value="1"/>
<property name="MaxTransactionSize" value="20"/>
<property name="SequencingColumn" value="XXXXXXXXX"/>
<property name="NumberOfThreads" value="1"/>
<property name="ReturnSingleResultSet" value="false"/>
</activation-spec>

It's working fine in older environment OSB 12213 but not with 12.2.1.4.

What should one do to resolve this issue?

 

Solution

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