ORA-12899: value too large for column "APP_CONFLUENCE"."ATTACHMENTS"."ATTACHMENT_COMMENT"

XMLWordPrintable

      NOTE: This suggestion is for Confluence Server. Using Confluence Cloud? See the corresponding suggestion.

      Below exception occurs after migrating database from MySQL to Oracle database.

      java.sql.SQLException: ORA-12899: value too large for column "APP_CONFLUENCE"."ATTACHMENTS"."ATTACHMENT_COMMENT" (actual: 306, maximum: 255)

      Below is the DDL for the particular table:

        CREATE TABLE "C530TEST"."ATTACHMENTS" 
   (	"ATTACHMENTID" NUMBER(19,0) NOT NULL ENABLE, 
	"TITLE" VARCHAR2(255) NOT NULL ENABLE, 
	"CONTENTTYPE" VARCHAR2(255) NOT NULL ENABLE, 
	"PAGEID" NUMBER(19,0) NOT NULL ENABLE, 
	"CREATOR" VARCHAR2(255), 
	"CREATIONDATE" DATE, 
	"LASTMODIFIER" VARCHAR2(255), 
	"LASTMODDATE" DATE, 
	"FILESIZE" NUMBER(19,0), 
	"ATTACHMENT_COMMENT" VARCHAR2(255), 
	"ATTVERSION" NUMBER(10,0), 
	"PREVVER" NUMBER(19,0), 
	 PRIMARY KEY ("ATTACHMENTID")
  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 "SYSTEM"  ENABLE, 
	 CONSTRAINT "FK54475F908C38FBEA" FOREIGN KEY ("PAGEID")
	  REFERENCES "C530TEST"."CONTENT" ("CONTENTID") ENABLE, 
	 CONSTRAINT "FK_ATTACHMENTS_LASTMODIFIER" FOREIGN KEY ("LASTMODIFIER")
	  REFERENCES "C530TEST"."USER_MAPPING" ("USER_KEY") ENABLE, 
	 CONSTRAINT "FK54475F9017D4A070" FOREIGN KEY ("PREVVER")
	  REFERENCES "C530TEST"."ATTACHMENTS" ("ATTACHMENTID") ENABLE, 
	 CONSTRAINT "FK_ATTACHMENTS_CREATOR" FOREIGN KEY ("CREATOR")
	  REFERENCES "C530TEST"."USER_MAPPING" ("USER_KEY") ENABLE
   ) 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 "SYSTEM"

      Please investigate the possibilities of having it increased to avoid similar issues.

      Thank you and regards,
      Lazuardi

            Assignee:
            Unassigned
            Reporter:
            MuhammadA
            Votes:
            2 Vote for this issue
            Watchers:
            4 Start watching this issue

              Created:
              Updated:
              Resolved: