Changed the SequencePreallocationSize value from 50 to 1 but the change is not reflected at runtime (Doc ID 2007190.1)

Last updated on JANUARY 04, 2017

Applies to:

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

Goal

In the DB Adapter configuration the javax.resource.cci.ConnectionFactory connection group has a parameter for sequencePreallocationSize which is set to 50. This value was changed to 1 but has not altered the behavior at runtime.
 

These are the steps followed:
Login to Uat soa console:
http://example.com:7001/console
Click on “Lock and edit”.
Click on “Deployments” --> “DbAdapter”
Click on “Configuration” --> “Outbound Connection pools”
Click on “+” and click on eis/DB/VLTD

In the outbound connection properties table , Double click on “SequencePreAllocatioonSize”  “property value “ column where it is set to 50.

Set it to “1” and hit enter [The change doesn’t happen otherwise] and Save.
Go back to “Deployments” select “DbAdapter” and click “Update”  
Click “Finish” in the next screen .

Activate the changes
No restart is required

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms