UCM 10gR3 - Error
815950Oct 21 2011 — edited Oct 21 2011My content server log is populated with following error:
Indexing aborted. Unable to index metadata only. This may indicate the collection is damaged. Indexing aborted
Moreever, I have checked soem documents and am not able to search them either by publish date or directly by content id in uick search..
Console output from the Content Server is as follow:
at intradoc.indexer.IndexerBulkLoader.createBulkLoad(IndexerBulkLoader.java:370)
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)
Caused by: java.sql.SQLException: ORA-12899: value too large for column "UCM"."IDCCOLL1"."DDOCTITLE" (actual: 115, maximum: 80)
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)
at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:745)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:219)
at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:970)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1190)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3370)
at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3454)
at intradoc.jdbc.JdbcWorkspace.execute(JdbcWorkspace.java:635)
... 12 more
systemdatabase 10.21 06:10:30.462 index update work rollback tran
indexer 10.21 06:10:30.462 index update work Error while inserting, roll back transaction.
systemdatabase 10.21 06:10:30.462 index update work Connection with id of 'index update work.9' is removed from active connections with key of 'index update work'.
systemdatabase 10.21 06:10:30.462 index update work release pool connection
indexer 10.21 06:10:30.462 index update work !csDbUnableToExecuteQuery,IcollectionIndexMeta1!$ORA-12899: value too large for column "UCM"."IDCCOLL1"."DDOCTITLE" (actual: 115\, maximum: 80)
-exception stack
intradoc.common.ServiceException: !csDbUnableToExecuteQuery,IcollectionIndexMeta1!$ORA-12899: value too large for column "UCM"."IDCCOLL1"."DDOCTITLE" (actual: 115\, maximum: 80)
at intradoc.indexer.DatabaseFullTextHandler.doUpload(DatabaseFullTextHandler.java:221)
at intradoc.indexer.DatabaseFullTextHandler.executeIndexer(DatabaseFullTextHandler.java:133)
at intradoc.indexer.IndexerExecution.executeIndexer(IndexerExecution.java:561)
at intradoc.indexer.IndexerDriverAdaptor.executeIndexer(IndexerDriverAdaptor.java:141)
at intradoc.indexer.DocIndexerAdaptor.indexList(DocIndexerAdaptor.java:208)
at intradoc.indexer.DocIndexerAdaptor.finishIndexing(DocIndexerAdaptor.java:130)
at intradoc.indexer.IndexerBulkLoader.createBulkLoad(IndexerBulkLoader.java:370)
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)
Caused by: intradoc.data.DataException: !csDbUnableToExecuteQuery,IcollectionIndexMeta1!$ORA-12899: value too large for column "UCM"."IDCCOLL1"."DDOCTITLE" (actual: 115\, maximum: 80)
at intradoc.jdbc.JdbcWorkspace.handleSQLException(JdbcWorkspace.java:2371)
at intradoc.jdbc.JdbcWorkspace.execute(JdbcWorkspace.java:650)
at intradoc.indexer.DatabaseFullTextHandler.doUpload(DatabaseFullTextHandler.java:212)
... 11 more
Caused by: java.sql.SQLException: ORA-12899: value too large for column "UCM"."IDCCOLL1"."DDOCTITLE" (actual: 115, maximum: 80)
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)
at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:745)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:219)
at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:970)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1190)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3370)
at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3454)
at intradoc.jdbc.JdbcWorkspace.execute(JdbcWorkspace.java:635)
... 12 more
If you are aware of the issue please help me out!!
Edited by: Oracle WCI on Oct 21, 2011 4:50 PM