[
https://issues.apache.org/jira/browse/IGNITE-1158?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Alexey Kuznetsov updated IGNITE-1158:
-------------------------------------
Fix Version/s: (was: ignite-1.5)
ignite-1.4
> Duplicate Field when creating using Apache Ignite Schema Import utility
> -----------------------------------------------------------------------
>
> Key: IGNITE-1158
> URL: https://issues.apache.org/jira/browse/IGNITE-1158
> Project: Ignite
> Issue Type: Bug
> Components: general
> Affects Versions: 1.1.4
> Reporter: Alexey Kuznetsov
> Assignee: Pavel Konstantinov
> Fix For: ignite-1.4
>
> Attachments: CacheConfig.java, ExceptionMaster.java,
> ExceptionMasterKey.java, ignite-1.3.3_ignite-1158.patch,
> ignite-type-metadata.xml
>
>
> 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;
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
