CIF master data jobs taking huge time

[AA3]

recently our CIF master data jobs(RIMODACT, RIMODGEN) are taking huge time (>1days) to process almost similar number of records (PIR). The Inbound Queue on the APO side still shows running status. We tried to reset the long executing LUW and then it was fast for only a few further LUW entries, thereafter its stuck for a long time again.

Can any one point out where do we need to look into (ECC, Live cache or the Queues)

[claire_yang · Accepted solution]

You may need to check the following:

- Block size in tranaction CFC3 and /SAPAPO/CP3 (see F1 help for more detailed explanation)

- Note 384077 and 329110.

[Former Member]

Hi

Is this a sudden issue ? If so, what has changed since the time there was no problem. Was there a patch or release upgrade at either SAP or Database or even Operating System level ? Any one of these could cause the problem.

Is the system taking most of its time in RIMODGEN or in RIMODAC ? If it's RIMODGEN, then you can try to reduce the number of filter objects (material plants) in a single integration model. Look at some of the several OSS consulting notes for CIF performance. Also check whether you are following all the SAP reccomended procedures for APO/CIF maintenance - including deleting old application logs/ Livecache logs, etc.

Rishi Menon

[AA3]

Yes this is a sudden issue. We ran DB stats on the RFC tables then the performance improved, but then later the performance is dropped down again.

Can you please point me to the relevant tables and Notes if any for performance improvements. However the Jobs are not failing

the problem is during Model Activation(cfm2) RIMODACT.

[Former Member]

Hi

Look at notes 334692, 384077. Also look at the SAP document "Manage APO Core Interface in SAP APO (3.x) / mySAP SCM (4.x, 5.0)" for best practices on maintenance.

Rishi