• State Not Answered
  • Replies 5 replies
  • Subscribers 7 subscribers
  • Views 7622 views
  • Users 0 members are here
Related Discussions
Home » Discussions » Administration

Cannot Insert NULL Into DB Table Error

deeptip
Certified Senior Developer

While trying to import a patch on 7.10 oracle I get the following error:
An error occurred while updating content [id=3477 uuid=_a-0000d925-a467-8000-4594-010000010000_13518]: org.springframework.orm.jpa.JpaSystemException: org.hibernate.exception.ConstraintViolationException: Could not execute JDBC batch update; nested exception is javax.persistence.PersistenceException: org.hibernate.exception.ConstraintViolationException: Could not execute JDBC batch update (APNX-1-4071-008)
com.appiancorp.ix.ConsumerException: type=content, srcId=_a-0000d925-a467-8000-4594-010000010000_13518, dstId=3477, cause=org.springframework.orm.jpa.JpaSystemException: org.hibernate.exception.ConstraintViolationException: Could not execute JDBC batch update; nested exception is javax.persistence.PersistenceException:

The patch was created on the same version and yet fails to import back in. Any inputs?
Thanks

OriginalPostID-206606

OriginalPostID-206606

  Discussion posts and replies are publicly visible

Parents
  • 0
    Certified Senior Developer
    --------------------------------------------------------
    -- DDL for Table TEST_DATA
    --------------------------------------------------------

    CREATE TABLE "APPIANDEV"."TEST_DATA"
    (\t"ID" NUMBER(19,0),
    \t"UUID" VARCHAR2(255 CHAR),
    \t"OBJ_TYPE" VARCHAR2(255 CHAR),
    \t"OBJ_UUID" VARCHAR2(255 CHAR),
    \t"OBJ_VERSION_ID" NUMBER(19,0),
    \t"DATA_TYPE" VARCHAR2(255 CHAR),
    \t"DATA" CLOB
    ) SEGMENT CREATION IMMEDIATE
    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 FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
    TABLESPACE "APPIANDEV_USER_DATA"
    LOB ("DATA") STORE AS BASICFILE (
    TABLESPACE "APPIANDEV_USER_DATA" ENABLE STORAGE IN ROW CHUNK 8192 RETENTION
    NOCACHE LOGGING
    STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
    PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)) ;
    --------------------------------------------------------
    -- DDL for Index PK_TEST_DATA
    --------------------------------------------------------

    CREATE UNIQUE INDEX "APPIANDEV"."PK_TEST_DATA" ON "APPIANDEV"."TEST_DATA" ("ID")
    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 FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
    TABLESPACE "APPIANDEV_USER_DATA" ;
    --------------------------------------------------------
    -- DDL for Index SYS_C0011479
    --------------------------------------------------------

    CREATE UNIQUE INDEX "APPIANDEV"."SYS_C0011479" ON "APPIANDEV"."TEST_DATA" ("OBJ_UUID", "OBJ_VERSION_ID", "OBJ_TYPE")
    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 FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
    TABLESPACE "APPIANDEV_USER_DATA" ;
    --------------------------------------------------------
    -- Constraints for Table TEST_DATA
    --------------------------------------------------------

    ALTER TABLE "APPIANDEV"."TEST_DATA" ADD CONSTRAINT "PK_TEST_DATA" 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 FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
    TABLESPACE "APPIANDEV_USER_DATA" ENABLE;

    ALTER TABLE "APPIANDEV"."TEST_DATA" MODIFY ("ID" NOT NULL ENABLE);

    ALTER TABLE "APPIANDEV"."TEST_DATA" MODIFY ("UUID" NOT NULL ENABLE);

    ALTER TABLE "APPIANDEV"."TEST_DATA" MODIFY ("OBJ_TYPE" NOT NULL ENABLE);

    ALTER TABLE "APPIANDEV"."TEST_DATA" MODIFY ("OBJ_UUID" NOT NULL ENABLE);

    ALTER TABLE "APPIANDEV"."TEST_DATA" MODIFY ("OBJ_VERSION_ID" NOT NULL ENABLE);

    ALTER TABLE "APPIANDEV"."TEST_DATA" MODIFY ("DATA_TYPE" NOT NULL ENABLE);

    ALTER TABLE "APPIANDEV"."TEST_DATA" MODIFY ("DATA" NOT NULL ENABLE);

    ALTER TABLE "APPIANDEV"."TEST_DATA" ADD UNIQUE ("OBJ_UUID", "OBJ_VERSION_ID", "OBJ_TYPE")
    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 FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
    TABLESPACE "APPIANDEV_USER_DATA" ENABLE;

Reply
  • 0
    Certified Senior Developer
    --------------------------------------------------------
    -- DDL for Table TEST_DATA
    --------------------------------------------------------

    CREATE TABLE "APPIANDEV"."TEST_DATA"
    (\t"ID" NUMBER(19,0),
    \t"UUID" VARCHAR2(255 CHAR),
    \t"OBJ_TYPE" VARCHAR2(255 CHAR),
    \t"OBJ_UUID" VARCHAR2(255 CHAR),
    \t"OBJ_VERSION_ID" NUMBER(19,0),
    \t"DATA_TYPE" VARCHAR2(255 CHAR),
    \t"DATA" CLOB
    ) SEGMENT CREATION IMMEDIATE
    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 FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
    TABLESPACE "APPIANDEV_USER_DATA"
    LOB ("DATA") STORE AS BASICFILE (
    TABLESPACE "APPIANDEV_USER_DATA" ENABLE STORAGE IN ROW CHUNK 8192 RETENTION
    NOCACHE LOGGING
    STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
    PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)) ;
    --------------------------------------------------------
    -- DDL for Index PK_TEST_DATA
    --------------------------------------------------------

    CREATE UNIQUE INDEX "APPIANDEV"."PK_TEST_DATA" ON "APPIANDEV"."TEST_DATA" ("ID")
    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 FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
    TABLESPACE "APPIANDEV_USER_DATA" ;
    --------------------------------------------------------
    -- DDL for Index SYS_C0011479
    --------------------------------------------------------

    CREATE UNIQUE INDEX "APPIANDEV"."SYS_C0011479" ON "APPIANDEV"."TEST_DATA" ("OBJ_UUID", "OBJ_VERSION_ID", "OBJ_TYPE")
    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 FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
    TABLESPACE "APPIANDEV_USER_DATA" ;
    --------------------------------------------------------
    -- Constraints for Table TEST_DATA
    --------------------------------------------------------

    ALTER TABLE "APPIANDEV"."TEST_DATA" ADD CONSTRAINT "PK_TEST_DATA" 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 FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
    TABLESPACE "APPIANDEV_USER_DATA" ENABLE;

    ALTER TABLE "APPIANDEV"."TEST_DATA" MODIFY ("ID" NOT NULL ENABLE);

    ALTER TABLE "APPIANDEV"."TEST_DATA" MODIFY ("UUID" NOT NULL ENABLE);

    ALTER TABLE "APPIANDEV"."TEST_DATA" MODIFY ("OBJ_TYPE" NOT NULL ENABLE);

    ALTER TABLE "APPIANDEV"."TEST_DATA" MODIFY ("OBJ_UUID" NOT NULL ENABLE);

    ALTER TABLE "APPIANDEV"."TEST_DATA" MODIFY ("OBJ_VERSION_ID" NOT NULL ENABLE);

    ALTER TABLE "APPIANDEV"."TEST_DATA" MODIFY ("DATA_TYPE" NOT NULL ENABLE);

    ALTER TABLE "APPIANDEV"."TEST_DATA" MODIFY ("DATA" NOT NULL ENABLE);

    ALTER TABLE "APPIANDEV"."TEST_DATA" ADD UNIQUE ("OBJ_UUID", "OBJ_VERSION_ID", "OBJ_TYPE")
    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 FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
    TABLESPACE "APPIANDEV_USER_DATA" ENABLE;

Children
No Data
© 2025 Appian. All rights reserved.
We want to hear from you! Submit a review on Gartner or G2.