[TOPLINK-7027] The sequence named X is setup incorrectly. Its inc
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 ;