Error Using Multisort Component with OracleTextSearch: "Unable to execute callable query 'CotsSearchQuery'."

(Doc ID 987657.1)

Last updated on MAY 19, 2017

Applies to:

Oracle WebCenter Content - Version 10.1.3.3.1 to 10.1.3.5.0 [Release 10gR3]
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

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