Calling GET_SEARCH_RESULTS Service via SOAP Fails With "Unable to retrieve search results. Parsing error at character NN in query" (Doc ID 952130.1)

Last updated on MAY 17, 2017

Applies to:

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

Symptoms

SOAP calls to the GET_SEARCH_RESULTS service are failing with error "Unable to retrieve search
results. Parsing error at character NN in query".

This can be reproduced using custom code or the provided samples:
1. Edit $ORACLE_HOME/custom/WsdlGenerator/samples/Java/SoapClient/soap.cfg to suit your environment
2. Compile $ORACLE_HOME/custom/WsdlGenerator/samples/Java/SoapClient/SoapClient.java
3. Execute SoapClient ...

[oracle@mylinux-pc SoapClient]$ java -classpath . SoapClient -c soap.cfg -x get_search_results.xml -l get_search_results.txt
Sending upload request...
POST /idc/idcplg HTTP/1.0
Content-Type:  text/xml; charset=utf-8
Content-length:  387
SOAPAction:  ContentServerRequest
Connection: close
Authorization: Basic c3lzYWRtaW46aWRj

<?xml version='1.0' ?>
<SOAP-ENV:Envelope xmlns:SOAP-ENV="http://schemas.xmlsoap.org/soap/envelope/">
<SOAP-ENV:Body>
<idc:service xmlns:idc="http://www.stellent.com/IdcService/" IdcService="GET_SEARCH_RESULTS">
<idc:document>
<idc:field name="QueryText">
dDocType &lt;Substring&gt; &quot;ADSALES&quot;
</idc:field>
</idc:document>
</idc:service>
</SOAP-ENV:Body>
</SOAP-ENV:Envelope>


Receving response...
HTTP/1.1 200 OK
Date: Fri, 09 Oct 2009 00:59:32 GMT
Server: Oracle-Application-Server-10g/10.1.3.1.0 Oracle-HTTP-Server
Set-Cookie: IntradocLoginState=1; path=/;
Content-type: text/xml; charset=utf-8
Content-Length: 3230
Connection: close

<?xml version='1.0' encoding='utf-8' ?>
<SOAP-ENV:Envelope xmlns:SOAP-ENV="http://schemas.xmlsoap.org/soap/envelope/">
<SOAP-ENV:Body>
<idc:service xmlns:idc="http://www.stellent.com/IdcService/" IdcService="GET_SEARCH_RESULTS">
<idc:document SearchProviders="idc" dUser="sysadmin">
<idc:field name="EnterpriseSearchMaxRows">4</idc:field>
<idc:field name="IsOracle">1</idc:field>
<idc:field name="StatusMessage">Unable to retrieve search results. Parsing error at character 21 in query: &quot;dDocType &lt;Substring&gt; &quot;ADSALES&quot;&quot;</idc:field>
<idc:field name="UnparsedQueryText">dDocType <Substring> "ADSALES"</idc:field>
<idc:field name="ErrorStackTrace">intradoc.common.ServiceException: Parsing error at character 21 in query: "
dDocType &lt;Substring&gt; &quot;ADSALES&quot;&quot;
        at intradoc.search.UniversalSearchQueryParser.parseQueryEx(UniversalSearchQueryParser.java:871)
        at intradoc.search.UniversalSearchQueryParser.parseQuery(UniversalSearchQueryParser.java:164)
        at intradoc.search.UniversalSearchQueryParser.parse(UniversalSearchQueryParser.java:155)
        at intradoc.search.DBSearchConfigCompanion.fixUpAndValidateQuery(DBSearchConfigCompanion.java:176)
        at intradoc.shared.CommonSearchConfig.fixUpAndValidateQuery(CommonSearchConfig.java:1473)
        at intradoc.server.SearchService.prepareLocalSearch(SearchService.java:1005)
        at intradoc.server.SearchService.getSearchResults(SearchService.java:527)
        at sun.reflect.GeneratedMethodAccessor17.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:461)
        at intradoc.common.ClassHelperUtils.executeMethodEx(ClassHel
perUtils.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)
</idc:field>
<idc:field name="QueryText">dDocType <Substring> &quot
;ADSALES&quot;</idc:field>
<idc:field name="StatusCode">-1</idc:field>
<idc:field name="FullRequest">&QueryText=dDocType+%3cSubstring%3e+%22ADSALES%22</idc:field>
<idc:field name="OriginalQueryText">dDocType+%3cSubstring%3e+%22ADSALES%22</idc:field>
<idc:field name="queryDefinitionLabel">DATABASE.METADATA.ORACLE</idc:field>
</idc:document>
</idc:service>
</SOAP-ENV:Body>
</SOAP-ENV:Envelope>





 

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