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

SBL-DAT-00500

This error code has no error symbol.

Generic Error Message

Method 'NextRecord' of business component 'RecordType' (integration component 'RecordType') for record with search specification '[Id] ="search_specification_ID"' returned the following error: "There were more rows than could be returned. Please refine your query to bring back fewer rows (SBL-DAT-00500)"

Causes and Solutions

One possible cause is that the child object being processed in the Web Services v1.0 request contains more than 10,000 records.

NOTE:  The ID returned in the error message might not match the provided ID in the request.

Error Message

Method 'NextRecord' of business component 'Contact Campaign' (integration component 'Campaign_Recipient') for record with search specification '[Id] ="ACSA-4GFGCG"' returned the following error: "There were more rows than could be returned. Please refine your query to bring back fewer rows (SBL-DAT-00500)"

Incorrect SOAP Request

In the following incorrect SOAP request, the intention is to delete a specific recipient from a specific campaign record, however, the number of recipients associated to this campaign is more than 10,000.

<?xml version="1.0" encoding="utf-16" standalone="no"?>

<soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">

   <soap:Body>

      <CampaignWS_CampaignDeleteChild_Input xmlns="urn:crmondemand/ws/campaign/10/2004">

         <ListOfCampaign>

            <Campaign>

               <CampaignId>1QA2-1JUM98</CampaignId>

               <ListOfRecipient>

                  <Recipient>

                     <CampaignContactId>1QA2-1K4FFX</CampaignContactId>

                  </Recipient>

               </ListOfRecipient>

            </Campaign>

         </ListOfCampaign>

      </CampaignWS_CampaignDeleteChild_Input>

   </soap:Body>

</soap:Envelope>

Resolving Error SBL-DAT-00500

When you want to submit a request for a child object, and the number of child records for the child object is greater than 10,000, there are two options:

• Use Web Services v2.0 instead of Web Services v1.0 to perform the same request.

  NOTE:  This is the recommended action.

• Use the reverse relationship in Web Services v1.0 or v2.0.

  If you are querying for the child record of a parent record using the Web service for the parent object, you can instead use the reverse relationship by using the Web service for the child object to retrieve the records. For example, a recipient for a campaign can also be a contact with a list of campaign recipients. However, you can do this only if it is applicable for the object, and if the relationships are exposed.

Correcting the SOAP Request

To correct the SOAP request, use the reverse relationship in Web Services v2.0 of Contact-Campaign Recipient child object because Campaign Recipient for Campaign Web Services v2.0 is unavailable:

<?xml version="1.0" encoding="utf-16" standalone="no"?>

<soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">

   <soap:Body>

      <ContactExecute_Input xmlns="urn:crmondemand/ws/ecbs/contact/10/2004">

         <ListOfContact>

            <Contact operation="skipnode">

               <Id>1QA2-11V4PJ</Id>

               <ListOfCampaignRecipient>

                  <CampaignRecipient operation="delete">

                      <CampaignId>1QA2-1JUM98</CampaignId>

                  </CampaignRecipient>

               </ListOfCampaignRecipient>

            </Contact>

         </ListOfContact>

      </ContactExecute_Input>

   </soap:Body>

</soap:Envelope>