ORA-12899 Error When Migrating Content From Folders_g To FrameWork Folders in WebCenter Content (WCC) 11g
(Doc ID 1618390.1)
Last updated on SEPTEMBER 21, 2023
Applies to:
Oracle WebCenter Content - Version 11.1.1.6.0 and laterInformation 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
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Cause |
Solution |
References |