Its increment does not match its pre-allocation size

If you have a chance to configure BPM Soa Email Notification, you may face this issue. 

 

Cause:

Exception occured during invocation of JCA binding: "JCA Binding execute of Reference operation 'insert' failed due to: DBWriteInteractionSpec Execute Failed Exception.
insert failed. Descriptor name: [****].
Caused by Exception [EclipseLink-7027] (Eclipse Persistence Services - 2.1.2.v20101206-r8635): org.eclipse.persistence.exceptions.ValidationException
Exception Description: The sequence named [TEST_SEQUENCE] 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.
<!--[if !supportLineBreakNewLine]-->
<!--[endif]-->

 

 

Solution:

 

you must change the DBAdapter properties in WebLogic deployments console, make the preallocationSize same as the one used for the sequence (Increment By field):

 

Example:

 

Create Sequence Test_Sequence Start With 1 Increment By 1 Nominvalue Nomaxvalue Nocycle Nocache