Value Mapping Tables are not updated in RWB cache

[Former Member]

Hi Friends,

I am doing value mapping replication from SAP.

I am following

/people/sreekanth.babu2/blog/2005/02/23/value-mapping-replication

1)

I didnt changed ABAP proxy of ValueMappingReplicationOut in SAP system.

is anything to... its already in Active state

2)I used ABAP report to call proxy in SAP system.

while debugging ,I come to know that values are populating in the structure svmr_value_mapping_replication in proxy.

3) activated Java inbound proxy (async).I got respose like

Interface http://sap.com/xi/XI/System#ValueMappingReplication registered with value localejbs/sap.com/com.sap.xi.services/ValueMappingApplication:valueMappingReplication

4) No message Mapping .because sender and receive using same message type ValueMappingReplication in http://sap.com/xi/XI/System of SAP BASIS 7.00.

4) I didnt done Sender agreement because of sender is SAP here.

6) In receiver communication channel i follwed help.sap.com

i used PIAPPLUSER

7)

but I am not getting values in RWB Cache.

8) i didnt find any message in sxmb_moni

😎 I did cashe refresh and CPA cache refresh too..

correct me please..

suggest the relevent

regards

Ram

[Former Member · Accepted solution]

Hi Sarvesh,

Thanks Sarvesh for your help.

I did what you suggested.

But Unlucky.Same result.

It is showing one source value and multiple rows in details tab.

Regards

Ram

[Former Member · Accepted solution]

The duplicate values are coming because you are appending the code shown below, again & again.

ls_item-operation = 'Insert'.

ls_item-group_id = '315286378563858425463215845123544'.

ls_item-context = 'http://Test'.

Use this coding ...

> data: lcl_value_mapping type ref to co_svmr_value_mapping_rep,

> ls_value_mappings type svmr_value_mapping_replication,

> ls_item type svmr_value_mapping_rep_item,

> lcl_system_fault type ref to cx_ai_system_fault.

>

> REFRESH : ls_value_mappings-value_mapping_replication-item,

> ls_item.

>

> ls_item-operation = 'DeleteContext'.

> ls_item-context = 'http://Test'.*

> APPEND ls_item to ls_value_mappings-value_mapping_replication-item.

> Clear ls_item.

>

> ls_item-operation = 'Insert'.

> ls_item-group_id = '315286378563858425463215845123544'.

> ls_item-context = 'http://Test'.

>

> ls_item-identifier-scheme = 'OTDVendor'.

> ls_item-identifier-agency = 'OTD'.

> ls_item-identifier-value = '111'.

> append ls_item to ls_value_mappings-value_mapping_replication-item.

> Clear ls_item.

>

>

> ls_item-identifier-scheme = 'SAPVendor'.

> ls_item-identifier-agency = 'SAP'.

> ls_item-identifier-value = 'XXX'.

> append ls_item to ls_value_mappings-value_mapping_replication-item.

> Clear ls_item.

>

>

> ls_item-identifier-scheme = 'OTDVendor'.

> ls_item-identifier-agency = 'OTD'.

> ls_item-identifier-value = '222'.

> append ls_item to ls_value_mappings-value_mapping_replication-item.

> Clear ls_item.

>

>

> ls_item-identifier-scheme = 'SAPVendor'.

> ls_item-identifier-agency = 'SAP'.

> ls_item-identifier-value = 'YYY'.

> append ls_item to ls_value_mappings-value_mapping_replication-item.

> Clear ls_item.

>

>

> try.

> call method lcl_value_mapping->execute_asynchronous

> exporting

> output = ls_value_mappings.

> commit work and wait.

> if sy-subrc = 0.

> WRITE : 'Value Mapping Executed and Values sent to XI system'.endif.

>

> catch cx_ai_system_fault into lcl_system_fault.

> write: 'Error: ', lcl_system_fault->errortext.

> endtry.

>

Edited by: Sarvesh Singh on May 6, 2008 6:25 PM

[Former Member]

Thanks to Sarvesh..He motivated me in right direction to do this value mapping replication from SAP.

regards

Ram

[Former Member]

Hi Sarvesh,

Hurre..Problem solved..

Many Thanks Sarvesh..

keep going...

the problem is, I given GroupID 33 char but it is taking 32 chars only...i corrected it to 32 chars..it worked..

thanks alot Sarvesh..

regards

Ram

[Former Member]

Good to know that after putting lots of effort you finally got your solution..

Plz make the thread as ANSWERED so that other ppl can also take the benifit of it..

[Former Member]

Hi Sarvesh,

I tried with giving two diffrent GroupId's .but in RWB Cache it is showing one GroupID for both the entries.

please have a look in below screenshot.

[http://www.imagehosting.com/show.php/1737608_Valuemapping3.JPG.html]

regards

Ram

[Former Member]

Hi Sarvesh,

I am getting more number of rows in Details..for one source value.

if i give only one row for source and one row for target..its working fine..

if i give 2 records for each source and target.

only one row source value is getting displayed.and more number of rows in details tab.

please have a look in below screen shot

[http://www.imagehosting.com/show.php/1737081_ValueMapping2.JPG.html]

regards

Ram

[Former Member]

Hi Ram,

I observed that the problem is Group ID you were passing the same group_id for each insert..so either you use the FM "GUID_CREATE" for guid or for each INSERT use different hard coded Group_ID.

modified code with different group_id's

> data: lcl_value_mapping type ref to co_svmr_value_mapping_rep,

> ls_value_mappings type svmr_value_mapping_replication,

> ls_item type svmr_value_mapping_rep_item,

> lcl_system_fault type ref to cx_ai_system_fault.

>

> REFRESH : ls_value_mappings-value_mapping_replication-item,

> ls_item.

>

> ls_item-operation = 'DeleteContext'.

> ls_item-context = 'http://Test'.

> APPEND ls_item to ls_value_mappings-value_mapping_replication-item.

> ls_item-operation = 'Insert'.

> ls_item-group_id = '315286378563858425463215845123544'.

> ls_item-context = 'http://Test'.

>

> ls_item-identifier-scheme = 'OTDVendor'.

> ls_item-identifier-agency = 'OTD'.

> ls_item-identifier-value = '111'.

> append ls_item to ls_value_mappings-value_mapping_replication-item.

>

>

> ls_item-identifier-scheme = 'SAPVendor'.

> ls_item-identifier-agency = 'SAP'.

> ls_item-identifier-value = 'XXX'.

> append ls_item to ls_value_mappings-value_mapping_replication-item.

>

>

> ls_item-operation = 'Insert'.

> ls_item-group_id = '315286378563858425463215845123545'.

> ls_item-context = 'http://Test'.

>

> ls_item-identifier-scheme = 'OTDVendor'.

> ls_item-identifier-agency = 'OTD'.

> ls_item-identifier-value = '222'.

> append ls_item to ls_value_mappings-value_mapping_replication-item.

>

> ls_item-identifier-scheme = 'SAPVendor'.

> ls_item-identifier-agency = 'SAP'.

> ls_item-identifier-value = 'YYY'.

> append ls_item to ls_value_mappings-value_mapping_replication-item.

>

> try.

> call method lcl_value_mapping->execute_asynchronous

> exporting

> output = ls_value_mappings.

> commit work and wait.

> if sy-subrc = 0.

> WRITE : 'Value Mapping Executed and Values sent to XI system'.endif.

>

> catch cx_ai_system_fault into lcl_system_fault.

> write: 'Error: ', lcl_system_fault->errortext.

> endtry.

>

[Former Member]

Hi Sarvesh,

Still I am facing problem..

please have a look.

Regards

Ram

[Former Member]

What is the problem ?? Can you post it here..

[Former Member]

Hi Sarvesh,

I changed the logic..

but unlucky this time also..

the same result is coming..Sarvesh

regards

Ram

[Former Member]

just refresh the cache by tcode sxi_cache.. alos do the CPACache refresh.. and then give a try....

never give up....

I have update the code.. with code as shown below

> Clear ls_item.

Edited by: Sarvesh Singh on May 6, 2008 6:27 PM

[Former Member]

Hi Sarvesh,

I changed the test data ..but the result is same..

pease have a look .

[http://www.imagehosting.com/show.php/1737081_ValueMapping2.JPG.html]

please guide me

Regards

Ram

[Former Member]

make these changes in the above code..

REFRESH : ls_value_mappings-value_mapping_replication-item,

ls_item.

ls_item-operation = 'DeleteContext'.

ls_item-context = 'http://Test'.

APPEND ls_item to ls_value_mappings-value_mapping_replication-item.

I am sure this time it will work..

[Former Member]

Hi Sarvesh,

Once again thanks to you.

I did the changes to logic..but I am getting the same result.

One source value ..more number of rows in details..

[http://www.imagehosting.com/show.php/1735277_ValueMapping.jpg.html]

Guide me Sarvesh.

Regards

Ram

[Former Member]

Do one thing, Test with some different data, change the entire test data and then test..

[Former Member]

Hi Sarvesh,

Once again thanks to U..

I did the same what U suggested.

Still getting the same..I am getting more details of One Source value.

Please have a look in below screenshot.

Please guide me Sarvesh

[http://www.imagehosting.com/show.php/1735277_ValueMapping.jpg.html]

Regards

Ram

[Former Member]

Hi,

See the updated code above. Now it should work...

Regards,

Sarvesh

[Former Member]

Hi Sarvesh,

Thanks for your responses.

Now RWB ValueMapping Table is updating.

I tried my luck with Single row of Target and Source values.

I am lucky.

Now I tried my luck more than One row..But I am not getting values the way I required.

Please have a look in below screenshot from RWB.

[http://www.imagehosting.com/show.php/1735277_ValueMapping.jpg.html]

I am getting the first Taget value for all Target avlues.

In Details Tab,It is showing all the values of source and target values.

In my observation,It should show only one source value details.[http://www.imagehosting.com/show.php/1735286_Valuemapping1.Jpg.html]

Please guide me.

Is ther any necessary to change Abap report logic.

my abap logic look like this.

data: lcl_value_mapping type ref to co_svmr_value_mapping_rep,

ls_value_mappings type svmr_value_mapping_replication,

ls_item type svmr_value_mapping_rep_item,

lcl_system_fault type ref to cx_ai_system_fault.

ls_item-operation = 'Insert'.

ls_item-group_id = '315286378563858425463215845123544'.

ls_item-context = 'http://Test'.

ls_item-identifier-scheme = 'OTDVendor'.

ls_item-identifier-agency = 'OTD'.

ls_item-identifier-value = '111'.

append ls_item to ls_value_mappings-value_mapping_replication-item.

ls_item-operation = 'Insert'.

ls_item-group_id = '315286378563858425463215845123544'.

ls_item-context = 'http://Test'.

ls_item-identifier-scheme = 'SAPVendor'.

ls_item-identifier-agency = 'SAP'.

ls_item-identifier-value = 'XXX'.

append ls_item to ls_value_mappings-value_mapping_replication-item.

create object lcl_value_mapping.

try.

call method lcl_value_mapping->execute_asynchronous

exporting

output = ls_value_mappings.

commit work and wait.

if sy-subrc = 0.

WRITE : 'Value Mapping Executed and Values sent to XI system'.endif.

catch cx_ai_system_fault into lcl_system_fault.

write: 'Error: ', lcl_system_fault->errortext.

endtry.

clear ls_value_mappings-value_mapping_replication-item[].

ls_item-operation = 'Insert'.

ls_item-group_id = '315286378563858425463215845123544'.

ls_item-context = 'http://Test'.

ls_item-identifier-scheme = 'OTDVendor'.

ls_item-identifier-agency = 'OTD'.

ls_item-identifier-value = '222'.

append ls_item to ls_value_mappings-value_mapping_replication-item.

ls_item-operation = 'Insert'.

ls_item-group_id = '315286378563858425463215845123544'.

ls_item-context = 'http://Test'.

ls_item-identifier-scheme = 'SAPVendor'.

ls_item-identifier-agency = 'SAP'.

ls_item-identifier-value = 'YYY'.

append ls_item to ls_value_mappings-value_mapping_replication-item.

try.

call method lcl_value_mapping->execute_asynchronous

exporting

output = ls_value_mappings.

commit work and wait.

if sy-subrc = 0.

WRITE : 'Value Mapping Executed and Values sent to XI system'.endif.

catch cx_ai_system_fault into lcl_system_fault.

write: 'Error: ', lcl_system_fault->errortext.

endtry.

Regards

Ram

[Former Member]

Do like this...

> data: lcl_value_mapping type ref to co_svmr_value_mapping_rep,

> ls_value_mappings type svmr_value_mapping_replication,

> ls_item type svmr_value_mapping_rep_item,

> lcl_system_fault type ref to cx_ai_system_fault.

>

REFRESH : ls_value_mappings-value_mapping_replication-item,

ls_item.

ls_item-operation = 'DeleteContext'.

ls_item-context = 'http://Test'.

APPEND ls_item.

> ls_item-operation = 'Insert'.

> ls_item-group_id = '315286378563858425463215845123544'.

> ls_item-context = 'http://Test'.

> ls_item-identifier-scheme = 'OTDVendor'.

> ls_item-identifier-agency = 'OTD'.

> ls_item-identifier-value = '111'.

> append ls_item to ls_value_mappings-value_mapping_replication-item.

>

>

> ls_item-operation = 'Insert'.

> ls_item-group_id = '315286378563858425463215845123544'.

> ls_item-context = 'http://Test'.

> ls_item-identifier-scheme = 'SAPVendor'.

> ls_item-identifier-agency = 'SAP'.

> ls_item-identifier-value = 'XXX'.

> append ls_item to ls_value_mappings-value_mapping_replication-item.

>

>

> ls_item-operation = 'Insert'.

> ls_item-group_id = '315286378563858425463215845123544'.

> ls_item-context = 'http://Test'.

> ls_item-identifier-scheme = 'OTDVendor'.

> ls_item-identifier-agency = 'OTD'.

> ls_item-identifier-value = '222'.

> append ls_item to ls_value_mappings-value_mapping_replication-item.

>

> ls_item-operation = 'Insert'.

> ls_item-group_id = '315286378563858425463215845123544'.

> ls_item-context = 'http://Test'.

> ls_item-identifier-scheme = 'SAPVendor'.

> ls_item-identifier-agency = 'SAP'.

> ls_item-identifier-value = 'YYY'.

> append ls_item to ls_value_mappings-value_mapping_replication-item.

>

> try.

> call method lcl_value_mapping->execute_asynchronous

> exporting

> output = ls_value_mappings.

> commit work and wait.

> if sy-subrc = 0.

> WRITE : 'Value Mapping Executed and Values sent to XI system'.endif.

>

> catch cx_ai_system_fault into lcl_system_fault.

> write: 'Error: ', lcl_system_fault->errortext.

> endtry.

>

Call the method method lcl_value_mapping->execute_asynchronous only once..

try with above code and let me know..

Edited by: Sarvesh Singh on May 5, 2008 7:35 PM

Edited by: Sarvesh Singh on May 6, 2008 10:53 AM

[Former Member]

Hai Sarvesh,

sorry I didnt replied that

This is first proxy..

I maintained all the necessary steps for proxy.

in SLDCHECK...also it is showing OK..

HTTP Destination status is 500 Empty HTTP request received

in sxmb_moni of SAP system,

status is scheduled with green flag.

could u correct me where I did wrong.

Regards

Ram

[Former Member]

> in sxmb_moni of SAP system,

>

> status is scheduled with green flag.

> could u correct me where I did wrong.

Green flag that means something has stuck in queue.

check the queue entires in SMQ1, SMQ2 in R/3

and if there are any errors there just process the message from queue or delete them.

I hope you've already registerd queues by using the tcode --- SXMB_ADM

[Former Member]

Hi Sarvesh,

Once again thanks for ur reponses..

Adapter Type : XI

Transport protocol:HTTP 1.0

Message Protocol :XI 3.0

Adapter Engine: Integration Server

AddressType:URL Address

Target Host :euws0108.biz.xxx.com

Service Number :50000

path :/MessagingSystem/receive/JPR/XI

Authentication Type:Use Log on data for Non-SAP system

User name: PIAPPLUSER

user password: xxxx

adapter is in acive state:

The abap report which calls proxy looks like this

REPORT YVALUE_MAPPING.

data: lcl_value_mapping type ref to co_svmr_value_mapping_rep,

ls_value_mappings type svmr_value_mapping_replication,

ls_item type svmr_value_mapping_rep_item,

lcl_system_fault type ref to cx_ai_system_fault.

ls_item-operation = 'Insert'.

ls_item-group_id = '315286378563858425463215845123548'.

ls_item-context = 'http://xxx'.

ls_item-identifier-scheme = 'SAPVendor'.

ls_item-identifier-agency = 'SAP'.

ls_item-identifier-value = 'XXXX'.

append ls_item to ls_value_mappings-value_mapping_replication-item.

ls_item-operation = 'Insert'.

ls_item-group_id = '315286378563858425463215845123548'.

ls_item-context = 'http://xxx'.

ls_item-identifier-scheme = 'OTDVendor'.

ls_item-identifier-agency = 'OTD'.

ls_item-identifier-value = 'HUC'.

append ls_item to ls_value_mappings-value_mapping_replication-item.

create object lcl_value_mapping.

try.

call method lcl_value_mapping->execute_asynchronous

exporting

output = ls_value_mappings.

commit work and wait.

if sy-subrc = 0.

WRITE : 'Value Mapping Executed and Values sent to XI system'.endif.

catch cx_ai_system_fault into lcl_system_fault.

write: 'Error: ', lcl_system_fault->errortext.

when I excutes this report

i am getteng response like 'Value Mapping Executed and Values sent to XI

and also I checked in debugging proxy srtucture is populating values..

I am not sure where I did wrong..

I am not finding anything in sxmb_moni..

please correct me..

regards

Ram

[Former Member]

Adpter configuration & ABAP Code seems correct.

I have asked you one ques in my above reply. Can you plz ans that.

[Former Member]

Hai Sarvesh,

Thanks for ur response..

I am waiting for this from yeasterday...not lucky..

i am sending only 2 records..

tell me..

I didnt get any message in SXMB_MONI for this scenario..

is there anything wrong...

guide me please..

please read my thread..correct if I did anything wrong

regards

Ram

[Former Member]

Hi,

You don't have to do any thing in Outboudn proxy. So it seems you have done everything perfect. So as per the details give by you I can't see any problem.

May be you can check the Receiver CC parameter once again, just varify if you have given everythig which is needed to connect to XI server.

One ques to you. As you already said you have seen that outbound proxy is active. My ques is, are there other proxy related scenario also which are running succesfully, or you are the one who is going to use the proxy for the first time.

I am saying so because there could be some problem in proxy connect too. Have you configured and acitvated the proxy setting by using this blog...

How to Activate Proxy.

/people/vijaya.kumari2/blog/2006/01/26/how-do-you-activate-abap-proxies

Regards,

Sarvesh

Edited by: Sarvesh Singh on Apr 30, 2008 6:01 PM

[Former Member]

Hi,

If you are running it for the very first time then usually it takes some time may be some time it takes an hour. Also depend upon the size of data. So try after some time.

Hope soon you will find the data in your RWB Cache.

Regards,

Sarvesh