My Oracle Support Banner

Automatic update failing (Doc ID 2179248.1)

Last updated on SEPTEMBER 21, 2023

Applies to:

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

Symptoms

Automatic update cycle started failing

Caused by: intradoc.data.DataException: !csDbUnableToCreateResultSet,SELECT DISTINCT Revisions.dRevClassID

indexer/5 09.02 13:53:54.271 index update work FROM Revisions\, DocMeta\, Documents
indexer/5 09.02 13:53:54.271 index update work WHERE Revisions.dID=DocMeta.dID AND Revisions.dID=Documents.dID
indexer/5 09.02 13:53:54.271 index update work AND Revisions.dStatus='DELETED' AND Documents.dIsPrimary <> 0
indexer/5 09.02 13:53:54.271 index update work AND (dDocType <> '<DOCTYPE>' AND
indexer/5 09.02 13:53:54.271 index update work dSecurityGroup <> '<SECURITY GROUP>' AND
indexer/5 09.02 13:53:54.271 index update work (xWebsites = '<WEBSITE>' OR
indexer/5 09.02 13:53:54.271 index update work xWebsites = '<WEBSITE\,ABC>' OR
indexer/5 09.02 13:53:54.271 index update work xWebsites = 'ABC\,myabc')') AND (Revisions.dPublishState is null OR Revisions.dPublishState = '') AND dIndexerState = 'A'!$ORA-00907: missing right parenthesis

 

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.