Site Studio Designer Error ORA-20000: "Oracle Text error: DRG-10599: column is not indexed" (Doc ID 730298.1)

Last updated on APRIL 26, 2017

Applies to:

Oracle WebCenter Content - Version 7.5.1 to 10.1.3.4 [Release Stellent to 10gR3]
Information in this document applies to any platform.
Update Date 30-NOV-20011: Changed product name from UCM to WebCenter Content. Refer to Product Name Changes for WebCenter and Former ECM products for more information.


Symptoms

Content Server search index is set to metadata.  Searches with Site Studio 7.x assets (added in Site Studio Designer) causes an error.

 SELECT IdcColl2.dID, dDocName, dDocTitle, dDocType, dRevisionID, dSecurityGroup, dDocAuthor, dDocAccount, dRevLabel, dFormat, dOriginalName, dExtension, dWebExtension, dInDate, dOutDate, dPublishType, dRendition1, dRendition2, VaultFileSize, WebFileSize, URL, dFullTextFormat, dFullTextCharset, DocMeta.*
FROM IdcColl2, DocMeta
WHERE IdcColl2.dID=DocMeta.dID AND ((((( (CONTAINS(xWebsites, 'sterin')> 0) )) AND ( xWebsiteObjectType LIKE 'Native Document' )))) ORDER BY dDocName ASC
systemdatabase 07.29 09:47:37.765 IdcServerThread-161 !csDbUnableToCreateResultSet,SELECT IdcColl2.dID\, dDocName\, dDocTitle\, dDocType\, dRevisionID\, dSecurityGroup\, dDocAuthor\, dDocAccount\, dRevLabel\, dFormat\, dOriginalName\, dExtension\, dWebExtension\, dInDate\, dOutDate\, dPublishType\, dRendition1\, dRendition2\, VaultFileSize\, WebFileSize\, URL\, dFullTextFormat\, dFullTextCharset\, DocMeta.*
FROM IdcColl2\, DocMeta
WHERE IdcColl2.dID=DocMeta.dID AND ((((( (CONTAINS(xWebsites\, 'sterin')> 0) )) AND ( xWebsiteObjectType LIKE 'Native Document' )))) ORDER BY dDocName ASC!$

ORA-20000: Oracle Text error:
DRG-10599: column is not indexed

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