The sequence named [TEST_SEQ] is setup incorrectly. Its increment does not match its pre-allocation size.

If we have used Native sequencing in DB adapter and default increment size of  sequence does not match with DB adapter outbound connection pool then we will get the below error.

Error –>

The sequence named [TEST_SEQ] is setup incorrectly. Its increment does not match its pre-allocation size.

Solution –>

To resolve the issue we have to update the db adapter connection pool property “SequencePreAllocationSize” to sequence increment size, in our case it is 1.

Navigation –>

Navigate to Deployments->dbAdapter -> Click on Configuration’s Tab-> Click on your Outbound Connection Pools and then click on Connection Factory name -> Open Properties Tab

Change ‘sequencePreallocationSize’ property’s value to 1. Press ENTER to actually change the value. Click on Save button.

seqpreallocationsize

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s