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

Type: Suggestion
Resolution: Won't Do
Fix Version/s: None
Component/s: Content - Attachments
Labels:
- affects-server
- files&attachments

Feedback Policy:

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

relates to

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

Closed

is detailed by: CSP-116657 You do not have permission to view this issue

Sen Geronimo made changes - 31/Jan/2023 2:48 AM

Workflow

Original: JAC Suggestion Workflow 4 [ 3571274 ]

New: JAC Suggestion Workflow 3 [ 4334350 ]

Katherine Yabut made changes - 19/Sep/2019 5:24 AM

Workflow	Original: JAC Suggestion Workflow 2 [ 3181161 ]	New: JAC Suggestion Workflow 4 [ 3571274 ]
Status	Original: RESOLVED [ 5 ]	New: Closed [ 6 ]

Katherine Yabut made changes - 29/Apr/2019 5:11 AM

Workflow

Original: JAC Suggestion Workflow [ 3038168 ]

New: JAC Suggestion Workflow 2 [ 3181161 ]

Owen made changes - 21/Nov/2018 6:25 AM

Workflow

Original: Confluence Workflow - Public Facing v4 [ 2535313 ]

New: JAC Suggestion Workflow [ 3038168 ]

Rachel Lin (Inactive) made changes - 01/Feb/2018 4:32 AM

Workflow

Original: Confluence Workflow - Public Facing v3 [ 2297883 ]

New: Confluence Workflow - Public Facing v4 [ 2535313 ]

Katherine Yabut made changes - 31/May/2017 5:39 AM

Workflow

Original: Confluence Workflow - Public Facing v3 - TEMP [ 2193703 ]

New: Confluence Workflow - Public Facing v3 [ 2297883 ]

Katherine Yabut made changes - 31/May/2017 2:05 AM

Workflow

Original: Confluence Workflow - Public Facing v3 [ 1935538 ]

New: Confluence Workflow - Public Facing v3 - TEMP [ 2193703 ]

Katherine Yabut made changes - 03/Apr/2017 4:00 AM

Workflow

Original: Confluence Workflow - Public Facing v2 [ 1752766 ]

New: Confluence Workflow - Public Facing v3 [ 1935538 ]

jonah (Inactive) made changes - 02/Apr/2017 8:28 AM

Description

Original: Below exception occurs after migrating database from MySQL to Oracle database.
{code}
java.sql.SQLException: ORA-12899: value too large for column "APP_CONFLUENCE"."ATTACHMENTS"."ATTACHMENT_COMMENT" (actual: 306, maximum: 255)
{code}

Below is the DDL for the particular table:
{code:sql}
  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"
{code}

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

Thank you and regards,
Lazuardi

New: {panel:bgColor=#e7f4fa}
  *NOTE:* This suggestion is for *Confluence Server*. Using *Confluence Cloud*? [See the corresponding suggestion|http://jira.atlassian.com/browse/CONFCLOUD-32362].
  {panel}

Below exception occurs after migrating database from MySQL to Oracle database.
{code}
java.sql.SQLException: ORA-12899: value too large for column "APP_CONFLUENCE"."ATTACHMENTS"."ATTACHMENT_COMMENT" (actual: 306, maximum: 255)
{code}

Below is the DDL for the particular table:
{code:sql}
  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"
{code}

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

Thank you and regards,
Lazuardi

jonah (Inactive) made changes - 02/Apr/2017 8:28 AM

Link

New: This issue relates to ~~CONFCLOUD-32362~~ [ ~~CONFCLOUD-32362~~ ]

Assignee:: Unassigned

Reporter:: MuhammadA

Votes:: 2 Vote for this issue

Watchers:: 4 Start watching this issue

Created:: 23/Jan/2014 4:12 PM

Updated:: 19/Sep/2019 5:24 AM

Resolved:: 21/Feb/2017 10:51 AM

Details

Description

Attachments

Issue Links

Forms

Activity

People

Dates