Sign Up ›
  • PrasadBabu
  • NEWBIE
  • 0 Points
  • Member since 2008
  • Chatter
    Feed
  • 0
    Best Answers
  • 0
    Likes Received
  • 0
    Likes Given
  • 6
    Questions
  • 2
    Replies
0 replies

unable to obtain exclusive access to this record

Hi,

 

While posting Financial Data (Actual Sales) to salesforce i am getting a strange error like "unable to obtain exclusive access to this record ".

 

Where as its working fine when i tried loading with Data loader.

 

Could any one please tell me what could be the problem? Here i am directly posting XML message to salesforce from webmethods.

 

Thanks in advance.

 

Regards,

Prasad Babu.

 
 
3 replies

sObject requires a separate 'type' field be sent.

Hi All,
 
Currently we are working on uploading Opportunities data to SalesForce.com.
 
We completed our development and it was working very much fine before. But now when we tried uploading the same we are getting strange error (negative response) from salesforce as "Client Missing entity type information. sObject requires a separate 'type' field be sent.".
 
Really i did not understand whats the problem is? Could any one help me out in solving this problem?
 
Thanks in advance.
 
Regards,
Prasad Babu.
1 replies

Foreign key external ID:123456 not found for field SAP_External_Id__c in entity Warranty_Cases__c

Hi,
 
Currently i am working on  uploading "Service Orders" data to Salesforce.
I was able to upload the data successfully. But i don't know why its not working now?
 
I am using below structure to send the data,
 
<?xml version="1.0" encoding="UTF-8"?>
<SOAP-ENV:Envelope xmlns:SOAP-ENV="http://schemas.xmlsoap.org/soap/envelope/" xmlns:SOAP-ENC="http://schemas.xmlsoap.org/soap/encoding/" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
<SOAP-ENV:Header xmlns:SOAP-ENV="http://schemas.xmlsoap.org/soap/envelope/"><urn:SessionHeader xmlns:urn="urn:enterprise.soap.sforce.com">
  <urn:sessionId>Session ID here</urn:sessionId>
</urn:SessionHeader><ReceiverID>Salesforce</ReceiverID></SOAP-ENV:Header><SOAP-ENV:Body>
<tns1:upsert xmlns:tns1="urn:enterprise.soap.sforce.com" xmlns:ens="sobject.enterprise.soap.sforce.com" xmlns:urn="urn:enterprise.soap.sforce.com" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:ns3="urn:sobject.partner.soap.sforce.com">
  <urn:externalIDFieldName>SAP_EXTERNAL_ID__C</urn:externalIDFieldName>
  <urn:sObjects xsi:type="Open_Service_Order__c">
    <ORDER_DESCRIPTION__C>test</ORDER_DESCRIPTION__C>
    <NAME></NAME>
    <ORDER_STATUS__C></ORDER_STATUS__C>
    <ORDER_TYPE__C>Test</ORDER_TYPE__C>
    <WBS_ELEMENT_PROJECT_ID__C>Test</WBS_ELEMENT_PROJECT_ID__C>
    <SAP_EXTERNAL_ID__C>9123456789</SAP_EXTERNAL_ID__C>
    <Warranty_Case__r>
      <SAP_EXTERNAL_ID__C>123456</SAP_EXTERNAL_ID__C>
    </Warranty_Case__r>
  </urn:sObjects>
</tns1:upsert></SOAP-ENV:Body>
</SOAP-ENV:Envelope>
 
And the response i got was,
 
"Foreign key external ID:123456 not found for field SAP_External_Id__c in entity Warranty_Cases__c"
 
Could you please help me in getting the right structure? And could any one please tell me what might be the reason for this?
Is there any chance of having some thing changed at salesforce side? if so how can i monitor the changes at salesforce?
 
Thanks in advance.
 
Regards,
Prasad Babu.
1 replies

More than 1 field provided in an external foreign key reference in entity: Account

Hi,
 
Currently i am working on posting of finacial data to salesforce. But while i am doing so i am getting an error "More than 1 field provided in an external foreign key reference in entity: Account"
 
Below is the message i am sending to salesforce,
 
<?xml version="1.0" encoding="UTF-8"?>
<SOAP-ENV:Envelope xmlns:SOAP-ENV="http://schemas.xmlsoap.org/soap/envelope/" xmlns:SOAP-ENC="http://schemas.xmlsoap.org/soap/encoding/" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
<SOAP-ENV:Header xmlns:SOAP-ENV="http://schemas.xmlsoap.org/soap/envelope/"><urn:SessionHeader xmlns:urn="urn:enterprise.soap.sforce.com">
  <urn:sessionId>session ID here</urn:sessionId>
</urn:SessionHeader></SOAP-ENV:Header><SOAP-ENV:Body>
<tns1:upsert xmlns:tns1="urn:enterprise.soap.sforce.com" xmlns:ens="sobject.enterprise.soap.sforce.com" xmlns:urn="urn:enterprise.soap.sforce.com" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:ns3="urn:sobject.partner.soap.sforce.com">
  <urn:externalIDFieldName>External_Id__c</urn:externalIDFieldName>
  <urn:sObjects xsi:type="Financial_Analysis__c">
    <ACTUAL_SALES_YTD__C>23453245</ACTUAL_SALES_YTD__C>
    <ACCOUNT__R>
      <ns3:type>Account</ns3:type>
      <SAP_CUSTOMER_ID__C>123456789</SAP_CUSTOMER_ID__C>
    </ACCOUNT__R>
    <MARGIN_YTD__C>1234567890</MARGIN_YTD__C>
    <Sales_Type__c>Test Services</Sales_Type__c>
    <Current_Financial_Year__c>2007</Current_Financial_Year__c>
    <PROD_REF_TYPE__C>Test product type</PROD_REF_TYPE__C>
    <BUSINESS_DIVISION__C>Services</BUSINESS_DIVISION__C>
    <SERVICE_CATEGORY__C>Test Services</SERVICE_CATEGORY__C>
    <EXTERNAL_ID__C>Test External ID</EXTERNAL_ID__C>
  </urn:sObjects>
</tns1:upsert></SOAP-ENV:Body>
</SOAP-ENV:Envelope>
 
can any one help me out in this. Why the error is for?
 
Thanks in advance,
Prasad Babu.
SOLVED
2 replies

Unexpected element {urn:sobject.partner.soap.sforce.com}type during simple type deserialization

    ...



Message Edited by PrasadBabu on 01-22-2008 08:59 PM
3 replies

Message Structure for Quotations for UPSERT call

Hi,
 
Currently i am working on UPSERT call to SFDC for updating the Quotations from my legacy machine.
Can any one tell me whhat should be the sObject structure for doing it.
I am using below structure,
 
<?xml version="1.0" encoding="UTF-8"?>
<SOAP-ENV:Envelope xmlns:SOAP-ENV="http://schemas.xmlsoap.org/soap/envelope/" xmlns:SOAP-ENC="http://schemas.xmlsoap.org/soap/encoding/" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
<SOAP-ENV:Header xmlns:SOAP-ENV="http://schemas.xmlsoap.org/soap/envelope/"><urn:SessionHeader xmlns:urn="urn:enterprise.soap.sforce.com">
  <urn:sessionId>session ID here</urn:sessionId>
</urn:SessionHeader></SOAP-ENV:Header><SOAP-ENV:Body>
<tns1:upsert xmlns:tns1="urn:enterprise.soap.sforce.com" xmlns:ens="sobject.enterprise.soap.sforce.com" xmlns:urn="urn:enterprise.soap.sforce.com" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:ns3="urn:sobject.partner.soap.sforce.com">
  <urn:externalIDFieldName>SAP_EXTERNAL_ID__C</urn:externalIDFieldName>
  <urn:sObjects xsitype="Open_Service_Order__c">
    <ORDER_DESCRIPTION__c>testsdasdfa</ORDER_DESCRIPTION__c>
    <NAME>test</NAME>
    <ORDER_STATUS__c></ORDER_STATUS__c>
    <ORDER_TYPE__c>asdfasdf</ORDER_TYPE__c>
    <WBS_ELEMENT_PROJECT_ID__c>asdfasdf</WBS_ELEMENT_PROJECT_ID__c>
    <Warranty_Case__c>asdfasdfasdf</Warranty_Case__c>
     <SAP_EXTERNAL_ID__C>asdfasdfasdf</SAP_EXTERNAL_ID__C>
  </urn:sObjects>
</tns1:upsert></SOAP-ENV:Body>
</SOAP-ENV:Envelope>
 
but i am getting response like "Id value of incorrect type:98578452005"
 
Please help me out in this.
 
Thanks in advance,
Prasad Babu.


Message Edited by PrasadBabu on 01-23-2008 03:29 AM
SOLVED
2 replies

Unexpected element {urn:sobject.partner.soap.sforce.com}type during simple type deserialization

    ...



Message Edited by PrasadBabu on 01-22-2008 08:59 PM
3 replies

Message Structure for Quotations for UPSERT call

Hi,
 
Currently i am working on UPSERT call to SFDC for updating the Quotations from my legacy machine.
Can any one tell me whhat should be the sObject structure for doing it.
I am using below structure,
 
<?xml version="1.0" encoding="UTF-8"?>
<SOAP-ENV:Envelope xmlns:SOAP-ENV="http://schemas.xmlsoap.org/soap/envelope/" xmlns:SOAP-ENC="http://schemas.xmlsoap.org/soap/encoding/" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
<SOAP-ENV:Header xmlns:SOAP-ENV="http://schemas.xmlsoap.org/soap/envelope/"><urn:SessionHeader xmlns:urn="urn:enterprise.soap.sforce.com">
  <urn:sessionId>session ID here</urn:sessionId>
</urn:SessionHeader></SOAP-ENV:Header><SOAP-ENV:Body>
<tns1:upsert xmlns:tns1="urn:enterprise.soap.sforce.com" xmlns:ens="sobject.enterprise.soap.sforce.com" xmlns:urn="urn:enterprise.soap.sforce.com" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:ns3="urn:sobject.partner.soap.sforce.com">
  <urn:externalIDFieldName>SAP_EXTERNAL_ID__C</urn:externalIDFieldName>
  <urn:sObjects xsitype="Open_Service_Order__c">
    <ORDER_DESCRIPTION__c>testsdasdfa</ORDER_DESCRIPTION__c>
    <NAME>test</NAME>
    <ORDER_STATUS__c></ORDER_STATUS__c>
    <ORDER_TYPE__c>asdfasdf</ORDER_TYPE__c>
    <WBS_ELEMENT_PROJECT_ID__c>asdfasdf</WBS_ELEMENT_PROJECT_ID__c>
    <Warranty_Case__c>asdfasdfasdf</Warranty_Case__c>
     <SAP_EXTERNAL_ID__C>asdfasdfasdf</SAP_EXTERNAL_ID__C>
  </urn:sObjects>
</tns1:upsert></SOAP-ENV:Body>
</SOAP-ENV:Envelope>
 
but i am getting response like "Id value of incorrect type:98578452005"
 
Please help me out in this.
 
Thanks in advance,
Prasad Babu.


Message Edited by PrasadBabu on 01-23-2008 03:29 AM