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 APRIL 18, 2024
Applies to:
Oracle WebCenter Content: Imaging - Version 11.1.1.8.0 and laterInformation 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)
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
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |