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

Last updated on MAY 03, 2017

Applies to:

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

Symptoms


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**)
intradoc.data.DataException: !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(JdbcWorkspace.java:2356)
at intradoc.jdbc.JdbcWorkspace.createResultSetSQL(JdbcWorkspace.java:806)
at intradoc.server.Service.createResultSetSQL(Service.java:3259)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:585)
at intradoc.common.IdcMethodHolder.invokeMethod(ClassHelperUtils.java:617)
at intradoc.common.ClassHelperUtils.executeMethodEx(ClassHelperUtils.java:279)
at intradoc.common.ClassHelperUtils.executeMethod(ClassHelperUtils.java:264)
at intradoc.server.Service.doCodeEx(Service.java:507)
at intradoc.server.Service.doCode(Service.java:472)
at intradoc.server.ServiceRequestImplementor.doAction(ServiceRequestImplementor.java:1353)
at intradoc.server.Service.doAction(Service.java:452)
at intradoc.server.ServiceRequestImplementor.doActions(ServiceRequestImplementor.java:1194)
at intradoc.server.Service.doActions(Service.java:447)
at intradoc.server.ServiceRequestImplementor.executeActions(ServiceRequestImplementor.java:1114)
at intradoc.server.Service.executeActions(Service.java:433)
at intradoc.server.ServiceRequestImplementor.doRequest(ServiceRequestImplementor.java:635)
at intradoc.server.Service.doRequest(Service.java:1707)
at intradoc.server.ServiceManager.processCommand(ServiceManager.java:359)
at intradoc.server.IdcServerThread.run(IdcServerThread.java:197)
Caused by: java.sql.SQLException: ORA-20000: Oracle Text error:
DRG-10599: Spalte ist nicht indiziert

at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)
at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:743)
at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:207)
at oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:946)
at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1060)
at oracle.jdbc.driver.T4CStatement.executeMaybeDescribe(T4CStatement.java:830)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1124)
at oracle.jdbc.driver.OracleStatement.doScrollExecuteCommon(OracleStatement.java:4051)
at oracle.jdbc.driver.OracleStatement.doScrollStmtExecuteQuery(OracleStatement.java:4191)
at oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java:1279)
at intradoc.jdbc.JdbcWorkspace.createResultSetSQL(JdbcWorkspace.java:786)
... 20 more

 

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