Reload of LiveCache after APO/LC Upgrade fails

[former_member1012268]

Hello World,

we just finished LC Upgrade phase of Step "Execution" during the upgrade of our APO+LC system (Target release: EHP3 FOR SAP SCM 7.0).

When compared with the (already successfully upgraded) Test system, all components (DB & SAP kernel, SAP Module Versions) match, and the SUM logs show no errors.

Yet when we try to rebuild the LC, by executing the ABAP report "/SAPAPO/OM_LC_UPGRADE_70", it gets stuck in step C3->Load Master Data.

If started, this action goes on forever, w/o ever finishing.

The DB fill level ever so slowly creeps up to ~5.2% (we had %50 freespace in the LC before the upgrade), and then nothing more happens.

We can see a WP being busy with *MATGEN* Jobs in SM50, but when checked that WP hardly writes anything to the DB (with roughly 125000 reads thus far).

There are no error entries in the WP trace files, and the LC database works just fine (version 7.9.08.16).

SAP Support (as unfortunately to be expected these days), has proven next to useless thus far.

They didn't even know how to use AL11 to review log files on their own (we did open up the service connection, yet they still demanded we send them those log files by mail)

This is our production box and Monday is approaching, so what to do nail down the root cause and fix it?

Thx in advance for any help

[former_member229109]

Hello,

- From the provided information I could not see that it's the liveCache or LCA issue.

  Did you have the long running statements on the SCM database or the long running LCA routines?

  During the Load Master Data step the master data from SCM database will be loaded to the liveCache.

  If there were no tasks activities in the liveCache, then I assume that the select statements on the master data tables are running longer in SCM DB. Then the performance in SCM DB has to be checked, then appl. server resurces, logs ...

- For the issues with the "/SAPAPO/OM_LC_UPGRADE_70" C section steps report via SAP message to the BC-DB-LCA component first. So we could login to your system and do pre-analysis of the root case or discuss with you in details all information we need to get the root case of the issue, if the login to the system will be not allowed.

- What is your SAP message number?

  You could increase the priority of the SAP message to very high in case of the production system issues.

Thank you and regards, Natalia Khlopina