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

SBL-EAI-04378

This error code has the error symbol: IDS_ERR_EAI_SA_BC_NO_DATA.

Generic Error Message

No rows retrieved corresponding to the business component 'ObjectName' (SBL-EAI-04378).

Causes and Solutions

A record cannot be found in Oracle CRM On Demand.

Error Message

No rows retrieved corresponding to the business component 'Contact' (SBL-EAI-04378).

Incorrect SOAP Request

In the following incorrect SOAP request, the contact with ID ADSA-ABCDE does not exist in Oracle CRM On Demand:

<?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>

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

         <ListOfContact>

            <Contact>

               <Id>ADSA-ABCDE</Id>

            </Contact>

         </ListOfContact>

      </ContactDelete_Input>

   </soap:Body>

</soap:Envelope>

Resolving Error SBL-EAI-04378

To resolve this error, you must ensure that the record exists in Oracle CRM On Demand with the exact user key values as specified in the SOAP request. User key values must have the same spelling as the values stored in Oracle CRM On Demand. The values are case sensitive.

Search for the record through the Oracle CRM On Demand UI and invoke a QueryPage request to determine the user key values for the record.

Correcting the SOAP Request

To correct the SOAP request, ensure that the record exists in Oracle CRM On Demand and modify the Web service request to specify the correct record ID in Oracle CRM On Demand:

<?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>

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

         <ListOfContact>

            <Contact>

               <Id>ADSA-96BLW7</Id>

            </Contact>

         </ListOfContact>

      </ContactDelete_Input>

   </soap:Body>

</soap:Envelope>