file-to-rfc ..database tables are not updating??

[Former Member]

hi xi friends..

in my file -to-rfc scenario.. without BPM ..

in sxmb_moni..it is showing successfull.. database tables in sap not updating..

my source structure..
workorders 1..1
..order 1..unbounded
...id
...operation 1..unbounded
.....id
.....closingdate
.....status
.....comment

my target is Zbapi_alm_conf_create..

Zbapi_alm_conf_create
...Zdetail_return 1..1
.....item 0..unbounded
...Ztimetickets
.....item 0..unbounded
.......orderid
.......operation
.......fin_conf
.......con_text
.......exec_fin_date

in message mapping:

MM_file_to_zrfc

i changed the occurance of target to unbounded..

message mapping like this..

my source structure..

workorders 1..1  
..order 1..unbounded   --------->Zrfc 0..unbouned
...id                  --------->Ztimetickets-item-order 
...operation 1..unbounded ------>Ztimetickets-item 0..unbounded
.....id                ---------->Ztimeticktes-item-operation 
.....closingdate       ----------->Ztimeticktes-item-exec_fin_date 
.....status            ----------->Ztimetickets-item-fin_conf
.....comment           ------------>Ztimeticktes-item-conf_text

and also in interfacemapping ,changed the target occurance to unbounded.

and in ID ,interface determination using enhanced i selected interface mapping with occurance unbounded..

in sxmb_moni it is showing success..

in adapter monetering( receiver).

<i>Receiver channel 'cc_sap_work' for party '', service 'SAP_ERP__DEV' (internal name 'RfcClient[cc_sap_work]')

Client data: {jco.client.lang=EN, jco.client.snc_mode=0, jco.client.client=400, jco.client.passwd=****, jco.webas.ignore_jdsr_error=1, jco.client.user=aar, jco.client.sysnr=10, jco.client.ashost=53.247.192.84}

Repository data: {jco.client.lang=EN, jco.client.snc_mode=0, jco.client.client=400, jco.client.passwd=****, jco.webas.ignore_jdsr_error=1, jco.client.user=thotv, jco.client.sysnr=10, jco.client.ashost=53.247.192.84}

Current pool size: 0, maximum pool size : 1

Channel History

- OK: 2006-12-31 14:19:47 CET: Message processed for interface ZBAPI_ALM_CONF_CREATE

- OK: 2006-12-31 14:18:50 CET: Message processed for interface ZBAPI_ALM_CONF_CREATE</i>

but the database tables are not updating..if i execute ZBAPI_ALM_CONF_CREATE manually in SAP ..tables are updating...

please guide me...

thanks in advance...

regards

Ram

[Former Member]

Hi venu..

thanx alot for your response..

the XML is getting converted into ZRFC structure and it is showing in request message mapping payload..

i tried with the data in XML file in SAP manually..its updating sap tables..

and i checked confirm transaction and commit work for single BAPI calls without providing any name:values for receiver rfc Communication channel.

i am not getting where went wrong.

regards

Ram

[Former Member]

hi friends..

please guide me....

regards

Ram

[Former Member]

Hi Ram,

First of input data is converting xml format. if converting the data

Take your XML payload in SXMB_MONI try to execute only RFC Using those values are u able to store into table.

Exactly where you are faceing the problem tell me..

Regards,

Venu.

[Former Member]

hi friends ...

please guide me..

regards

ram

[Former Member]

Hi Ram,

Try debugging your RFC by putting an external breakpoint.....it might help.

Regards

Rahul Nawale

[Former Member]

Hi friends..

i used commit work in rfc.

and its multiple rfcs to be called ..so i changed the occurance in messag mapping and also in interface mapping..

in rfc ..there is date field .

for date format i used yyyyMMdd . is the right format for RFC ??

regards

Ram

[STALANKI]

Try using a commit work in RFC

[Former Member]

Hi..

my mappis is like this..

message                   message
.message1                         message1        

..workorders 1..1

..order 1..unbounded -

---

>Zrfc 0..unbouned

...id -

---

>Ztimetickets-item-order

...operation 1..unbounded -

---

>Ztimetickets-item 0..unbounded

.....id -

---

>Ztimeticktes-item-operation

.....closingdate -

---

>Ztimeticktes-item-exec_fin_date

.....status -

---

>Ztimetickets-item-fin_conf

.....comment -

---

>Ztimeticktes-item-conf_text

i didnt mapped message at root..is this necessary to mapp messages??

please tell me

regards

ram

[Former Member]

Hi,

In your earlier posts, there are some target elements with occurence 1..unbounded which have not been mapped. Recheck that.

Do you require multiple rfc requests, or one rfc request with multiple items in it? If it is the first case, then changing the occurence in the MM and IM makes sense.

Depending on that, you would need to decide which source elements you need to map the target elements to.

Regards,

Smitha.

[Former Member]

hi friends...

plzz guide me...

tell me my mapping is OK??

regards

ram

[Former Member]

No. Your mapping is not correct. Since you are doing multi mapping, you should get something like

<messages>

<message1>

<zbapi>

..

</zbapi>

</message1>

</messages>

Regards

Jai Shankar

[Former Member]

Hi..

greetings..

in sxmb_moni..

request message mapping..payload look like ..

  <?xml version="1.0" encoding="utf-8" ?> 
- <ns2:ZBAPI_ALM_CONF_CREATE1 xmlns:ns2="urn:sap-com:document:sap:rfc:functions">
  <ZTIMETICKETS /> 
  </ns2:ZBAPI_ALM_CONF_CREATE1>

full structure is not present...

please tell me is ther any mistake in my message mapping..

please guide me..

ram

[MichalKrawczyk]

hi,

if possible use ABAP proxies

why:

- you'll be able to debug much more easily

- you will see the messagte in R3 (SXMB_MONI)

and not only in XI

- you will be able to create - EXCEPTION HANDLING ! which is in ABAP proxy standard

Regards,

michal

[Former Member]

Hi krishnaMurthy..

thanx alot for your response..

SM58,smq2 showing as nothing selected..seems OK.

i did SXI_Cache refresh...

please tell me what might be the problem...

is message mapping OK...??

guide me please ..

regards

ram

[moorthy]

Hi,

check out the mapping ..i.e in the SXMB_MONI , did you get expected output after mapping.. checkout the RFC structure is mapped correctly...

Take the data from SXMB_MONI and test the mapping..

Also refer this blog to debug-/people/michal.krawczyk2/blog/2006/01/17/xi-debugging-rfc-calls-from-the-xi-not-possible-who-said-that-

Did you do CPACache Refresh and try out restarting the RFC Adapter from the j2ee engine.

Regards,

Moorthy

[moorthy]

Hi,

Go to SMQ2/SM58 and check the status of the tRFC ..

Probably some error may be there,,

Try to refresh the RFC Adapter metadata by CPACache Refresh.

Hope this helps,

Regards,

Moorthy