When Adding Directory Values to the WebCenter Content: Imaging MBean InputDirectories Path Error "ORA-12899: value too large for column error:" Occurs in the Log

(Doc ID 2330253.1)

Last updated on NOVEMBER 21, 2017

Applies to:

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

Symptoms

While adding additional directories to WebCenter Content: Imaging MBean InputDirectories path in the Enterprise Manager (EM) console, the below error occurs in the logs:

<Nov 10, 2017 5:20:09 AM EST> <Error> <oracle.imaging.service.exceptions> <TCM-00777> <A database error occurred.
javax.persistence.RollbackException: 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 "DMSWCC_IPM"."PREFERENCES"."SETTING" (actual: 288, maximum: 255)

Error Code: 12899
Call: UPDATE PREFERENCES SET SETTING = ? WHERE ((CONTEXT = ?) AND (USERGUID = ?))
bind => [3 parameters bound]
Query: UpdateObjectQuery(oracle.imaging.common.PreferenceItem@36ac9071)
at oracle.imaging.ImagingException.logException(ImagingException.java:255)
at oracle.imaging.ImagingException.initException(ImagingException.java:195)
at oracle.imaging.ImagingException.<init>(ImagingException.java:94)
at oracle.imaging.system.SystemManager.setPreference(SystemManager.java:172)
at oracle.imaging.system.SystemManager.setSystemPreference(SystemManager.java:103)
at oracle.imaging.config.IpmSystemConfig.saveValue(IpmSystemConfig.java:151)
at oracle.imaging.config.IpmSystemConfig.setInputDirectories(IpmSystemConfig.java:378)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:606)
at oracle.as.jmx.framework.standardmbeans.spi.OracleStandardEmitterMBean.doSetAttribute(OracleStandardEmitterMBean.java:900)

Changes

 

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