Hi,
i've made a scenario to upload items, it work fine if you do a insert.
there are problems on the update:
- if you update a item with only a price_list: no error.
- if you update a item with more price_lists: DImsg="Exception : DI Error: (-2035) This entry already exists in the following tables (ODBC -2035)"
any ideas?
thank you.
SAP 8.81 PL 10
</Payload><Payload Role="X" id="atom16">
<QueryParams xmlns="">
<ItemCode>CODE123</ItemCode>
</QueryParams>
<Items xmlns="">
<row>
<ItemCode>CODE123</ItemCode>
<ItemName>CODE123 desc</ItemName>
<ForeignName>CODE123dsds</ForeignName>
<ItemsGroupCode>124</ItemsGroupCode>
<SalesUnitWeight>7.000000</SalesUnitWeight>
<PurchaseUnitWeight>7.000000</PurchaseUnitWeight>
<CustomsGroupCode>2</CustomsGroupCode>
<Mainsupplier>FF921</Mainsupplier>
<DefaultWarehouse>01</DefaultWarehouse>
<SalesWeightUnit>3</SalesWeightUnit>
<PurchaseWeightUnit>3</PurchaseWeightUnit>
<U_field>aaaaaaaaa</U_field>
<U_field2>aaaaaaaaa</U_field2>
<U_field3>aaaaaaaaa</U_field3>
<U_field4>aaaaaaaaa</U_field4>
<U_field5>aaaaaaaaa</U_field5>
<Manufacturer>-1</Manufacturer>
</row>
</Items>
<Items_Prices xmlns="">
<row>
<PriceList>1</PriceList>
<Price>339.000000</Price>
<Currency>EUR</Currency>
</row>
<row>
<PriceList>7</PriceList>
<Price>250.000000</Price>
<Currency>USD</Currency>
</row>
<row>
<PriceList>9</PriceList>
<Price>309.000000</Price>
<Currency>EUR</Currency>
</row>
<row>
<PriceList>4</PriceList>
<Price>990.000000</Price>
<Currency>EUR</Currency>
</row>
<row>
<PriceList>2</PriceList>
<Price>359.000000</Price>
<Currency>EUR</Currency>
</row>
<row>
<PriceList>3</PriceList>
<Price>850.000000</Price>
<Currency>EUR</Currency>
</row>
</Items_Prices>
</Payload><Payload Role="C" id="atom15" system="0010000116" status="success" b1login="Technical User" method="Synchronous Insert with fallback to Update" objectid="4" payload="atom16" keyname="ItemCode" keyvalue="" DIresult="failure" DImsg="
Exception : DI Error: (-2035) This entry already exists in the following tables (ODBC -2035)"/>