My Oracle Support Banner

!csDbFieldAlreadyExists2,metadata - error - indexer Not Working after creating new metadata (or install component which creates new metadata) (Doc ID 2145203.1)

Last updated on AUGUST 06, 2018

Applies to:

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


On : version, Content Server

Indexer is not working in Webcenter content after Webcenter records adapter is configured for webcenter records management server.

Index aborted . Unable to modify collection table "IdcText1". Error occurred

[2016-05-25T14:33:08.633+02:00] [UCM_server1] [ERROR] [UCM-CS-000001] [oracle.ucm.idccs] [tid: index rebuild work] [userId: weblogic] [ecid: 73c555f506b4ee1c:2a2f6a47:154e7765d54:-8000-0000000000001d4a,1:18192] [APP: Oracle Universal Content Management - Content Server] general exception[[
intradoc.common.ServiceException: !csUnableToModifyTextCollectionTable,IdcText1
  at intradoc.indexer.OracleTextCollectionHandler.manageCollection(
  at intradoc.indexer.IndexerCollectionManager.doWork(
  at intradoc.indexer.Indexer.doIndexing(
  at intradoc.indexer.Indexer.buildIndex(
  at intradoc.server.IndexerMonitor.doIndexing(
  at intradoc.server.IndexerMonitor$
Caused by: !csDbFieldAlreadyExists2,xVitalPeriod
  at intradoc.jdbc.JdbcWorkspace.alterTable(
  at intradoc.indexer.OracleTextCollectionHandler.manageCollection(
  at intradoc.indexer.IndexerCollectionManager.doWork(
  ... 4 more

The issue can be reproduced at will with the following steps:
1. configured for webcenter records management server.
2. Rebuild collection id

The issue has the following business impact: indexer is not working
Due to this issue, users cannot use search.


 The customer had configured the Records Managements Adapter which automatically creates new metadata : Document:1353344.1 - What Metadata fields are affected when enabling the WCCREC/URM features


To view full details, 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 a vibrant support community of peers and Oracle experts.