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

SBL-DAT-04381

This error code has no error symbol.

Generic Error Message

For instance of Integration Component 'Activity_Contact', using user key '', a record with identical values already exists in the Siebel database. Please ensure that the field values in the input message are unique (SBL-EAI-04381).

Causes and Solutions

When you invoke ActivityInsert in Web Services v.1.0, Oracle CRM On Demand Web services associates the same contact object multiple times with the activity.

Error Message

For instance of Integration Component 'Activity_Contact', using user key '', a record with identical values already exists in the Siebel database. Please ensure that the field values in the input message are unique (SBL-EAI-04381).

Incorrect SOAP Request

In the following incorrect SOAP request, there are multiple instances of a contact with the ID: HRZ780-ILEY4:

<?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:xsd="http://www.w3.org/2001/XMLSchema">

   <soap:Body>

      <ActivityNWS_Activity_Insert_Input xmlns="urn:crmondemand/ws/activity/10/2004">

         <ListOfActivity>

            <Activity>

               <PrimaryContactId>HRZ780-ILEY4</PrimaryContactId>

               <Subject>Error Message</Subject>

               <DueDate>08/18/2011</DueDate>

               <Priority>2-Medium</Priority>

               <Activity>Task</Activity>

               <OwnerId>HRZ780-I5RUE</OwnerId>

               <ListOfContact>

                  <Contact>

                     <ContactId>HRZ780-ILEY4</ContactId>

                  </Contact>

                  <Contact>

                     <ContactId>HRZ780-ILEXJ</ContactId>

                  </Contact>

                  <Contact>

                     <ContactId>HRZ780-ILFTI</ContactId>

                  </Contact>

               </ListOfContact>

            </Activity>

         </ListOfActivity>

      </ActivityNWS_Activity_Insert_Input>

   </soap:Body>

</soap:Envelope>

Resolving Error SBL-DAT-00381

Make sure that a contact identified by a specific set of user keys does not appear multiple times in the Web service request.

You can associate only unique contacts with an activity. For example, if the contact ID is specified in the <PrimaryContactId> element, then the same ID cannot be located in the <ListOfContact> element for the same activity. Also, the same contact ID cannot be in more than one <Contact> element in the <ListOfContact> element for the same activity.

Correcting the SOAP Request

To correct the SOAP request, remove one instance of the contact ID HRZ780-ILEY4:

<?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:xsd="http://www.w3.org/2001/XMLSchema">

   <soap:Body>

      <ActivityNWS_Activity_Insert_Input xmlns="urn:crmondemand/ws/activity/10/2004">

         <ListOfActivity>

            <Activity>

               <PrimaryContactId>HRZ780-ILEY4</PrimaryContactId>

               <Subject>Error Message</Subject>

               <DueDate>08/18/2011</DueDate>

               <Priority>2-Medium</Priority>

               <Activity>Task</Activity>

               <OwnerId>HRZ780-I5RUE</OwnerId>

               <ListOfContact>

                  <Contact>

                     <ContactId>HRZ780-ILEXJ</ContactId>

                  </Contact>

                  <Contact>

                     <ContactId>HRZ780-ILFTI</ContactId>

                  </Contact>

               </ListOfContact>

            </Activity>

         </ListOfActivity>

      </ActivityNWS_Activity_Insert_Input>

   </soap:Body>

</soap:Envelope>