CIF-PPM Update Job taking longer time.

[former_member503200]

One of our CIF job, which updates the PPM's is running longer time. Prviously it used to take only 1hr, now its taking more than 5hrs. When i check the log step28 and Step29, the time difference is more than 45min. The same thing happening with few other steps. We are in R3 4.7 and SCM 5.0. Any help is greately appreciated.

06/10/2008 19:40:15 Application log messages with importance 'very important' were written

06/10/2008 19:40:15 Step 025 started (program RIMODAC2, variant 1007PPM_FG, user ID BC_BTCADM)

06/10/2008 19:45:47 Application log messages with importance 'Medium' were written

06/10/2008 19:45:47 Step 026 started (program RIMODAC2, variant 1010PPMSFG, user ID BC_BTCADM)

06/10/2008 20:17:17 Application log messages with importance 'Medium' were written

06/10/2008 20:17:17 Step 027 started (program RIMODAC2, variant 1010PPM_FG, user ID BC_BTCADM)

06/10/2008 20:20:19 Application log messages with importance 'Medium' were written

06/10/2008 20:20:19 Step 028 started (program RIMODAC2, variant 1011PPMSFG, user ID BC_BTCADM)

06/10/2008 21:06:26 Application log messages with importance 'Medium' were written

06/10/2008 21:06:26 Step 029 started (program RIMODAC2, variant 1011PPM_FG, user ID BC_BTCADM)

06/10/2008 21:09:55 Application log messages with importance 'Medium' were written

06/10/2008 21:09:55 Step 030 started (program RIMODAC2, variant 1012PPMSFG, user ID BC_BTCADM)

06/10/2008 21:12:55 Application log messages with importance 'Medium' were written

06/10/2008 21:12:55 Step 031 started (program RIMODAC2, variant 1012PPM_FG, user ID BC_BTCADM)

06/10/2008 21:14:11 Application log messages with importance 'Medium' were written

06/10/2008 21:14:11 Step 032 started (program RIMODAC2, variant 1013PPMSFG, user ID BC_BTCADM)

06/10/2008 22:15:01 Application log messages with importance 'Medium' were written

06/10/2008 22:15:01 Step 033 started (program RIMODAC2, variant 1013PPM_FG, user ID BC_BTCADM)

06/10/2008 22:18:54 Application log messages with importance 'Medium' were written

Jeff

[former_member503200 · Accepted solution]

When i am trying to run this report i am getting this error message.

Error when reading the data

Message no. /SAPAPO/PPM_MAINTAIN714

Any ideas.

thx

Jeff

[Former Member · Accepted solution]

see Note 1157625 - Report /SAPAPO/PPM_CLEAN_UP: Msg. /SAPAPO/PPM_MAINTAIN 714

...if this doesn't work apply an oss call

good luck

Christian

[former_member503200]

Thx,

Christien, it solved the problem. With used the error as my search criteria in OSS message, some how i could not able to get it. May be i need to improve my googling OSS messages.

thx

Jeff

[Former Member]

Hi,

may be it achieves an improvement to reorganize the /SAPAPO/COMPALTZ table. This can be done with the report /SAPAPO/PPM_CLEAN_UP. I don't know if the report in SCM 5.0 is already included. Otherwise search for that report in OSS. The report deletes unnecessary entries from the /SAPAPO/COMPALTZ table. On our system this report solved a similar performance issue with the ppm's recently.

Kind regards,

Christian

[srinivas_krishnamoorthy]

Check out the logs in R3 side using transaction SLG1 and use CIF as the object and PPM as sub-object. Try to see if you see any Important or higher logs. this might give you a clue.