Its increment does not match its pre-allocation size-优快云博客

本文详细介绍了在配置BPM Soa Email Notification时遇到DB Adapter配置错误的解决方法，包括如何修改WebLogic部署控制台中的DB Adapter属性，确保预分配大小与序列设置相匹配，从而解决DB Write Interaction Spec Execute Failed Exception。

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.

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