My Oracle Support Banner

Error Using Multisort Component with OracleTextSearch: "Unable to execute callable query 'CotsSearchQuery'." (Doc ID 987657.1)

Last updated on MAY 22, 2020

Applies to:

Oracle WebCenter Content - Version 10.0 and later
Information in this document applies to any platform.

Symptoms

When selecting multiple sort fields using the MultiSort component along with the OracleTextSearch component, the following error is returned:

Unable to retrieve search results. Error generated when executing query '((((({POCS} WITHIN dDocType) and ({1} WITHIN xCIG_ALT_AGENCY) and ({1} WITHIN xCIG_ALT_FUNCTION) and ({1} WITHIN xCIG_ALT_ACTIVITY)))))'. 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-11131: Error from Oracle XML parser: LPX-00222: error received from SAX callback function
DRG-13600: Syntax error in the result set descriptor
DRG-10856: SDATA section XEMPLOYEELASTNAME does not exist

ORA-06512: at "CTXSYS.DRUE", line 160
ORA-06512: at "CTXSYS.CTX_QUERY", line 772
ORA-06512: at "UCMOWNER.CONTENT_SEARCH", line 116
ORA-06512: at line 1
[ Details ]
intradoc.common.ServiceException: !csOracleTextErrorExecutingQuery,((((({POCS} WITHIN dDocType) and ({1} WITHIN xCIG_ALT_AGENCY) and ({1} WITHIN xCIG_ALT_FUNCTION) and ({1} WITHIN xCIG_ALT_ACTIVITY)))))!csDbUnableToExecuteCallableQuery,CotsSearchQuery!$ORA-20000: Oracle Text error:
DRG-50857: oracle error in ctx_query.result_set
ORA-20000: Oracle Text error:
DRG-11131: Error from Oracle XML parser: LPX-00222: error received from SAX callback function
DRG-13600: Syntax error in the result set descriptor
DRG-10856: SDATA section XEMPLOYEELASTNAME does not exist

ORA-06512: at "CTXSYS.DRUE"\, line 160
ORA-06512: at "CTXSYS.CTX_QUERY"\, line 772
ORA-06512: at "UCMOWNER.CONTENT_SEARCH"\, line 116
ORA-06512: at line 1

at intradoc.server.SearchService.retrieveSearchInfo(SearchService.java:1321)
at intradoc.server.SearchService.doLocalSearch(SearchService.java:1047)
at intradoc.server.SearchService.getSearchResults(SearchService.java:530)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
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 multisort.MultiSortHandler.getSearchResults(MultiSortHandler.java:97)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at intradoc.common.IdcMethodHolder.invokeMethod(ClassHelperUtils.java:617)
at intradoc.common.ClassHelperUtils.executeMethodReportStatus(ClassHelperUtils.java:293)
at intradoc.server.ServiceHandler.executeAction(ServiceHandler.java:79)
at intradoc.server.Service.doCodeEx(Service.java:490)
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)

Cause

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
Symptoms
Cause
Solution


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