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

Last updated on SEPTEMBER 08, 2017

Applies to:

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

Symptoms

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>
intradoc.data.DataException: !csDbUnableToExecuteQuery,IndexerState.IindexerState(INSERT INTO IndexerState (iIndexGUID\,dIsWebFormat\,xPartitionId\,dExtension\,dProcessingState...

at intradoc.jdbc.JdbcWorkspace.handleSQLException(JdbcWorkspace.java:2371)
at intradoc.jdbc.JdbcWorkspace.execute(JdbcWorkspace.java:650)
...
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(DatabaseError.java:112)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)
...   ... 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.

!csIndexerAbortedMsg!csIndexerMetaOnlyFailed
intradoc.common.ServiceException: !csIndexerMetaOnlyFailed
at intradoc.indexer.IndexerBulkLoader.handleIndexerResults(IndexerBulkLoader.java:580)
at intradoc.indexer.IndexerBulkLoader.createBulkLoad(IndexerBulkLoader.java:372)
at intradoc.indexer.IndexerBulkLoader.doWork(IndexerBulkLoader.java:165)
at intradoc.indexer.Indexer.doIndexing(Indexer.java:439)
at intradoc.indexer.Indexer.buildIndex(Indexer.java:348)
at intradoc.server.IndexerMonitor.doIndexing(IndexerMonitor.java:1012)
at intradoc.server.IndexerMonitor$4.run(IndexerMonitor.java:832)

Changes

 Passed value larger than the metadata field default size.

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