Problem in getting info in R/3

[Former Member]

Hi guys,

I have a scenario like this R/3 > XI > AS400

In r3 I imput a parameter and thanks to this parameter I get more info from a table in AS400

When I check in XI in XML message monitor it is ok , I have all the requested field from AS400

The problem is between XI and R/3 , I can't get the data back in my abap program...

CREATE OBJECT lo_clientProxy.

CALL METHOD lo_clientProxy->execute_synchronous

EXPORTING

output = ls_request

IMPORTING

input = ls_response.

CATCH cx_ai_system_fault INTO lo_sys_exception.

ENDTRY.

I should have all the info in ls_response but all the field are blank...

Does anybody know Where can be the problem??

[Former Member · Accepted solution]

HI,

see when you are receiving the response message from the AS400 then that message should map to response interface and that sender should be in apossinto recieve the response i mean Sysn communication.

Check these.

Regards

Chilla

[Former Member]

Thanks for your help,

Hi I think I know what is my problem : I have a flat structure and actually I receive several records so that structure can only contain ONE record and not all of them , do you know how to manage it?

Regards,

Murai

Message was edited by:

Murai Kun

[prabhu_s2]

have the message occurence as 1 instead of 0..unb...this might help

[Former Member]

Prabhu,

I did it but it still give me several records..

I m looking for a way to get all of these records into R/3

Regards,

Muraii

[prabhu_s2]

is the occurence set to 0..1 in the DT? and can u pls be more clear on the second part of ur question

[Former Member]

Actually in message mapping I'm using a function "@ction" .in my case "select" to do a selection in a table. I put two keys : KEY1 and KEY2

So i should have in mapping something like that

Select field1 in table where KEY1=xx and KEY2=xxx

but the problem is that it is not doing a "AND" but a "OR"

Does anybody know how to do it?

Thanks!

[Former Member]

Murai,

>>but the problem is that it is not doing a "AND" but a "OR"

Have a look at this link

http://help.sap.com/saphelp_nw2004s/helpdata/en/4b/a20c4cfea96b498b1e1af3f32f0670/frameset.htm

<i>The name of the <key> element is arbitrary. Column values within a <key> element are combined with a logical AND; different <key> elements are combined with a logical OR.</i>

Regards,

Jai Shankar

[Former Member]

Thanks Jai!

[Former Member]

Now I Can see that I have all the info in the XML monitor. The selection is done perfectly!

But nothing back in r/3:

I'm using this method. :

CALL METHOD lo_clientproxy->execute_synchronous

EXPORTING

output = ls_request

IMPORTING

input = ls_response.

CATCH cx_ai_system_fault INTO lo_sys_exception.

catch CX_AI_APPLICATION_FAULT into lo_app_exception.

=>ls_response is always blank....

=>lo_sys_exception : ok

=>lo_app_exception : OK

Does anybody know where to check to fix it?

[Former Member]

Hi,

My intension is check the receiver side configuration , i mean you are able to see the result in SXMB_MONI , with the perfect values for response also , so after that the message content will be place to receiver through Commucniation channel and recv interface , i mean , if you use the receiver side parameters are not correct then sure you will neot get it, try to check in RWB with receiver CC , findout any error.

Any way see the below links to get about AS400 .

For AS400, we have used File based integration. The AS400 creates a flat file which is read by SAP XI File adapter and sent through regular processing.

For OS/390, we used the MQ adapter to retrieve messages sent by the application on OS/390. The JMS implementation for MQ allows XI to pick messages off the queue, and routed through regular processing.

Please see the below links

JDBC AS400

Regards

Chilla

<i>reward points if it is helpful..</i>

[Former Member]

Everything is ok in SXMB_MONI...it always has a successfull status.

So I don't know where the problem is....The connection is ok, the payload is ok, In abap debugger there are no problem...but the result is always blank....

[Former Member]

Murai,

IN SXMB_MONI, you should have 2 msgs. One for your request and the other is response from JDBC. Do you see both the msgs with chequered flag?

I guess, you get a error msg for the response msg. Do check this.

If the response also has a success msg, then go to SXMB_MONI in R/3. Here again, you should see 2 success msgs one for request and other for response.

In R/3 if you are getting 2 sucess msgs, then the only problem is you have not retrieved the data from the receivng XML msg in R/3.

Regards,

Jai Shankar

[Former Member]

Jai,

"In R/3 if you are getting 2 sucess msgs, then the only problem is you have not retrieved the data from the receivng XML msg in R/3."

That's probably the problem because I have indeed the 2 success message in R/3. Where do i need to check to retrieve the data from the xml msg in r/3?

Kind regards,

Muraii

[Former Member]

Hi,

First you would have to check in SXMB_MONI

for request and response messages , if both are showing successful status, then

Check the reponse strcuture and is it supporting the same you are getting

check the response tructure occurrences

Check the response messages routing to where ??

Is it properly handled in Proxy or not?

After receiving the response data from XI to proxy as input the what is the procedure to handle this input, is it properly send/store in respective table or properly handled?

If yes.

then check the conversion problem is occured , i mean the xml message you are getting into the input/response message , any data converion error occured??

And try to trace the response data what you are reciving and step by step handling procedure, sure it will be posible to catch the error.

Regards

Chilla

[Former Member]

Yes I had a problem of conversion I get in the exception...but now I fixed it so I don't think that's the problem.

But now I have another problem :

No connection to Integration Builder (only generic data visible)

=> I have this message when I do a Sproxy in R/3.....I did nothnig since then ...I don't know why I have this message...

Do you have any idea?

Regards,

Samir

[Former Member]

did activate proxy setting in ur target system .

if not check this blog

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

if you already done this now ur facing this problem then chekc the RFC SLDAPICUST and SLDCheck

[Former Member]

Actually I've checked in SPROXY (R/3) and the thing is that since yesterday the namespace are all in grey , I can do nothing but on friday everything was all right....

error : no connection to integration builder..

[prabhu_s2]

the rfc connectivity shud be checked ....test it in sm59 and see any dumps in sm58

[Former Member]

in sproxy test the connection using test option to chekc the connection is working fine or not.

[Former Member]

Hi,

see the below links

Monitoring for Processed XML messages in ABAP Proxy - /people/krishna.moorthyp/blog/2005/12/23/monitoring-for-processed-xml-messages-in-abap-proxy

/people/siva.maranani/blog/2005/04/03/abap-server-proxies

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

/people/ravikumar.allampallam/blog/2005/03/14/abap-proxies-in-xiclient-proxy

/people/prateek.shah/blog/2005/06/14/file-to-r3-via-abap-proxy

http://help.sap.com/saphelp_nw2004s/helpdata/en/48/d5a1fe5f317a4e8e35801ed2c88246/frameset.htm

http://help.sap.com/saphelp_nw04s/helpdata/en/ba/f21a403233dd5fe10000000a155106/frameset.htm

https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/41e08c90-0201-0010-9197-d8774336...

https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/f0ae9874-109c-2910-f48a-e91f0cdd...

/people/sravya.talanki2/blog/2006/07/28/smarter-approach-for-coding-abap-proxies

Regards

Chilla

[Former Member]

I did a SM59 , and did a connection test to XI and it's working.

[Former Member]

I did a SM59 , and did a connection test to XI and it's working.

But the namspaces are still in grey (in R/3)

[Former Member]

Hi,

Please try to see the below links all are related and useful..

Regards

Chilla

[Former Member]

I 've checked in SM59 the TCP/IP connections :

Connection Test SAPSLDAPI

Logon Connection Error

Error Details Error when opening an RFC connection

Error Details ERROR: program SAPSLDAPI_TES not registered

Error Details LOCATION: SAP-Gateway on host SAP01.xxxxx.aaa / sapgw00

Error Details DETAIL: TP SAPSLDAPI_TES not registered

Error Details COMPONENT: SAP-Gateway

Error Details COUNTER: 5451

Error Details MODULE: gwr3cpic.c

Error Details LINE: 1684

Error Details RETURN CODE: 679

Error Details SUBRC: 0

Error Details RELEASE: 700

Error Details TIME: Mon Mar 26 15:40:54 2007

Error Details VERSION: 2

And Connection Test LCRSAPRFC

Logon Connection Error

Error Details Error when opening an RFC connection

Error Details ERROR: program LCRSAPRFC_TES not registered

Error Details LOCATION: SAP-Gateway on host SAP01.xxxxxx.aaa / sapgw00

Error Details DETAIL: TP LCRSAPRFC_TES not registered

Error Details COMPONENT: SAP-Gateway

Error Details COUNTER: 5459

Error Details MODULE: gwr3cpic.c

Error Details LINE: 1684

Error Details RETURN CODE: 679

Error Details SUBRC: 0

Error Details RELEASE: 700

Error Details TIME: Mon Mar 26 15:41:25 2007

Error Details VERSION: 2

[Former Member]

these 2 have connection issuse can you check the password and gateway entry in these 2 SM59 connections

Sreeram Reddy

[Former Member]

Murai Kun,

have commit statement at the end.

[Former Member]

Hi Murai, ls_response must be a complex type so have you tried access to the fields correctly, Also I think you can check on the sxmb_moni onr the R3 is there was some problem on the interface.

you can also debug the ABAP proxy:

https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/cbc7d790-0201-0010-bea6-c549902e...

Regards

Omar Hernandez