Messages taking long time to finish.

[Former Member]

Hi,

We have done 8 idoc to JDBC scenario(different idoc types) in our PI 7.3 . We have used IDoc_AAE adapter as sender. and JDBC adapter as receiver

The parameters in the sender channel are:

Adapter Type: IDoc_AAE

Version     : SAP BASIS 7.30

Transport Protocol:  tRFC

Message Protocol  :  IDoc XML

RFC Parameters Tab:

RFC server Parameters :  Default (Recommended)

Destination : XI_IDOC_DEFAULT_DESTINATION

Inbound Message[ Setting

seleted the Multiple idocs in single XI Message.

The parameters in the Receiver channel are:

Maximum Concurrency is given as 5

not used any advance Mode.(additional parameters)

From ECC sending idocs as 100 packsize.

daily around 60  thousand messages will processes . to completed this it taking more then 2hours . 30 mins.

inserting the records for each idoc type in each data base table.

please suggest is there setting to be done in PI side to reduce the time.

Records

raju

[Former Member]

Hi Raju,

What method of inserting into the DB are you using? Do you use the XML-SQL or a native SQL String?

Did you try playing around with the following parameters in the Advanced Mode --> Additional Parameters:

• Disconnect from Database After Processing Each Message
• Batch Mode

I have found that these parameters can have a dramatic impact on the performance of the database inserts, especially when using the XML-SQL method.

Hope this helps!

Yordy

[MichalKrawczyk]

Hi,

first you need to investigate what is causing the issue - is the IDOC generation so slow in ECC or is that the PI (probably not as 6000 messages - each with 100 - should fly via pi in minutes) so try checking why the IDOCs are being generated so slowly on ECC maybe,

Regards,

Michal Krawczyk