My Oracle Support Banner

ORA-20000: Oracle Text error using Sitestudio 10g4 with Verity Search Engine (Doc ID 1089163.1)

Last updated on MAY 14, 2018

Applies to:

Oracle WebCenter Content - Version and later
Information in this document applies to any platform.
***Checked for relevance on 01-Aug-2013***


After upgrading from Sitestudio 10g3 to 10g4 a database error is received while loading the Sitestudio Assets in Site Studio Designer and on the 'View Web Site Objects Report' page.

Unable to execute service SS_GET_SITE_REPORT and function createResultSetSQL.
(System Error: Unable to create result set for query 'SELECT dDocName, dDocTitle, Max(Revisions.dID) AS dID, xWebsiteObjectType
FROM Revisions, DocMeta
WHERE ( ( DocMeta.dID = Revisions.dID ) AND
( ( ( CONTAINS( xWebsites, 'accessibility') > 0 ) ) OR ( ( xWebsiteSection LIKE 'accessibility:%' ) ) ) AND
( Revisions.dStatus<>'DELETED') )
AND (Revisions.dStatus='RELEASED' OR Revisions.dReleaseState in ('U', 'I'))
GROUP BY xWebsiteObjectType,dDocName,dDocTitle'. ORA-20000: Oracle Text error:
DRG-10599: Spalte ist nicht indiziert)
The service stack for this request is
--SS_GET_SITE_REPORT (**no captured values**) !csDbUnableToCreateResultSet,SELECT dDocName\, dDocTitle\, Max(Revisions.dID) AS dID\, xWebsiteObjectType
FROM Revisions\, DocMeta
WHERE ( ( DocMeta.dID = Revisions.dID ) AND
( ( ( CONTAINS( xWebsites\, 'accessibility') > 0 ) ) OR ( ( xWebsiteSection LIKE 'accessibility:%' ) ) ) AND
( Revisions.dStatus<>'DELETED') )
AND (Revisions.dStatus='RELEASED' OR Revisions.dReleaseState in ('U'\, 'I'))
GROUP BY xWebsiteObjectType\,dDocName\,dDocTitle!$ORA-20000: Oracle Text error:
DRG-10599: Spalte ist nicht indiziert

at intradoc.jdbc.JdbcWorkspace.handleSQLException(
at intradoc.jdbc.JdbcWorkspace.createResultSetSQL(
at intradoc.server.Service.createResultSetSQL(
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(
at sun.reflect.DelegatingMethodAccessorImpl.invoke(
at java.lang.reflect.Method.invoke(
at intradoc.common.IdcMethodHolder.invokeMethod(
at intradoc.common.ClassHelperUtils.executeMethodEx(
at intradoc.common.ClassHelperUtils.executeMethod(
at intradoc.server.Service.doCodeEx(
at intradoc.server.Service.doCode(
at intradoc.server.ServiceRequestImplementor.doAction(
at intradoc.server.Service.doAction(
at intradoc.server.ServiceRequestImplementor.doActions(
at intradoc.server.Service.doActions(
at intradoc.server.ServiceRequestImplementor.executeActions(
at intradoc.server.Service.executeActions(
at intradoc.server.ServiceRequestImplementor.doRequest(
at intradoc.server.Service.doRequest(
at intradoc.server.ServiceManager.processCommand(
Caused by: java.sql.SQLException: ORA-20000: Oracle Text error:
DRG-10599: Spalte ist nicht indiziert

at oracle.jdbc.driver.DatabaseError.throwSqlException(
at oracle.jdbc.driver.T4CTTIoer.processError(
at oracle.jdbc.driver.T4CTTIoer.processError(
at oracle.jdbc.driver.T4C8Oall.receive(
at oracle.jdbc.driver.T4CStatement.doOall8(
at oracle.jdbc.driver.T4CStatement.executeForRows(
at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(
at oracle.jdbc.driver.T4CStatement.executeMaybeDescribe(
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(
at oracle.jdbc.driver.OracleStatement.doScrollExecuteCommon(
at oracle.jdbc.driver.OracleStatement.doScrollStmtExecuteQuery(
at oracle.jdbc.driver.OracleStatement.executeQuery(
at intradoc.jdbc.JdbcWorkspace.createResultSetSQL(
... 20 more



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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.