Bookshelf Home | Contents | Index | PDF | ![]() ![]() |
Oracle Web Services On Demand Troubleshooting Guide > Error Codes: Causes and Solutions > SBL-DAT-00500This error code has no error symbol. Generic Error MessageMethod '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 SolutionsOne 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 MessageMethod '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 RequestIn 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"> <CampaignWS_CampaignDeleteChild_Input xmlns="urn:crmondemand/ws/campaign/10/2004"> <CampaignId>1QA2-1JUM98</CampaignId> <CampaignContactId>1QA2-1K4FFX</CampaignContactId> </CampaignWS_CampaignDeleteChild_Input> Resolving Error SBL-DAT-00500When 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:
Correcting the SOAP RequestTo 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"> <ContactExecute_Input xmlns="urn:crmondemand/ws/ecbs/contact/10/2004"> <Contact operation="skipnode"> <CampaignRecipient operation="delete"> |
![]() |
![]() ![]() |
Oracle Web Services On Demand Troubleshooting Guide | Copyright © 2014, Oracle and/or its affiliates. All rights reserved. Legal Notices. | |