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

SBL-ODS-50644

This error code has no error symbol.

Generic Error Message

Record not found, either the Primary or Duplicate record was not found (SBL-ODS-50644).

Causes and Solutions

One possible cause is that both the primary record that is based on PrimaryId or PrimaryExternalSystemId and the duplicate record that is based on DuplicateId or DuplicateExternalSystemId does not exist in Oracle CRM On Demand. A second cause could be that either the primary record or the duplicate record does not exist in Oracle CRM On Demand. For more information on PrimaryId, PrimaryExternalSystemId, DuplicateId or DuplicateExternalSystemId, see Oracle Web Services On Demand Guide.

For either primary or duplicate record, when both the Row ID and the External System ID are provided, then the Row ID is used to search for the record:

• If the Row ID is incorrect and the External System ID is correct, then this error occurs. For example, if PrimaryId is specified and incorrect, while PrimaryExternalSystemId is specified and correct, then an error occurs.
• If the Row ID is correct and the External System ID is incorrect, then this error does not occur. For example, if PrimaryId is specified and correct and PrimaryExternalSystemId is specified and incorrect, then no errors will occur.

Error Message

Record not found, either the Primary or Duplicate record was not found (SBL-ODS-50644).

Incorrect SOAP Request

In the following incorrect SOAP request, a record with the ID ADSA-9L5KXI or with the ID C0089009 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>

      <MergeRecordsWS_MergeRecords_Input xmlns="urn:crmondemand/ws/mergerecords/">

         <PrimaryId>ADSA-9L5KXI</PrimaryId>

         <PrimaryExternalSystemId />

         <DuplicateExternalSystemId>C0089009</DuplicateExternalSystemId>

         <DuplicateId />

         <MergeWhenPrimaryBlank>true</MergeWhenPrimaryBlank>

         <RecordType>Contact</RecordType>

      </MergeRecordsWS_MergeRecords_Input>

   </soap:Body>

</soap:Envelope>

Resolving Error SBL-ODS-50644

Check the Web service request to ensure that the PrimaryId or PrimaryExternalSystemId fields match a record in Oracle CRM On Demand. Also check that the DuplicateId or DuplicateExternalSystemId fields match a record in Oracle CRM On Demand. The Id fields are case sensitive and cannot contain query expressions.

Correcting the SOAP Request

To correct the SOAP request, ensure that both records exist in Oracle CRM On Demand and that the correct IDs are specified:

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

      <MergeRecordsWS_MergeRecords_Input xmlns="urn:crmondemand/ws/mergerecords/">

         <PrimaryId>ADSA-9L5KXH</PrimaryId>

         <PrimaryExternalSystemId />

         <DuplicateExternalSystemId>ABC1212</DuplicateExternalSystemId>

         <DuplicateId />

         <MergeWhenPrimaryBlank>true</MergeWhenPrimaryBlank>

         <RecordType>Contact</RecordType>

      </MergeRecordsWS_MergeRecords_Input>

   </soap:Body>

</soap:Envelope>