Using the OracleTextSearch component - ORA-00942 error when searching: "Unable to retrieve the columns for the database table 'IdcText2'" (Doc ID 742254.1)

Last updated on AUGUST 14, 2024

Applies to:

Symptoms

You are using Oracle Text 11g on Oracle Database 11g for your search collection.  You have the Oracle Text Search component installed to accomplish this.

When trying to perform a search, you get the following error:

Unable to retrieve search results. Error generated when executing query 'idccontenttrue'. Unable to retrieve the columns for the database table 'IdcText2'. ORA-00942: table or view does not exist
[ Details ]
intradoc.common.ServiceException:!csOracleTextErrorExecutingQuery,idccontenttrue!csDbUnableToPerformAction_getColumns,IdcText2!$ORA-00942: table or view does not exist at
intradoc.server.SearchService.retrieveSearchInfo(SearchService.java:1315) at
intradoc.server.SearchService.doLocalSearch(SearchService.java:1045) at
intradoc.server.SearchService.getSearchResults(SearchService.java:528) 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:461) at
intradoc.common.ClassHelperUtils.executeMethodEx(ClassHelperUtils.java:128) at
intradoc.common.ClassHelperUtils.executeMethod(ClassHelperUtils.java:113) at
intradoc.server.Service.doCodeEx(Service.java:505) at
intradoc.server.Service.doCode(Service.java:470) at
intradoc.server.ServiceRequestImplementor.doAction(ServiceRequestImplementor.java:1350) at
intradoc.server.Service.doAction(Service.java:450) at
intradoc.server.ServiceRequestImplementor.doActions(ServiceRequestImplementor.java:1191) at
intradoc.server.Service.doActions(Service.java:445) at
intradoc.server.ServiceRequestImplementor.executeActions(ServiceRequestImplementor.java:1111) at
intradoc.server.Service.executeActions(Service.java:431) at
intradoc.server.ServiceRequestImplementor.doRequest(ServiceRequestImplementor.java:632) at
intradoc.server.Service.doRequest(Service.java:1709) at
intradoc.server.ServiceManager.processCommand(ServiceManager.java:357) at
intradoc.server.IdcServerThread.run(IdcServerThread.java:195)




.

Cause

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