JDBC-RFC-JDBC without BPM

[swatantra_vijay3]

Hi

I have JDBC-RFC-JDBC Scenario.Now i have complated JDBC-RFC part but for the RFC response i dont want to use BPM . We are on PI 7.0 SP 11 . What changes needs to be done in module level to achieve this .

Regards

Vijay

[bhavesh_kantilal · Accepted solution]

Hi,

What action are you trying to perfrom on the JDBC adapter.?

Regards

Bhavesh

[swatantra_vijay3 · Accepted solution]

> Hi,

> What action are you trying to perfrom on the JDBC

> adapter.?

>

> Regards

> Bhavesh

It is simple

JDBC adaptor will fetch the data where data sent flag is not true and then upadte the flag . RFC will be called and SAP doc is created on R/3. . after this RFC send the doc details to database and JDBC update the details

Regards

Vijay

[bhavesh_kantilal · Accepted solution]

Hi,

In that case, the Response JDBC strcuture would contain the Update Action as shown in this link,http://help.sap.com/saphelp_nw04/helpdata/en/2e/96fd3f2d14e869e10000000a155106/content.htm

The response mapping will be from the response of the the RFC to the JDBC and then the rest of the configuration will continue to be as in my thread,

Regards

Bhavesh

[swatantra_vijay3 · Accepted solution]

Thanks Bhavesh,

I have done that , but module level do i need to change something

Regards

Vijay

[bhavesh_kantilal · Accepted solution]

Nope.

Exactly the same.

Procide the name of your Receiver JDBC adapter in the Module and things will work fine.

Regards

Bhavesh

[swatantra_vijay3 · Accepted solution]

Hi bhavesh,

But In your one of the thread File-RFC-File scenario

These steps are mentioned , is it required in my JDBC-RFC-JDBC Scenario???

4. We need to add a few modules in the Sender File Adapter.

Go to the Modules Tab of the Sender File Adater, and add the following modules in the same sequence,

Number - ModuleName - Type - ModuleKey

1- AF_Modules/RequestResponseBean - Local Enterprise Bean - 1

2- CallSapAdapter-Local Enterprise Bean - 2

3-AF_Modules/ResponseOnewayBean-3

Parameters

ModuleKey - ParameterName - ParameterValue

1 - passThrough - true

3-receiverChannel - Receiver File Adapter Name

3-receiverService - Receiver Business Service/ System

Regards Vijay

[bhavesh_kantilal · Accepted solution]

It is.

The QOS of your Sender JDBC adapter will be EO, You need to change it top BE and then the response that comes back you need to route it to the correct Receiver Adapter.

Regards

Bhavesh

[swatantra_vijay3 · Accepted solution]

Hi Bhavesh,

I 'm getting below error for the response msg , i checked the response msg in SXMB_MONI abd it is coming there but Intefration engine is not able to deliver receiver JDBC adaptor

ROB: error during processing: com.sap.aii.af.service.cpa.CPAException: Couldn't retrieve inbound binding for the given P/S/A values: FP=;TP=;FS=SB4_700;TS=BUS_MES;AN=MI_CUS_BH_MRP_01;ANS=urn:MES;

Any clues

Regards

Vijay

[bhavesh_kantilal · Accepted solution]

Recheck the settings as shown in my thread.

Check the QOS in XI in the SOAP Header , is it BE?

Also this JDBC adapter should not be involved in any Receievr Agreements.

Regards

Bhavesh

[swatantra_vijay3 · Accepted solution]

Hi Bahvesh

I checked and it is best effort only and receiver jdbc adaptor is not in the receiver agreements . Any other clue , is module key name make any difference

Regards

Vijay

[bhavesh_kantilal · Accepted solution]

Can you let me know what the parameters used in your Sender JDBC adapter are?

Including the module name and the key etrc.

Regards

Bhavesh

[bhavesh_kantilal · Accepted solution]

How was the problem solved?

What was the issue?

Regards

Bhavesh

[swatantra_vijay3 · Accepted solution]

It was a silly mistake

I gave wrong module key ...

In parameters it should be 1, 3,3 i gave 1,2,3

Now it is working

Thanks for ur support as always

Regards

Vijay

[Former Member]

Hi,

Check whether RFC Look up in Message Mapping would suit your requirement.

Regards,

Sudharshan N A