ORA-12899 Error When Migrating Content From Folders_g To FrameWork Folders in WebCenter Content (WCC) 11g (Doc ID 1618390.1)

Last updated on NOVEMBER 03, 2016

Applies to:

Oracle WebCenter Content - Version 11.1.1.6.0 and later
Information in this document applies to any platform.

Symptoms

In the WebCenter Content (WCC) application, when performing the Folders_g to Framework Folders migration, if any content has a file name over 150 characters, the migration will fail. The following error will be seen in the WCC log file:

xception occured during migration Unable to execute query 'IfldFile(INSERT INTO FolderFiles (fFileGUID, fParentGUID, fFileName, fPublishedFileName, fLinkRank, fInhibitPropagation, dDocName, dRevisionID, dPublishedRevisionID, fApplication, fOwner, fCreator, fLastModifier, fCreateDate, fLastModifiedDate, fSecurityGroup, fDocAccount, fClbraUserList, fClbraAliasList, fClbraRoleList) values ('39C5A8F697D02A25652AC8D5C4A64FD6', 'CBC57C267E7CC1A27969B896E7BB6C45', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA.txt', 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA.txt', 0, 0, 'WCCS1_000003', 1, 1, 'framework', 'weblogic', 'weblogic', 'weblogic', {ts '2013-07-31 18:10:10.177'}, {ts '2013-07-31 18:10:10.177'}, 'Public', '', '', '', ''))'.
ORA-12899: value too large for column "DEV_OCS"."FOLDERFILES"."FFILENAME" (actual: 159, maximum: 150)
java.sql.SQLException: ORA-12899: value too large for column "DEV_OCS"."FOLDERFILES"."FFILENAME" (actual: 159, maximum: 150).

Steps to replicate
------------------------------
1. Enable Folders_g and Framework Folders
2. Check in a piece of content to a Folders_g folder with a file name longer than 150 characters
3. Go to 'Administration' > 'Folders Migration'
4. Perform the folder migration
5. After it fails, go to the WCC log file and see the above mentioned error

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms