Tuesday, January 25, 2011

Its increment does not match its pre-allocation size

25-Jan-2011 19:17:44 o'clock WET Error oracle.soa.bpel.engine.dispatch BEA-000000 failed to handle message
com.oracle.bpel.client.BPELFault: faultName: {{http://schemas.oracle.com/bpel/extension}bindingFault}
messageType: {{http://schemas.oracle.com/bpel/extension}RuntimeFaultMessage}
parts: {{summary= summary Exception occured when binding was invoked.
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: [BOOK_LOT.BOOKLot].
Caused by Exception [EclipseLink-7027] (Eclipse Persistence Services - 2.1.2.v20101206-r8635): org.eclipse.persistence.exceptions.ValidationException
Exception Description: The sequence named [BOOK_LOT_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.
".
The invoked JCA adapter raised a resource exception.
Please examine the above error message carefully to determine a resolution.
/summary
,detail= detail
Exception Description: The sequence named [BOOK_LOT_SEQUENCE] is setup incorrectly. Its increment does not match its pre-allocation size. /detail ,code= code null /code }




the or-mapping file specifies:

sequencing
            sequence-name BOOK_LOT_SEQUENCE /sequence-name
            sequence-field table="BOOK_LOT" name="ID_BOOK_LOT"/
         /sequencing

here
http://wiki.eclipse.org/Introduction_to_Relational_Projects_%28ELUG%29#Sequencing_and_Preallocation_Size

some more (useless) info on the OR-MAPPING file.

after hours of googling, I found out the solution:

http://forums.oracle.com/forums/thread.jspa?threadID=1006099&tstart=0


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

Create Sequence Book_Lot_Sequence Start With 1 Increment By 1 Nominvalue Nomaxvalue Nocycle Nocache;



http://forums.oracle.com/forums/thread.jspa?threadID=1006099&tstart=0

No comments: