My Oracle Support Banner

Increasing the Column Size Of The 'Settings' Of 'Preferences' Table To Accommodate Another Directory Path Results in Error "TCM-0777, A database error occurred" (Doc ID 2200901.1)

Last updated on FEBRUARY 12, 2019

Applies to:

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

Symptoms

Is it possible to increase the Settings column of the WebCenter Content: Imaging Preferences table to more than 255 characters?

When attempting to add more directory paths to the 'InputDirectories' field, the following error appears:  

The total length of all 5 directory paths have reached the 255 column limit.

"Sep 22, 2016 4:59:43 PM EDT","A database error occurred.","Error","TCM-00777","","1","c4e99672e01e88c7:-47a0068e:153851e6f05:-8000-0000000000380104","1:27885","ipm_server1","oracle.imaging.service.exceptions","","","","servername","ip adress","<user>","","[ACTIVE].ExecuteThread: '17' for queue: 'weblogic.kernel.Default (self-tuning)'","","","","oracle.imaging.ImagingException: TCM-00777
stackTraceId: 8-1474577983438
faultType: DATABASE
faultDetails:
ErrorCode = javax.persistence.RollbackException, ErrorMessage = Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.3.1.v20111018-r10243): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: ORA-12899: value too large for column ""TS_IPM"".""PREFERENCES"".""SETTING"" (actual: 305, maximum: 255)

Error Code: 12899
Call: UPDATE PREFERENCES SET SETTING = ? WHERE ((CONTEXT = ?) AND (USERGUID = ?))
bind => [3 parameters bound]
Query: UpdateObjectQuery(oracle.imaging.common.PreferenceItem@3dda3bf6)

Changes

 

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!


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