Problem while sending multiple messages to JDBC

[Former Member]

hi

I am trying to run a scenario file to jdbc(multiple).

Inserting row into table with the file details and updating the same row.

I created 2 message mapping and 2 operation mapping. One mapping to insert row and second to updated the same row.

In ID did configuration 1 Sender Agreement, 2 Receiver Agreement ,1 Receiver Determination(Using Same system for both receiver), and 1 Interface Determination (selecting multiple operation mappings in this interface determination).

The scenario is processing successfully in moni and channel, Problem here is only UPDATE message is going to the Database always. In both the channels UPDATE message is going. I have checked "Maintain Order at Runtime" option also its not working.

Please help.

[Former Member]

2 messages are going to the database everytime.

But instead of different messages (i.e. 1 insert and 1 update) same message is going to the database(i.e. only Update)

[Former Member]

Hi Jabbs,

2 messages are going to the database everytime.
But instead of different messages (i.e. 1 insert and 1 update) same message is going to the database(i.e. only Update)

Why don't you try Stored Procedure? It will save you from using 2 CCs and other extra efforts.

Regards,

Neetesh

Edited by: Neetesh Raj on Oct 16, 2009 3:31 PM

[prateek]

If both receiver agreements uses same receiver channel, could you try using two separate JDBC receiver channels?

Regards,

Prateek

[former_member187339]

HI Jabbs,

Check help.sap.com, in receiver JDBC processing tab-> Maximum Concurrency

Enter the number of messages to be processed in parallel by the receiver channel. For example, if you enter the value 2, then two messages are processed in parallel. Default value is 1 and this means only one message can be processed at a time by the receiver channel.

http://help.sap.com/erp2005_ehp_04/helpdata/EN/22/b4d13b633f7748b4d34f3191529946/frameset.htm

also paste here the receiver structure from MONI, so as to see whether the structure is as per the required format

Regards

Suraj