My Oracle Support Banner

ORA-904: "DDOCLASTMODIFIEDDATE": Invalid Identifier When Calling GET_SEARCH_RESULTS (Doc ID 1366388.1)

Last updated on JUNE 07, 2018

Applies to:

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


Using Content Server on Linux

Content Server connects to an Oracle 10.2 database with Search Engine set to DATABASE.METADATA

When performing a call to the GET_SEARCH_RESULTS and sorting the result set on the last modified date, following error gets raised:

Error Unable to retrieve search results. Error occurred while processing. Unable to return results. Unable to create the result set for query
FROM (SELECT dStatus, dDocName, dDocTitle, Revisions.dDocType, doc_types.dDescription, dRevisionID, dSecurityGroup, dDocAuthor, dDocAccount, dRevLabel, dFormat, dOriginalName, LOWER(dExtension) AS dExtension, dWebExtension, dInDate, dOutDate, dPublishType, dRendition1, dRendition2, dFileSize AS VaultFileSize, DENSE_RANK() OVER (PARTITION BY Revisions.dDocName ORDER BY Revisions.dID desc) last_rev_topN, DocMeta.*
FROM Revisions, DocMeta, Documents, (select dDocType as ddoctype_name, dDescription from DocTypes) doc_types
WHERE Revisions.dID=DocMeta.dID
AND Revisions.dID=Documents.dID
AND doc_types.ddoctype_name = Revisions.dDocType
AND dReleaseState IN ('N', 'R', 'Y', 'U', 'I', 'E')
AND ((( xTestfield LIKE '219' )))
AND dIsPrimary = 1
) a
WHERE a.last_rev_topN=1
ORDER BY dDocLastModifiedDate Desc'. ORA-00904: "DDOCLASTMODIFIEDDATE": invalid identifier
java.sql.SQLSyntaxErrorException: ORA-00904: "DDOCLASTMODIFIEDDATE": invalid identifier.

GET_SEARCH_RESULTS is called with following parameters:

&QueryText=xTestfield <matches> `219`


To view full details, 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 a vibrant support community of peers and Oracle experts.