My Oracle Support Banner

Content Server Analyzer File System Check Fails with ORA-00904 Error (Doc ID 553338.1)

Last updated on MAY 22, 2020

Applies to:

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

Symptoms

Content Server Analyzer errors out during the file system check with the following error:

Error checking filesystem. Unable to create result set for query
'SELECT dID, dExtension, dIsWebFormat, dIsPrimary
FROM Documents
WHERE Documents.dID >= 1000 AND Documents.dID <2000
AND Revisions.dID = DocMeta.dID
ORDER BY dSecurityGroup, dDocAccount, dDocType'.

ORA-00904: "DDOCTYPE": invalid identifier

 

 

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
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.