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 X is setup incorrectly. Its inc

Alessandro IDec 28 2009 — edited May 16 2011
I am testing a SOA composite application, that with a DB adapter performs an INSERT against an Oracle DB 11g and I'm getting this exception, on which I am bit confused since on my opinion the sequence definition looks fine.
ps: from sqlplus works fine

Dec 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 TABLE "POC_AUDIT"."LOG"
( "ID" NUMBER NOT NULL ENABLE,
"WHO" VARCHAR2(20 BYTE) NOT NULL ENABLE,
"WHEN" DATE NOT NULL ENABLE,
"WHICH_CLIENT" VARCHAR2(20 BYTE),
"WHICH_SYS" VARCHAR2(20 BYTE) NOT NULL ENABLE,
"IP_CLIENT" VARCHAR2(20 BYTE),
"WS_OPERATION" VARCHAR2(20 BYTE),
CONSTRAINT "LOG_PK" PRIMARY KEY ("ID")
USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
TABLESPACE "USERS" ENABLE
) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
TABLESPACE "USERS" ;


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 ;
This post has been answered by Eric Elzinga on Dec 29 2009
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 13 2011
Added on Dec 28 2009
7 comments
6,110 views