Parallel processing causing issues

[ManojYadav]

Dear All,

Need support on below query.

We have a custom program which runs in background every day to create/ change requirements. This program uses FM BAPI_REQUIREMENTS_CREATE / BAPI_REQUIREMENTS_CHANGE. Since we have millions of records and database commits, it takes huge time to finish the job. To improve the performance we implemented parallel processing ( ref. Implementing Parallel Processing (sap.com) ). It has improved performance more than 40-50%.

We don not see any issues if run 3-4 parallel jobs. But if we increase the job numbers like 5, 6 etc., it causes issues like update processes are full, overloading system update queue, CPU bottleneck .

How this can be resolved from ABAP side and BASIS side to get maximum improved performance without causing system issues

Thank you.

Regards,

Manoj

[Sandra_Rossi]

Difficult to say anything about all these performance issues. It requires analysis at your side. Ask an expert from SAP Consulting or any ABAP/basis expert.

[DominikTylczyn]

Hello manoj_yadav

BAPI_REQUIREMENTS_CREATE / BAPI_REQUIREMENTS_CHANGE mange planned independent requirements, that is the demand plan.

I just cannot believe that your demand plan is so unstable that you need to change millions of planned independent requirements every day. If it were really so unstable, it would have huge impact on MRP planning and thus on the entire supply chain, you would have much bigger problems than long running jobs.

So it is either:

1. your demand plan is not that unstable anyway - then rework your planned independent requirements update report to post updates of the records that really changed, not to the millions other records every day.
2. or it is changing left and right everyday - then such an unstable demand plan is not beneficial or even usable and you might just as well stop maintaining it all together.

Best regards

Dominik Tylczynski

[ManojYadav]

Hello Dominik,

Thank you so much for quick response.

Yes, you are right, we are creating planned independent requirements. There might be some reasons during initial development/design of this report. We are also not sure why they delete the requirements and create again everyday.

But as suggested, I will check if only changed records can be considered instead of all.

Best regards,

Manoj

[jack_graus2]

You could make use of server group. You can set several limits in a server group. Like the maximum number of work processes being used.

[DominikTylczyn]

jack.graus2 Of course server groups is also an option. Still I think the root cause is an incorrect design of demand update report that is deleting and recreating millions of records daily. That should not be the case - demand plans are not that unstable.

[ManojYadav]

jack.graus2 that is already in place.

[Sriram2009]

Hi Manoj,

During the parallel process, what is the load on the database instance? if possible could you share the OS/ DB version and database instance hardware resource details?

Regards

SS