My Oracle Support Banner

WebCenter Content (WCC) Error: Java.Sql.Sqlexception: ORA-12899: Value too Large for Column "XXXX"."Indexerstate" (Doc ID 1338224.1)

Last updated on DECEMBER 10, 2018

Applies to:

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


The following error found in the WCC server log files:

java.sql.SQLException: ORA-12899: value too large for column "XXXX"."INDEXERSTATE"."Xabcd" (actual: 34, maximum: 30)

!$helperservice: data exception in INDEXERSTATE.RECORDWEBCHANGE_SUB IndexerState.IindexerState !csDbUnableToExecuteQuery,IndexerState.IindexerState(INSERT INTO IndexerState ...                                         (actual: 34\, maximum: 30)<br>!syExceptionType2,java.sql.SQLException,ORA-12899: value too large for column "WCMSTAG"."INDEXERSTATE"."XISBN" (actual: 34\, maximum: 30)<br> !csDbUnableToExecuteQuery,IndexerState.IindexerState(INSERT INTO IndexerState (iIndexGUID\,dIsWebFormat\,xPartitionId\,dExtension\,dProcessingState...

at intradoc.jdbc.JdbcWorkspace.handleSQLException(
at intradoc.jdbc.JdbcWorkspace.execute(
Caused by: java.sql.SQLException: ORA-12899: value too large for column "WCMSTAG"."INDEXERSTATE"."XISBN" (actual: 34, maximum: 30)

at oracle.jdbc.driver.DatabaseError.throwSqlException(
at oracle.jdbc.driver.T4CTTIoer.processError(
at oracle.jdbc.driver.T4CTTIoer.processError(
...   ... 16 more

Indexing aborted. Unable to index metadata only. This may indicate the collection is damaged. Indexing aborted. [ Details ]

An error has occurred. The stack trace below shows more information.

intradoc.common.ServiceException: !csIndexerMetaOnlyFailed
at intradoc.indexer.IndexerBulkLoader.handleIndexerResults(
at intradoc.indexer.IndexerBulkLoader.createBulkLoad(
at intradoc.indexer.IndexerBulkLoader.doWork(
at intradoc.indexer.Indexer.doIndexing(
at intradoc.indexer.Indexer.buildIndex(
at intradoc.server.IndexerMonitor.doIndexing(
at intradoc.server.IndexerMonitor$


 Passed value larger than the metadata field default size.


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

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