Skip to Main Content

Integration

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

TOPLINK-7027 The sequence named is setup incorrectly

Alessandro IDec 28 2009 — edited Dec 30 2009
Oracle Fusion 11g
Oracle DB 11g
JDev 11g

I'm testing a SOA composite application and I am getting this error. I am a bit confused since the sequence definition looks fine and from SQLPLUS I don't get any error. The trace here below came from WebLogic SOA server.

Any suggestions on this are welcomed.

ec 28, 2009 1:49:39 PM oracle.j2ee.ws.server.ServerMessages severeMsgServletException
SEVERE: An error occurred for port: FabricProvider: javax.xml.rpc.soap.SOAPFaultException: 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: [AuditDB.Log].
Caused by Exception [TOPLINK-7027] (Oracle TopLink - 11g Release 1 (11.1.1.1.0) (Build 090527)): oracle.toplink.exceptions.ValidationException
Exception Description: The sequence named [LOG_SEQ1] is setup incorrectly. Its increment does not match its pre-allocation size..
".
The invoked JCA adapter raised a resource exception.
Please examine the above error message carefully to determine a resolution.


CREATE OR REPLACE TRIGGER "POC_AUDIT"."LOG_TRG"
BEFORE INSERT ON LOG
FOR EACH ROW
BEGIN
<<COLUMN_SEQUENCES>>
BEGIN
IF :NEW.ID IS NULL THEN
SELECT LOG_SEQ1.NEXTVAL INTO :NEW.ID FROM DUAL;
END IF;
END COLUMN_SEQUENCES;
END;

/
ALTER TRIGGER "POC_AUDIT"."LOG_TRG" ENABLE;

CREATE SEQUENCE "POC_AUDIT"."LOG_SEQ1" MINVALUE 1 MAXVALUE 999999999999999999999999999 INCREMENT BY 1 START WITH 22 CACHE 20 NOORDER NOCYCLE ;

Thanks in advance
This post has been answered by 648392 on Dec 29 2009
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jan 27 2010
Added on Dec 28 2009
2 comments
4,019 views