B1iF B12B1 Scenario ItemGroups Insert/Update error?

[Former Member]

Hi everyone,

I'm new at B1iF, and I would like to replicate ItemGroups from B1 to another B1 company.

If I try to use Outbound method: Update, it throws an exception:

Exception: com.sap.b1i.adapter.dia.exception.UpdateOnMissException: The updating business object doesn't exist.

So, I'm using Outbound method: Update with the fallback to Insert.

On new ItemGroups, it Insert perfectly, but when I try to Update existing ones it throws an exception:

Exception : DI Error: (-2035) This entry already exists in the following tables (ODBC -2035)

That's my transformation code:

Any ideas?

Thanks!

[former_member203816 · Accepted solution]

Hi,

Please use updatewithsubdeletion method.

Please see note No 1700862 but it's for B1iSN may be it will help you.

Thanks,

Tushar

[Former Member · Accepted solution]

Hi Tushar,

Thanks for your reply.

Well, I saw and followed the note that you advised me.

I made this configuration:

And I transfered the code from the final atom to the xForm atom.

In the monotoring section, the event was captured and the transaction was sucessful, but on B1 nothing happens.

Do you know what am I missing?

Thanks!

[former_member203816 · Accepted solution]

Hi,

Have you checked in Queue monitor ?

or in the key name field it's should Number or ItmsGrpCod (I am not sure for this).

Thanks,

Tushar

[former_member202745 · Accepted solution]

Yes, Tushar you are correct, the key name is Number. João, follows attached my B1 Object Call atom from my ItemGroup scenario.

Regards,

Leonardo.

[Former Member · Accepted solution]

Hi tushar,

The queue monitor is empty and the key name I think is Number because ItmsGrpCod throws a 'Field Not Valid Exception'.

Probably it is my configuration that is not configured correctly.

The transformation code is supposed to be on xForm before B1 Object right?

Thanks,

Regards

[Former Member · Accepted solution]

Hi Leonardo,

The SysId it is the Receiver System is that correct?

And on Key Value I should give the path to the primary key on the xml from the sender document?

The transformation is suppose to go on xForm before the B1 Object Atom?

And on the Final atom i call the trasformation from the xForm or i do nothing?

Thanks,

Regards

[former_member202745 · Accepted solution]

Hi João,

I cannot see well the SysId on your printscreen posted before. Shall you attach this again? And yes, you need to place the key xpath from the sender msg on the key value field. Using the B1 Object atom the B1 outbound is not necessary.

Regards,

Leonardo.

[Former Member · Accepted solution]

Hi Leonardo,

Can you see my configuration now?

And can you put your example of the xPath to Key Value please.

By the way, I can now Insert the object on the other company, but I

cannot Update it. On the Update case, throws an Exception:

"com.sap.b1i.xcellerator.XcelleratorException: XCE001 Nested exception: com.sap.b1i.xcellerator.XcelleratorException: XCE001 Nested exception: java.lang.RuntimeException: The DI-Proxy server has been replaced within the current transaction's calling sequence!"

Thanks,

Best Regards

[former_member202745 · Accepted solution]

Hello João,

I use the xpath to event details, follows the path:

/vpf:Msg/vpf:Body/vpf:Payload[@Role='T']/Event/b1ie:B1IEvent/b1ie:PrimaryKeyList/b1ie:PrimaryKey/@Value

And the xml object don't need the block BO/BOM and AdmInfo, just begin from ItemGroups tag.

Regards,

Leonardo Azevedo.

[former_member216187]

Hi,

Following properties work for me:

<ItemGroups>

  <row>

    <InventorySystem>bis_MovingAverage</InventorySystem>

    <GroupName>IT01</GroupName>

    <DefaultUoMGroup>-1</DefaultUoMGroup>

    <DefaultInventoryUoM nil="true">0</DefaultInventoryUoM>

  </row>

</ItemGroups>

Regards,

Agneesh

[Former Member]

Hi Agneesh,

Is the Update working as well?

Can you post a printscreen from your xForm Atom, B1 Object configuration, and Final Atom please.

I'm doing something wrong, but I don't know what.

Thanks,

Regards.

[former_member216187]

Hi,

Try commenting the two fields in your payload. planning system and procurement method.

Then execute the transaction. If it works then try and check the SQL table in the recepient system for these two fields.

Regards,

Agneesh Jain