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 MARCH 08, 2017

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

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