Skip to Main Content

Application Development Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

UCM 10gR3 - Error

815950Oct 21 2011 — edited Oct 21 2011
My 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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 18 2011
Added on Oct 21 2011
5 comments
320 views