My Oracle Support Banner

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

Last updated on JUNE 28, 2023

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


Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.