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.
The sequence named [TEST_SEQ] is setup incorrectly. Its increment does not match its pre-allocation size.
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.
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.