[IGNITE-1158] Duplicate Field when creating using Apache Ignite Schema Import utility

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 1.1.4
• Fix Version/s: ignite-1.4
• Component/s: general
• Assignee: Unassigned
• Reporter: Alexey Kuznetsov
• Created: 24/Jul/15 16:33
• Updated: 31/Jul/15 10:30
• Resolved: 31/Jul/15 09:42

Description

I am creating the cache using Apache Ignite Schema Import utility. But it
is generating me duplicate fields for my values.

public class ModelFieldStaticdata implements Serializable {
/** */
private static final long serialVersionUID = 0L;

/** Value for modelFieldStaticdataOid. */
private java.math.BigDecimal modelFieldStaticdataOid;

/** Value for modelFieldStaticdataOid. */
private java.math.BigDecimal modelFieldStaticdataOid;

/** Value for modelFieldStaticdataOid. */
private java.math.BigDecimal modelFieldStaticdataOid;

/** Value for modelFieldStaticdataOid. */
private java.math.BigDecimal modelFieldStaticdataOid;

/** Value for modelFieldStaticdataOid. */
private java.math.BigDecimal modelFieldStaticdataOid;

/** Value for modelFieldStaticdataOid. */
private java.math.BigDecimal modelFieldStaticdataOid;

I am using oracle sql developer 4.1.1.19 and the driver is ojdbc 6.1. The
script to create table is as follows

CREATE TABLE "ALGORECONUTILITY_DEV"."EXCEPTION_MASTER"
( "EXCEPTION_ID" VARCHAR2(100 CHAR),
"EXCEPTION_CREATED_DATE" DATE,
"EXCEPTION_PROCESSING_DATE" DATE,
"EXCEPTION_COMPLETION_DATE" DATE,
"EXCEPTION_PRIORITY" VARCHAR2(30 CHAR),
"EXCEPTION_SEVERITY" VARCHAR2(30 CHAR),
"GEOGRAPHY_ID" NUMBER(30,0),
"COUNTRY_ID" NUMBER,
"BRANCH_ID" NUMBER,
"L1L2STATUS" VARCHAR2(50 CHAR),
"SERVICE_LEVEL" VARCHAR2(100 CHAR),
"RECONCILIATION_TYPE" VARCHAR2(30 CHAR),
"UPDATED_BY" VARCHAR2(30 CHAR),
"UPDATED_DATE" TIMESTAMP (6),
"SESSION_ID" VARCHAR2(80 BYTE),
"RECORD_END_DATE" TIMESTAMP (6),
"RECORD_STATUS" VARCHAR2(10 CHAR),
"CREATED_DATE" TIMESTAMP (6),
"EXCEPTION_CATEGORY" VARCHAR2(32 BYTE),
"EXCEPTION_DESCRIPTION" VARCHAR2(180 BYTE),
"EXCEPTION_OID" NUMBER(30,0),
"EXCEPTION_STATUS" VARCHAR2(32 BYTE),
"EXCEPTION_TYPE_ID" NUMBER(30,0),
"FUNCTIONAL_AREA_ID" NUMBER(30,0),
"IPADDRESS" VARCHAR2(39 BYTE),
"PRODUCTLINE_ID" NUMBER(30,0),
"RECON_ID" VARCHAR2(32 BYTE),
"RECORD_VERSION" NUMBER(6,0),
"CREATED_BY" VARCHAR2(32 BYTE),
"LINK_ID" NUMBER(30,0),
"BUSINESS_CONTEXT_ID" VARCHAR2(32 CHAR),
"RECON_EXECUTION_ID" NUMBER(30,0),
"BUSINESS_PROCESS_ID" VARCHAR2(32 BYTE),
"MANUAL_ENTRY_FLAG" VARCHAR2(12 BYTE),
"PROCESSING_TYPE" VARCHAR2(32 BYTE),
"ASSET_CLASS_ID" VARCHAR2(32 BYTE),
"TRADE_DATE" DATE,
"PARENT_EXCEPTION_ID" VARCHAR2(100 BYTE),
"MERGED_EXCEPTION_ID" VARCHAR2(100 CHAR),
"GROUPED_EXCEPTION_ID" VARCHAR2(100 CHAR),
"EXCEPTION_GROUP_INDICATOR" VARCHAR2(10 CHAR),
"TOTAL_OUTSTANDING_AMOUNT" NUMBER(12,2),
"CLEARING_DATE" DATE,
"REASON_CODE" VARCHAR2(32 CHAR),
"COMMENTS" VARCHAR2(2000 CHAR),
"EXCEPTION_AUTHORIZATION_STATUS" VARCHAR2(32 CHAR),
"SUSPENSE_ENTRY_FLAG" VARCHAR2(10 CHAR)
) SEGMENT CREATION IMMEDIATE
PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
STORAGE(INITIAL 52428800 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT
FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "USERS" ;
--------------------------------------------------------
– DDL for Index EXCEPTION_MASTER_PK
--------------------------------------------------------

CREATE UNIQUE INDEX "ALGORECONUTILITY_DEV"."EXCEPTION_MASTER_PK" ON
"ALGORECONUTILITY_DEV"."EXCEPTION_MASTER" ("EXCEPTION_OID")
PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
STORAGE(INITIAL 196608 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT
FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "USERS" ;
--------------------------------------------------------
– Constraints for Table EXCEPTION_MASTER
--------------------------------------------------------

ALTER TABLE "ALGORECONUTILITY_DEV"."EXCEPTION_MASTER" ADD CONSTRAINT
"EXCEPTION_MASTER_PK" PRIMARY KEY ("EXCEPTION_OID")
USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
STORAGE(INITIAL 196608 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT
FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "USERS" ENABLE;

ALTER TABLE "ALGORECONUTILITY_DEV"."EXCEPTION_MASTER" MODIFY
("EXCEPTION_ID" NOT NULL ENABLE);

ALTER TABLE "ALGORECONUTILITY_DEV"."EXCEPTION_MASTER" MODIFY
("RECORD_STATUS" NOT NULL ENABLE);

ALTER TABLE "ALGORECONUTILITY_DEV"."EXCEPTION_MASTER" MODIFY
("CREATED_DATE" NOT NULL ENABLE);

ALTER TABLE "ALGORECONUTILITY_DEV"."EXCEPTION_MASTER" MODIFY
("EXCEPTION_OID" NOT NULL ENABLE);

ALTER TABLE "ALGORECONUTILITY_DEV"."EXCEPTION_MASTER" MODIFY
("EXCEPTION_STATUS" NOT NULL ENABLE);

ALTER TABLE "ALGORECONUTILITY_DEV"."EXCEPTION_MASTER" MODIFY ("IPADDRESS"
NOT NULL ENABLE);

ALTER TABLE "ALGORECONUTILITY_DEV"."EXCEPTION_MASTER" MODIFY
("RECORD_VERSION" NOT NULL ENABLE);

ALTER TABLE "ALGORECONUTILITY_DEV"."EXCEPTION_MASTER" MODIFY ("CREATED_BY"
NOT NULL ENABLE);

ALTER TABLE "ALGORECONUTILITY_DEV"."EXCEPTION_MASTER" MODIFY ("LINK_ID"
NOT NULL ENABLE);

ALTER TABLE "ALGORECONUTILITY_DEV"."EXCEPTION_MASTER" MODIFY
("BUSINESS_CONTEXT_ID" NOT NULL ENABLE);

ALTER TABLE "ALGORECONUTILITY_DEV"."EXCEPTION_MASTER" MODIFY
("RECON_EXECUTION_ID" NOT NULL ENABLE);
--------------------------------------------------------
– DDL for Trigger EXCEPTION_OID_TRIGGER
--------------------------------------------------------

CREATE OR REPLACE TRIGGER "ALGORECONUTILITY_DEV"."EXCEPTION_OID_TRIGGER"
before
INSERT ON "EXCEPTION_MASTER" FOR EACH row BEGIN IF inserting THEN
SELECT EXCEPTION_MASTER_SEQ.nextval INTO :NEW."EXCEPTION_OID" FROM dual;
END IF;
END;

/
ALTER TRIGGER "ALGORECONUTILITY_DEV"."EXCEPTION_OID_TRIGGER" DISABLE;