Automatic update failing (Doc ID 2179248.1)

Last updated on SEPTEMBER 07, 2016

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 <> 'Act142' AND
indexer/5 09.02 13:53:54.271 index update work dSecurityGroup <> 'CCIS' AND
indexer/5 09.02 13:53:54.271 index update work (xWebsites = 'mydpw' OR
indexer/5 09.02 13:53:54.271 index update work xWebsites = 'mydpw\,DPW' OR
indexer/5 09.02 13:53:54.271 index update work xWebsites = 'DPW\,mydpw')') AND (Revisions.dPublishState is null OR Revisions.dPublishState = '') AND dIndexerState = 'A'!$ORA-00907: missing right parenthesis

 

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