Value Mapping Mass Replication from ECC table

[Former Member]

Hi Experts,

I need to create a value mapping replication from ECC table. I've gone through few many blogs and SCN treads.

I've generated the java proxy.

Still have few questions...

What would be the approach for single stack.. Can you please guide me.

What would be the receiver communication channel?-----> SOAP (XI)

Where does it point to? Do I need to create this channel under ECC business system?

Please guide me to solve this requirement.

Regards,

Suhale Shaik.

[Former Member · Accepted solution]

Please find the below XML.

<?xml version="1.0" encoding="utf-8"?><n0:ValueMappingReplication xmlns:n0="http://sap.com/xi/XI/System" xmlns:prx="urn:sap.com:proxy:DV1:/1SAI/TAS2FC08C862A04D659D929:740"><Item><Operation>Insert</Operation><GroupID>0A4F831E2598578374A3153420000000</GroupID><Context/><Identifier scheme="GL Account" agency="3rdParty">120-412110</Identifier></Item><Item><Operation>Insert</Operation><GroupID>0A4F831E2598578374A3153420000000</GroupID><Context/><Identifier scheme="GL Account" agency="SAP">C100-29500</Identifier></Item><Item><Operation>Insert</Operation><GroupID>0A4F831E2598578374A3153520000000</GroupID><Context/><Identifier scheme="GL Account" agency="3rdParty">120-678945</Identifier></Item><Item><Operation>Insert</Operation><GroupID>0A4F831E2598578374A3153520000000</GroupID><Context/><Identifier scheme="GL Account" agency="SAP">AR120-6789</Identifier></Item><Item><Operation>Insert</Operation><GroupID>0A4F831E2598578374A3153620000000</GroupID><Context/><Identifier scheme="GL Account" agency="3rdParty">120-45367-</Identifier></Item><Item><Operation>Insert</Operation><GroupID>0A4F831E2598578374A3153620000000</GroupID><Context/><Identifier scheme="GL Account" agency="SAP">AP120-4536</Identifier></Item><Item><Operation>Insert</Operation><GroupID>0A4F831E2598578374A3153720000000</GroupID><Context/><Identifier scheme="GL Account" agency="3rdParty">120-4567-9</Identifier></Item><Item><Operation>Insert</Operation><GroupID>0A4F831E2598578374A3153720000000</GroupID><Context/><Identifier scheme="GL Account" agency="SAP">GL120-4567</Identifier></Item><Item><Operation>Insert</Operation><GroupID>0A4F831E2598578374A3153820000000</GroupID><Context/><Identifier scheme="GL Account" agency="3rdParty">120-3489-8</Identifier></Item><Item><Operation>Insert</Operation><GroupID>0A4F831E2598578374A3153820000000</GroupID><Context/><Identifier scheme="GL Account" agency="SAP">PR120-3489</Identifier></Item><Item><Operation>Insert</Operation><GroupID>0A4F831E2598578374A3153920000000</GroupID><Context/><Identifier scheme="GL Account" agency="3rdParty">120-5327-7</Identifier></Item><Item><Operation>Insert</Operation><GroupID>0A4F831E2598578374A3153920000000</GroupID><Context/><Identifier scheme="GL Account" agency="SAP">PR120-5327</Identifier></Item><Item><Operation>Insert</Operation><GroupID>0A4F831E2598578374A3153A20000000</GroupID><Context/><Identifier scheme="GL Account" agency="3rdParty">120-5327-7</Identifier></Item><Item><Operation>Insert</Operation><GroupID>0A4F831E2598578374A3153A20000000</GroupID><Context/><Identifier scheme="GL Account" agency="SAP">PR120-5327</Identifier></Item><Item><Operation>Insert</Operation><GroupID>0A4F831E2598578374A3153B20000000</GroupID><Context/><Identifier scheme="GL Account" agency="3rdParty">130-345-65</Identifier></Item><Item><Operation>Insert</Operation><GroupID>0A4F831E2598578374A3153B20000000</GroupID><Context/><Identifier scheme="GL Account" agency="SAP">PR130-345-</Identifier></Item><Item><Operation>Insert</Operation><GroupID>0A4F831E2598578374A3153C20000000</GroupID><Context/><Identifier scheme="GL Account" agency="3rdParty">140-3478-6</Identifier></Item><Item><Operation>Insert</Operation><GroupID>0A4F831E2598578374A3153C20000000</GroupID><Context/><Identifier scheme="GL Account" agency="SAP">PR140-3478</Identifier></Item></n0:ValueMappingReplication>

Regards,

Suhale Shaik.

[bhavesh_kantilal · Accepted solution]

Your Context tag has a empty value. Please fix this. The Context needs to have some value.

You can keep the context as http://sap.com/xi/XI or any other value as you please..

[Former Member · Accepted solution]

Hi Bhavesh,

After adding context value also I'm getting the same error. Please find the XML.

<?xml version="1.0" encoding="utf-8"?><n0:ValueMappingReplication xmlns:n0="http://sap.com/xi/XI/System" xmlns:prx="urn:sap.com:proxy:DV1:/1SAI/TAS2FC08C862A04D659D929:740"><Item><Operation>Insert</Operation><GroupID>0A4F831E2DB85784EB5CE26410000000</GroupID><Context>HTTP://SAP.COM/XI/XI</Context><Identifier scheme="GL Account" agency="3rdParty">120-987</Identifier></Item><Item><Operation>Insert</Operation><GroupID>0A4F831E2DB85784EB5CE26410000000</GroupID><Context>HTTP://SAP.COM/XI/XI</Context><Identifier scheme="GL Account" agency="SAP">AR120-987</Identifier></Item><Item><Operation>Insert</Operation><GroupID>0A4F831E2DB85784EB5CE26510000000</GroupID><Context>HTTP://SAP.COM/XI/XI</Context><Identifier scheme="GL Account" agency="3rdParty">130-567</Identifier></Item><Item><Operation>Insert</Operation><GroupID>0A4F831E2DB85784EB5CE26510000000</GroupID><Context>HTTP://SAP.COM/XI/XI</Context><Identifier scheme="GL Account" agency="SAP">AP130-567</Identifier></Item></n0:ValueMappingReplication>

Regards,

Suhale Shaik.

[Former Member]

Thanks Guys....

Issue got resolved after entering user access details in com channel.

It's a cache issue it seems.

Regards,

Suhale Shaik.

[Former Member]

Hi Guys,

I'm getting below error in valuemapping replication in SXMB_MONI of ECC system.

com.sap.aii.proxy.xiruntime.core.ESPXISystemFaultException: Error encountered during processing of XI request message in inbound ESP; Hint: com.sap.engine.interfaces.webservices.runtime.RuntimeProcessException: Unexpected uriID '/{http://sap.com/xi/XI/System}ValueMappingReplicationSynchronous'. Found: BindingData 'null', interfaceMapping 'null' interfaceDefinition 'null'

Please help me guys.

Regards,

Suhale Shaik.

[former_member190293]

Hi Suhale!

Couldn't you provide the url which you used to register your java proxy?

And one more thing: according to SAP help you should use receiver adapter type XI, not SOAP.

In the case of the receiver communication channel, choose the adapter type XI . Ensure that you configure a channel for the Java proxy receiver in this case.

Enter the path prefix /MessagingSystem/receive/JPR/XI for this purpose.

Regards, Evgeniy.

[bhavesh_kantilal]

To add to Evgeniy, Check if you have registered the URL for the Synchronous Interface. Do note that Value Mapping replication demands that both Synchrnous and Asynchronous URLs are registered depending on which type of Service Interface is being called.

From Value Mapping Replication for Mass Data - Enabling Application-to-Application Processes - SAP Librar...

http://<Server>:<Port>/ProxyServer/register?ns=http://sap.com/xi/XI/System&interface=ValueMappingReplication&bean=localejbs/sap.com/com.sap.xi.serv... (for the asynchronous replication scenario)  
http://<Server>:<Port>/ProxyServer/register?ns=http://sap.com/xi/XI/System&interface=ValueMappingReplicationSynchronous&bean=localejbs/sap.com/com.... (for the synchronous replication scenario)

Regards

Bhavesh

[former_member190293]

Yes, Bhavesh, that's the point too!

The first time, I've tried with VMG replication scenario, I copied URL for proxy registration from tutorial and then spent a lot of time trying to get rid of error which I've got during scenario testing.

At last, I figured out that where was a space in URL path. So I got message telling that proxy successfuly registered but it didn't work.

And it's also worth mention that URL path is case sensitive.

Regards, Evgeniy.

[Former Member]

Hi Experts,

Can you please help me to resolve this.

Regards,

Suhale Shaik.

[Former Member]

Hi Bhavesh,

Please find the attached com channel and ICO screen shots.

Regards,

Suhale Shaik.

[bhavesh_kantilal]

Can you check the XML and confirm that this is exactly as what is expected by the ValueMappingReplicationSynchronous Interface? Can you share this XML here?

It could also be a case where the XML has issues and hence the message is erroring..

Regards

Bhavesh

[Former Member]

Hi Bhavesh,

I've added the roles to the user id using in receiver com channel.

Now I'm getting the below error. The error which it got resolved in the below thread.

What do I need to do to resolve this?

I've applied the note which she mentioned in the above thread. After applying the note still I'm getting the error.

Please find the attached image.

Regards,

Suhale Shaik.

[bhavesh_kantilal]

please share your configuration  - receiver communication channel and the output of your mapping so this can be checked!

Also, have you logged off after the roles were added and then relogged in with the corresponding user?

[former_member190293]

Hi Suhale!

Did you register your inbound java proxy?

Regards, Evgeniy.

[Former Member]

Hi Kolmakov,

I've registered it.

Regards,

Suhale Shaik.

[former_member190293]

Hi Suhale!

Please read this blog record written by Udo Martens. It gives the clear answers to all of your questions.

http://scn.sap.com/community/pi-and-soa-middleware/blog/2009/04/03/value-mapping-replication-scenari...

For creation configuration for use with AAE follow the steps described in this tutorial:

Proxy to file scenario using AAE - with full configuration

Regards, Evgeniy.

[Former Member]

Hi Evgeniy,

I've already gone through that blog.

My question is how to replicate on single stack.

We've created a Z table in ECC, I would like to replicate that table in value mapping.

My scenario is File------>PI------>ECC Idoc (Asynchronous).

Need to pass a value to ECC table and get the desired value from that table and pass this value in mapping to receiver IDOC.

What interface do I need to choose from SAP Basis component.

Valuemapping sync or Async.

I've created proxy receiver channel SOAP(XI) with the below url. Used logon data for non sap system.

http://host:port/MessagingSystem/receive/JPR/XI

Is the above created channel is correct one?

Regards,

Suhale Shaik.

[bhavesh_kantilal]

• The Interface will be Sync if you need to process this synchronously and send the response back to ECC or Async if no response required. Purely depends on whether End to End Flow needs to be Sync or Async
• The Communication Channel with be SOAP with XI Protocol and the URL is the correct one.
• Make sure you select LogOnData for Non SAP System.

Regards

Bhavesh

[Former Member]

Hi Bhavesh,

Thanks a lot for your reply.

I've attached  the image of created ICO for Async. Can you please tell me whether this one is correct one. What would be the sender and receiver in this scenario.

Regards,

Suhale Shaik.

[bhavesh_kantilal]

• As the sender system is on ECC, your sender business system will be ECC business system.
• AS you need to replicate data from ECC, I assume you will use ABAP proxies to trigger and push the data?

Regards

Bhavesh

[bhavesh_kantilal]

The remaining settings for this are pretty well explained in Udo 's blog that has been pointed previously.

regards

bhavesh

[Former Member]

Hi Bhavesh,

After doing all the settings. I'm getting HTTP 403 error in SXMB_MONI of ECC system.

Please help me to resolve this.

Regards,

Suhale Shaik.

[bhavesh_kantilal]

• HTTP 403 means the user used does not have the required Roles. Please check the Roles of the user.
• To understand which user, check if the message has reached PI
  • If yes, then the issue is in the User used in your Receiver Communication Channel not having the roles for the Value Mapping Replication ( Java Proxies )
  • If no, then the user used in ECC in your Destination in SM59 does not have the roles to send the message to PI..