Oracle Web Services On Demand Troubleshooting Guide > Error Codes: Causes and Solutions >

SBL-EAI-13006

This error code has no error symbol.

Generic Error Message

Invalid operator: QueryExpression (SBL-EAI-13006).

Causes and Solutions

The query expression does not contain a valid operator. This error is often returned with error SBL-EAI-13002.

Error Message

Invalid operator: like 'Customer%'(SBL-EAI-13006).

Incorrect SOAP Request

In the following ContactType query expression, like is an invalid operator.

<?xml version="1.0" encoding="UTF-8" standalone="no"?>

<soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:wsse="http://docs.oasis-open.org/wss/2004/01/oasis-200401-wss-wssecurity-secext-1.0.xsd" xmlns:xsd="http://www.w3.org/2001/XMLSchema">

   <soap:Header>

      <wsse:Security>

         <wsse:UsernameToken>

            <wsse:Username>%%%USERNAME%%%</wsse:Username>

            <wsse:Password Type="http://docs.oasis-open.org/wss/2004/01/oasis-200401-wss-username-token-profile-1.0#PasswordText">%%%PASSWORD%%%</wsse:Password>

         </wsse:UsernameToken>

      </wsse:Security>

   </soap:Header>

   <soap:Body>

      <ContactQueryPage_Input xmlns="urn:crmondemand/ws/ecbs/contact/">

         <ListOfContact pagesize="5" startrownum="0" recordcountneeded="true">

            <Contact>

               <ContactFirstName />

               <ContactType>like 'Customer%'</ContactType>

            </Contact>

         </ListOfContact>

      </ContactQueryPage_Input>

   </soap:Body>

</soap:Envelope>

Resolving Error SBL-EAI-13006

Ensure that all query expressions in the request use valid operators. Operators are case-sensitive. For more information on valid query operators, see Oracle Web Services On Demand Guide.

Correcting the SOAP Request

To correct the SOAP request, replace the like operator with LIKE:

<?xml version="1.0" encoding="UTF-8" standalone="no"?>

<soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:wsse="http://docs.oasis-open.org/wss/2004/01/oasis-200401-wss-wssecurity-secext-1.0.xsd" xmlns:xsd="http://www.w3.org/2001/XMLSchema">

   <soap:Header>

      <wsse:Security>

         <wsse:UsernameToken>

            <wsse:Username>%%%USERNAME%%%</wsse:Username>

            <wsse:Password Type="http://docs.oasis-open.org/wss/2004/01/oasis-200401-wss-username-token-profile-1.0#PasswordText">%%%PASSWORD%%%</wsse:Password>

         </wsse:UsernameToken>

      </wsse:Security>

   </soap:Header>

   <soap:Body>

      <ContactQueryPage_Input xmlns="urn:crmondemand/ws/ecbs/contact/">

         <ListOfContact pagesize="5" startrownum="0" recordcountneeded="true">

            <Contact>

               <ContactFirstName />

               <ContactType>LIKE 'Customer%'</ContactType>

            </Contact>

         </ListOfContact>

      </ContactQueryPage_Input>

   </soap:Body>

</soap:Envelope>