BW Job Taking more time than normal execution time

[Former Member]

Hi,

Customer is trying to extract data from R/3 with BW OCPA Extractor.

Selections within Infopackage under tab Data Selection are

0FISCPER = 010.2000

ZVKORG = DE

Then it is scheduled (Info Package), after this monitor button is selected for the scheduled date and time, which gathers information from R/3 system is taking approximately 2 hours which used to take normally minutes.

This is pulling data from R/3 which is updating PSA, the concern is the time taken for pulling data from R/3 to BW.

If any input is required please let me know and the earliest solution is appreciated.

Thanks

Vijay

[Former Member]

Dear Vijay ,

Inorder to understand better , Schedule a Job in Background, and then check the Job log in R/ 3 , I expect it to give you a better picture of the process in R/3 , also try to check in the monitor tab details in BW , with each infoidoc time for arrival, u can see the time details in the bottom of the details screen in Monitor, Also check if some jobs are being carried in R/3 , which took some time to send the data back to BW.

Hope it helps...

Thanks,

Krish

[m_verbaan2]

Hi Vijay,

If you think the data transfer is the problem (i.e. extractor runs for a long time), try and locate the job on R/3 side using SM37 (user ALEREMOTE) or look in SM50 to see of extraction is still running.

You can also test the extraction in R/3 using tcode RSA3 and use same selection-criteria.

If this goes fast (as expected) the problem must be on BW side. Another thing you can do is check if a shortdump occurred in either R/3 or BW -> tcode ST22. This will often keep the traffic light on yellow.

Hope this helps to solve your problem.

Grtx,

Marco

[Former Member]

Hi Marco,

Thanks for quick reply.

We have informed our cutomer to follow the same procedure on R/3 system.

We have observed that this happens with DATASOURCE = 1_CO_PA_100_OCPA

If the data source is differnet it is taking normal time. May be something to do with the datasource.

There are no short dumps in either R/3 or BW system.

Thanks

Vijay

[m_verbaan2]

Vijay,

A different DataSource means a different way of extracting data from the source system and yes, some can take quite some time.

Just check in SM50 if it's still running.

I don't know the DS you mention but my advise is to see if a delta-load is possible. If not via the Business Content then there might be other ways to delta-enable the extractor.

Grtx,

Marco