Missing or Invalid Receiver Agreement ERROR In Proxy to JDBC Multiple Message Mapping scenario

[former_member200386]

Dear Experts,

I am working on PI 7.3(Dual stack) now scenario proxy to jdbc  where i need to perform UPDATE_Insert operation  in 3 different tables in a single call. i created 3 source datatypes & 3 target data types.  and i followed this below doc

http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/90dcc6f4-0829-2d10-b0b2-c892473f1...

i designed the interface accordingly. MY proxy is not genarated ,.when i tested my scenario in integration engine . i am getting the

i all share my screen shots.

Regards,

Pavan

[former_member190624 · Accepted solution]

Hi Pavan,

through proxy message , u will get data(employee, material & customer) as one message? If yes no need to create different sender data types. But create 3 different data types one for each table. Then map the target data type with required fields from sender data type. So , no need to create 3 operations in sender interface.So (Design & configuration) objects will be ,

Design:

1 Outbound Service Interface -create DT & MT as proxy structure .

3 Inbound Service Interface - create DT & MT for each table (you can also create 3 operations in single interface, But be careful while using operation as you may get confuse).

3 MM mapping (one for each table).

3 OM mapping (one for each table).

Configuration:

Sender Agreement not required (As it was proxy )

3 Receiver determinations

3 Interface Determinations(u can do it with one interface determination)

3 Receiver Agreements

Let me know the results.

Regards

Hari.

[former_member200386]

[former_member200386]

Sorry guys my network is too slow. i posted twice this query. so please find all designed objects.

Regards,

Pavan

[iaki_vila]

Hi Pavan,

At first you only need one operation for your purpose, delete the others.

Have you created three different receiver agreements for your three different destinations?

Regards.

[former_member200386]

HI Inaki,

Thanks for your response. tell what are the changes required ?

i haven't created 3 receiver agreements . i  created 1 receiver agreement & 1 receiver communication channel , 1 interface determination, 1 receiver determination.

you asked me to delete the operations

where i need to delete?  in the interface determination?

i have already shared my designed objects screen shots. please suggest me where i need to delete my operations & the other changes if required?

I need your quick response

Regards,

Pavan

[iaki_vila]

Hi Pavan,

are using three inbound service interface?

You will need three receiver agreements and only one operation.

are you using three operations in one inbound service interface?

Then your configuration seems right to me, could you show us your receiver agreement?

Regards.

[former_member200386]

HI Inaki,

Thanks alot for your response. i have created 1 inbound service interface. as you told i deleted my operations in interface detemination.

now i am getting mapping error.

i want to share my requirement little.  this is proxy to jdbc asynch scenario.

from sap r3 we need to post(UPDATE_Insert) data to 3 different tables(sap_employee, sap_material,sap_customer).

so i created 3 sender data types( is it required? can i create all fileds in a single datatype?)

i created 3 receiver data types.

in the outbound & inbound service interface i added all messagetypes.

so i create 1 oubound & 1 inbound service interface only.

when select my service interfaces in operation mapping all 6(3 sender & 3 receiver) message types automatically selected.

i completed my mapping.

coming to ID we are using proxy at sender side. so i haven't created my sender comm channel & agreement.

i created 1 receiver  comm channel &1 receiver agreement(do i need to created 3 comm channels& receiver agreemnts

)?

1 interface & receiver detemination.

now iam getting this below error. when i tested the scenario with   integration engine .in sxmb_moni