Asset search index update fails with "Failed to delete IndexRow..." causing duplicate entries in the index (Doc ID 1966430.1)

Last updated on NOVEMBER 03, 2016

Applies to:

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

Symptoms

Duplicate entries for the same asset are being created in the lucene search index, due to a failed index update when deleting an asset, followed by a successful reinsertion of the new index item for the same asset.

For example, an asset edit/save in the UI triggered a reindex:

[2014-11-12 11:06:26,588 GMT] [DEBUG] [Thread-737] [com.fatwire.search.lucene] Indexing using working folder /opt/webcenter/shared-cms/lucene
[2014-11-12 11:06:26,588 GMT] [DEBUG] [Thread-737] [com.fatwire.search.lucene] Index exists at /opt/webcenter/shared-cms/lucene/Global
[2014-11-12 11:06:26,618 GMT] [DEBUG] [Thread-737] [com.fatwire.search.lucene] Deleting data IndexRow[ field name=AssetType_Description,IndexData[ name=AssetType_Description
...
[2014-11-12 11:06:27,620 GMT] [ERROR] [Thread-737] [com.fatwire.search.lucene] Failed to delete IndexRow[ field name=AssetType_Description,IndexData[ name=AssetType_Description
...
[2014-11-12 11:06:27,620 GMT] [DEBUG] [Thread-737] [com.fatwire.search.lucene] Number of documents deleted 0
[2014-11-12 11:06:27,635 GMT] [DEBUG] [Thread-737] [com.fatwire.search.lucene] Adding IndexRow[ field name=AssetType_Description,IndexData[ name=AssetType_Description data=Teaser ...
[2014-11-12 11:06:27,638 GMT] [DEBUG] [Thread-737] [com.fatwire.search.lucene] Number of documents added/updated 1


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