Content Server Analyzer File System Check Fails with ORA-00904 Error

(Doc ID 553338.1)

Last updated on DECEMBER 15, 2017

Applies to:

Oracle Universal Content Management - Version: and later   [Release: 10gR3 and later ]
Information in this document applies to any platform.


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



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