RFC to JDBC synchronous

[Former Member]

Hi experts,

i have to scenario RFC to JDBC

i need to know in R3 (parameter import by RFC) the number of lines inserted in database.

receiver JDBC give mne this data, but my doubt is if is necessary mapping this statement?, is necessary to create this datatype, what is the datatype -string, int,..? have i to defined a synchronous scenario?, how many messages interfaces i need?

very thanks,

[dharamveer_gaur2 · Accepted solution]

You need to Create 2 Synch Message interface

one for RFC and one for JDBC.

Use Count function to count no. of records inserted and send

response back to RFC.

[Former Member]

Thanks Pooja,

yes, ZOK is a import parameter of my RFC,..

i can see the return message in SXMB_MONI, your value is 1..

i am mapping this message qith RFC response message..

[Former Member]

Thanks Pooja,

now all ok, but in R3, when i call to function and finish i don't see the value '1' in the parameter ZOK, however all messages in SXMB_MONI are ok, and i can see this value in the mapping, why can't i see the value in R3?

[Former Member]

What is ZOK ? Is this a import parameter of you RFC ?

In SXMB_MONI, what do you see in the JDBC return message ? Are you mapping the returned value with your RFC response message?

Thanks,

Pooja Pandey

[Former Member]

Thanks Udo,

but i don't see the message in RWB, the message 'Content of message deleted to save memory' and i don't know why..

[Former Member]

Hi Silvia,

This is one of the PI functionality for the synchronous messages to prevent them being cached and accumulating in memory.

Thanks,

Pooja Pandey

[Former Member]

Hi Silvia,

If you want to track synchronous calls in SXMB_MONI then, Go to

SXMB_ADM --> Integration engine configuration --> RUNTIME and create the new entry RUNTIME - LOGGING_SYNC = 1.

Thanks,

Pooja Pandey

[Former Member]

thanks all,

how can i mapping this message, give me error..

jdbc_response 1..1 rfc_response 1..1

insert_count 1..1 count 0..1

count 1..1

my mapping is

jdbc_response -> rfc_response

count -> count

(insert count no mapping)

the error is 'Returning synchronous error notification to calling application: com.sap.aii.af.ra.ms.api.DeliveryException: Application:EXCEPTION_DURING_EXECUTE:.'

can you help me please?

[udo_martens]

Hi Silvia,

download the messages from SXMB_MONI and upload them to Test tool of Repository using full trace.

Regards,

Udo

[udo_martens]

Hi Silvia,

>is necessary mapping this statement?,

Yes

>is necessary to create this datatype, what is the datatype -string, int,..?

Yes, just take string

>have i to defined a synchronous scenario?,

Yes

>how many messages interfaces i need?

One synchronous Inbound interface and the imported RFC working as Outbound

Regards,

Udo

[Former Member]

You can refer this also.

https://www.sdn.sap.com/irj/scn/wiki?path=/display/xi/stepbystepRFCtoJDBCscenario

Thanks,

Hetal