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

Issue –> If you are using oracle sequence in DB adapter , then you will get the below error.

Error –> Exception while invoking com.oracle.bpel.client.BPELFault: faultName: {{http://schemas.oracle.com/bpel/extension}bindingFault} messageType: {{http://schemas.oracle.com/bpel/extension}RuntimeFaultMessage} parts: {{ summary=Exception occurred when binding was invoked. Exception occurred during invocation of JCA binding: “JCA Binding execute of Reference operation ‘insert’ failed due to: DBWriteInteractionSpec Execute Failed Exception. insert failed. Descriptor name: [Loxxx.Xxtestg]. Caused by Exception [EclipseLink-7027] (Eclipse Persistence Services – 2.6.1.v20150916-55dc7c3): org.eclipse.persistence.exceptions.ValidationException Exception Description: The sequence named [XXXXX] is setup incorrectly. Its increment does not match its pre-allocation size.. Please see the logs for the full DBAdapter logging output prior to this exception. This exception is considered not retriable, likely due to a modelling mistake. “. The invoked JCA adapter raised a resource exception. Please examine the above error message carefully to determine a resolution. ,code=null ,detail= Exception Description: The sequence named [XXXX] is setup incorrectly. Its increment does not match its pre-allocation size.}

Solution –> This issue occurs because DbAdapter by default sets pre-allocation size to 50. This should match with Database Sequence’s increment size.

If my DB sequence increment size is 1 then db adapter pre -allocation size shoud be 1.

For changing this value you have to follow the below steps.

Login weblogic console –> Go to deployments –> DB adapter –> Configuration tab –> outbound connection pool –> and open your connection factory.

connectionfactory.JPG

You can see the value for sequencePreallcoationSize as 50, change it to 1.

Press ENTER to actually change it. Click on Save button.

Go to Deployment, select dbAdapter and click on Update and then Activate.

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