Bookshelf Home | Contents | Index | PDF | ![]() ![]() |
Oracle Web Services On Demand Troubleshooting Guide > Error Codes: Causes and Solutions > SBL-EAI-13005This error code has no error symbol. Generic Error MessageUnmatched quotes: LiteralData (SBL-EAI-13005). Causes and SolutionsQuotation marks are missing from the query value. This error is often returned with error SBL-EAI-13002. Error MessageUnmatched quotes: 'Customer'' (SBL-EAI-13005). Incorrect SOAP RequestIn the following incorrect SOAP request, the quotation marks in the ContactType query expression do not match because there are only three quotation marks in the expression: <?xml version="1.0" encoding="UTF-8"?> <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>='Customer''</ContactType> Resolving Error SBL-EAI-13005Ensure that all query expressions in the Web service request have quotation marks that enclose literal data. Literal data must be enclosed in single quotation marks. If you want to use a single quotation mark within a literal, place another single quotation mark immediately beside that quotation mark. For more information on query syntax, see Oracle Web Services On Demand Guide. Correcting the SOAP RequestTo correct the SOAP request, the quotation marks in the ContactType query expression must match. The query looks for ContactType = Customer" so you must add another quotation mark to the query expression: <?xml version="1.0" encoding="UTF-8"?> <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. | |