Messages transfer delay from adapter to vendor database???

[Former Member]

Hi experts,

Now have a scenario as IDoc to JDBC, message sent from ECC and inbound database with JDBC adapter.

The issue is that when message transfer from PI to Database, go to adapter engine message monitoing,it's found it cost more than 2 hours between the start timestamp and the end timestamp.It means there has a serious delay during the message transfer from PI adapter to databse.

From JDBC channel monitoring, it won't give effective information since it only display some certain recent logs.Then ask Basis go to check server node log during that period it also shows nothing special happened.

Anyone got the idea abt the reason of message transfer delay? any advice would be much appreciated.

Thanks in advance.

[Former Member]

Hi,

Check SAP note 1473299 or 831162, See if parameter "poolWaitingTime" helps you.

Amol

[Former Member]

the parameter "poolWaitingTime" we set as 60000.

the issue happened to just some of the messages while some transferred cost 1 min some transferred cost 2 hours. and after check the message size it's same with the ones cost 1 min.So it should not be the message size issue.

Anyone help?

[markangelo_dihiansan]

Hello,

In your JDBC Receiver, under processing, have you ensured that the value for maximum concurrency is 5 instead of 1?

Regards,

Mark

[rajasekhar_reddy14]

Hi Rajesh,

Purpose of poolWaitingTime waiting time is different.

in your case problem seems to be with backend data base,please check below blog .

Regards,

Raj

[Former Member]

Yes. it presents as 5.

[markangelo_dihiansan]

Hello,

You can go to RWB -> Performance Monitoring -> Detailed Data Individually (use extended search). Fill out the filters and then execute. From there you will see from the XI Pipeline where it takes the longest time e.g if in Message Mapping you should check your mapping or your message size.

Hope this helps,

Mark

[Former Member]

it's ok in integration engine, which no delay in IE.The delay just in adapter engine but no issue logs found in Basis aspect.

[rajasekhar_reddy14]

Hi Rajesh,

What kind of operation perfroming on data base? there are various reasons for this issue

backend data base perfromence or Network connetivty between PI and Data base or JDBC adapter.

share some more info on this will try to give some hint.

Regards,

Raj