My Oracle Support Banner

Metadata indexing failing with "ORA-12899 or ORA-904" resulting in content items stuck in GenWWW after changing Metadata field type (Doc ID 1560366.1)

Last updated on FEBRUARY 03, 2019

Applies to:

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

Symptoms

 

After changing the metadata field type of an existing field ( Text to Long Text, or Text/Long Text to Memo), The following two cases are seen:

The issue can be replicated with following steps

1. On Configuration Manager applet, edit an existing field and change the field type.
(e.g. Text -> Long Text)

2. Click [Update Database Design] to apply the change to repository database.

3. Then, check in a content with the long text value to changed field
(For example in case of changing the type from Text to Long Text,
setting 31 chars or more (e.g. "aaaaaaa010aaaaaaa020aaaaaaa030aaaaaaa040aaaaaaa050"))

4. Checking the content information after check in
--> It stays GenWWW status and showing error "Indexing aborted on this content item." (NG: Case-1)
--> When the issue occurs, Content Server log shows the following error

 

Changes

 This symptom occurs after changed type of an existing field, e.g. Text -> Long Text

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


This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.