cancel
Showing results for 
Search instead for 
Did you mean: 

MD04 BODS jobs are running very very slow in BODS

0 Kudos

Hi Dirk,

Greeetings..!

I am following with almost all of your posts regarding the BODS related questions and answers being provided.

So i thought you can help me on my BODS related issues as well.

Issue: In our BODS system we have 20 batch jobs in which each job has 400 input pairs. All these 20 jobs gets triggered from BODS concurrently at a scheduled time and these 20 jobs connects to SAP ECC for data extraction and loading the extracted data into a staging table in BODS. Normally this entire extraction and loading the data to BODS staging table takes 1.5 to 2 hours.this is till a week back.these batch jobs are contains normal data flows. no ABAP data flows exists.

However for the past one week these 20 jobs are taking almost 5.5 - 6 hours for extraction and loading the data to BODS staging table. this is causing lot of business loss to our customers.

No changes were done to the BODS jobs.

So not sure exactly all of a sudden that much delay in completing these BODS jobs.

Hence i look forward for a step by step solution approach to resolve this issue permanently.

Thank you in Advance,

Best Regards,

Nanda Kishore.

Accepted Solutions (0)

Answers (1)

Answers (1)

former_member208402
Active Contributor
0 Kudos

Hello,

Are your jobs doing full data extraction or delta extraction?

is your staging a truncate and insert or a upsert?