Bookshelf Home | Contents | Index | PDF |
Oracle Web Services On Demand Troubleshooting Guide > Error Codes: Causes and Solutions > SBL-EAI-13006This error code has no error symbol. Generic Error MessageInvalid operator: QueryExpression (SBL-EAI-13006). Causes and SolutionsThe query expression does not contain a valid operator. This error is often returned with error SBL-EAI-13002. Error MessageInvalid operator: like 'Customer%'(SBL-EAI-13006). Incorrect SOAP RequestIn 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"> <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> <ContactQueryPage_Input xmlns="urn:crmondemand/ws/ecbs/contact/"> <ListOfContact pagesize="5" startrownum="0" recordcountneeded="true"> <ContactType>like 'Customer%'</ContactType> Resolving Error SBL-EAI-13006Ensure 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 RequestTo 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"> <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> <ContactQueryPage_Input xmlns="urn:crmondemand/ws/ecbs/contact/"> <ListOfContact pagesize="5" startrownum="0" recordcountneeded="true"> |
Oracle Web Services On Demand Troubleshooting Guide | Copyright © 2014, Oracle and/or its affiliates. All rights reserved. Legal Notices. | |