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

(Doc ID 553338.1)

Last updated on JUNE 08, 2017

Applies to:

Oracle Universal Content Management - Version: 10.1.3.3.1 and later   [Release: 10gR3 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

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