Delay in BW Job which retrives data from R/3 PRD

[Former Member]

Hi All,

PFA snapshots of the job log.

There is a BW job which fetches data from R/3 and that is activated in BW.

It generally takes 40 min, but today it took around 4 hrs.

So it was clear that there was an issue in R3. Please help us in finding out the reason why the job took longer time to complete.

Regards,

Avadhesh,

+91 8095226536

joblog.txt.zip

[Former Member]

Hi Avadhesh,

Below part of log says that customer enhancement is called with 51,509 records which is what took the longest amount of time. Do you process same number of records daily?

Call customer enhancement BW_BTE_CALL_BW204010_E (BTE) with 51,059 records	R3	407	S
04.03.2013	03:34:40	Result of customer enhancement: 51,059 records	R3	408	S
04.03.2013	03:34:40	Call customer enhancement EXIT_SAPLRSAP_001 (CMOD) with 51,059 records	R3	407	S
04.03.2013	03:34:40	Result of customer enhancement: 51,059 records	R3	408	S
04.03.2013	03:34:40	IDOC: Info IDoc 3, IDoc No. 27769368, Duration 00:00:00

Also check IDOC logs whether there was something that took so long to go, any connectivity issues, and smq1,smq2 for any queues on error.

Regards,

Ashutosh