Uploaded image for project: 'Confluence Data Center'
  1. Confluence Data Center
  2. CONFSERVER-32362

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

XMLWordPrintable

    • We collect Confluence feedback from various sources, and we evaluate what we've collected when planning our product roadmap. To understand how this piece of feedback will be reviewed, see our Implementation of New Features Policy.

      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

            [CONFSERVER-32362] ORA-12899: value too large for column "APP_CONFLUENCE"."ATTACHMENTS"."ATTACHMENT_COMMENT"

            No work has yet been logged on this issue.

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

                Created:
                Updated:
                Resolved: