Oracle Text Error - Search Fails After Adding A New Date Field (Doc ID 1168555.1)

Last updated on MAY 09, 2023

Applies to:

Symptoms

Searching is throwing an error after adding a new metadata date field.

Content Server Request Failed
Unable to retrieve search results. Error generated when executing query 'idccontenttrue'. Unable to execute callable query 'CotsSearchQuery'. ORA-20000: Oracle Text error:
DRG-50857: oracle error in ctx_query.result_set
ORA-20000: Oracle Text error:
DRG-12605: datatype of column 91 in COLUMNS list is not supported

ORA-06512: at "CTXSYS.DRUE", line 160
ORA-06512: at "CTXSYS.CTX_QUERY", line 788
ORA-06512: at "ACSDEV_ADMIN.CONTENT_SEARCH", line 116
ORA-06512: at line 1
[ Details ]
intradoc.common.ServiceException: !csOracleTextErrorExecutingQuery,idccontenttrue!csDbUnableToExecuteCallableQuery,CotsSearchQuery!$ORA-20000: Oracle Text error: DRG-50857: oracle error in ctx_query.result_set ORA-20000: Oracle Text error: DRG-12605: datatype of column 91 in COLUMNS list is not supported ORA-06512: at "CTXSYS.DRUE"\, line 160 ORA-06512: at "CTXSYS.CTX_QUERY"\, line 788 ORA-06512: at "ACSDEV_ADMIN.CONTENT_SEARCH"\, line 116 ORA-06512: at line 1 at intradoc.server.SearchService.retrieveSearchInfo(SearchService.java:1349) at intradoc.server.SearchService.doLocalSearch(SearchService.java:1049) at intradoc.server.SearchService.getSearchResults(SearchService.java:531) at sun.reflect.GeneratedMethodAccessor27.invoke(Unknown Source) 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:1360) at intradoc.server.Service.doAction(Service.java:452) at intradoc.server.ServiceRequestImplementor.doActions(ServiceRequestImplementor.java:1201) at intradoc.server.Service.doActions(Service.java:447) at intradoc.server.ServiceRequestImplementor.executeActions(ServiceRequestImplementor.java:1121) 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)

Changes

Added a new date Metadata field to the Content Server.

Cause

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