Unable to insert opportunity line items

GoogleCodeExporter commented 8 years ago

What steps will reproduce the problem?
1. Have a pricebook defined for an opportunity
2.Create endpoint to insert opportunity line items (with appropriate sdl etc.)
3. attempt to perform an insert

What is the expected output? What do you see instead?

2014-04-30 22:28:23,549 ERROR [INSERT_QUOTE] client.PartnerClient processResult 
(PartnerClient.java:432) - Errors were found on item0
2014-04-30 22:28:23,549 ERROR [INSERT_QUOTE] client.PartnerClient processResult 
(PartnerClient.java:434) - Error code is:FIELD_INTEGRITY_EXCEPTION
2014-04-30 22:28:23,549 ERROR [INSERT_QUOTE] client.PartnerClient processResult 
(PartnerClient.java:435) - Error message:field integrity exception: 
PricebookEntryId, unknown (versions 3.0 and higher must specify pricebook entry 
id, others must specify product id)

What version of the product are you using? On what operating system?
OSX Mavericks, latest version of cliq

Please provide any additional information below.
The strangest thing is that Lexiloader v.29 performs the insert using the same 
mapping and the same input file without any issue

Original issue reported on code.google.com by ets...@gmail.com on 30 Apr 2014 at 8:18

GoogleCodeExporter commented 8 years ago

Running with debugging enabled, I get the following objects created, where 
PricebookEntryId is not defined at all:
  <m:create xmlns:m="urn:partner.soap.sforce.com" xmlns:sobj="urn:sobject.partner.soap.sforce.com">
   <m:sObjects>
    <sobj:type xsi:type="xsd:string">OpportunityLineItem</sobj:type>
    <sobj:Quantity xsi:type="xsd:string">1</sobj:Quantity>
    <sobj:OpportunityId xsi:type="xsd:string">006i000000INs3EAAT</sobj:OpportunityId>
    <sobj:UnitPrice xsi:type="xsd:string">24000</sobj:UnitPrice>
   </m:sObjects>
   <m:sObjects>
    <sobj:type xsi:type="xsd:string">OpportunityLineItem</sobj:type>
    <sobj:Quantity xsi:type="xsd:string">1</sobj:Quantity>
    <sobj:OpportunityId xsi:type="xsd:string">006i000000INs3EAAT</sobj:OpportunityId>
    <sobj:UnitPrice xsi:type="xsd:string">300000</sobj:UnitPrice>
   </m:sObjects>
  </m:create>
 </env:Body>

While the .sdl file is as following:
OPPORTUNITYID=OpportunityId
PRICEBOOKENTRYID=PriceBookEntryId
QUANTITY=Quantity
UNITPRICE=UnitPrice

So, it looks like no pricebookentryid info is transmitted to SF, hence the 
error.

Any shot to get this fixed would be really appreciated!

Original comment by ets...@gmail.com on 2 May 2014 at 4:03

GoogleCodeExporter commented 8 years ago

What is the version shown in your process-conf.xml file?

Original comment by vijay.swamidass@gmail.com on 2 May 2014 at 4:26

GoogleCodeExporter commented 8 years ago

Hi Vijay, 

It shows v.29 as below

Lexiloader_v29 
and
<entry key="sfdc.endpoint" 
value="https://www.salesforce.com/services/Soap/u/29.0"/>

Thanks

Vangelis

Original comment by ets...@gmail.com on 2 May 2014 at 4:35

GoogleCodeExporter commented 8 years ago

What does your CSV file look like - the headings are case sensitive.

Original comment by vijay.swamidass@gmail.com on 6 May 2014 at 6:05

GoogleCodeExporter commented 8 years ago

Thanks for pointing in the right direction
had camel-cased wrongly the PRICEBOOKENTRYID=PriceBookEntryId
works fine now

Many Thanks for the help and the excellent solution!

Best,

Vangelis

Original comment by ets...@gmail.com on 6 May 2014 at 7:07

B4nanaF1sh / dataloadercliq

Unable to insert opportunity line items #85