Unable to add attachments due to error "ORA-12899: value too large for column" (Doc ID 2797193.1)

Last updated on DECEMBER 19, 2023

Applies to:

Symptoms

Checked in a content item using a JDBC storage rule.

The content item’s files (e.g., the native file, weblayout, and thumbnail) were inserted into the FileStorage table.

Tried to add an attachment with an attachment name abcdefghijklmnopqrstuvwxyz12345.

Error occurs after clicking Add Attachments.

Navigated to the CS system logs at Administration -> Log Files -> Content Server Logs.  Clicked on today's date and found the below error stating a maximum of 30 characters can be loaded into dRendtionID.

Clicked on "Back to previous page" to navigate back to attachment form and changed the attachment name to abc.

Clicked on "Add Attachments" button.  The attachment was added to the content item successfully.

Verified the attachment was loaded in the FileStorage table successfully with rendition ID “D:{attachment_name}”

Reviewed the description of the FileStorage table and verified the dRenditionID column can only store a maximum of 30 characters.

Since the attachment rendition is prefixed with “D:”, the attachment names (i.e., Name fields in attachment form) can only have a maximum of 28 characters. 

The above limitation is with a database column, so tried adding attachment to a content item using a filesystem storage rule.  The issue does not occur as shown below where the attachment name is abcdefghijklmnopqrstuvwxyz12345.

The attachment was stored with filename “{attachment_name}.{file_extension}” in the below <weblayout>/…/{contentID}@d~{revision}.dir directory.  The attachments were stored in the same directory when the content item was checked in using a file system webless storage rule as well.

Changes

Upgraded 11g to 12c.

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.