Issues faced in SCM system after Live cache re-initialization

[Former Member]

Dear Experts,

We recently performed an activity of dropping the live cache and re-initializing it for one of our project requirements which is stated below.

Requirement:There was a demerger happening for our client in which few of the asset companies within our Client were separating and forming a new company.

Naming for old company - ABC and new company - XYZ.

XYZ was shifting completely to a new system and they wanted us to clean all the data pertaining to ABC from their system.

We used SLO to perform deletion of data belonging to ABC from the APO data base and to delete the data from live cache ,the live cache was dropped (which deleted ABC & XYZ data from live cache) and then reloaded from data base ( re- initialized the live cache).

The following issues were faced after re-initialization of livecache.

a)All the transactional data even belonging to XYZ was deleted from the system.

b)While trying to load data in DP planning book , received error "key figure does not exist" and planning book could not be processed further.

c)While running the planning area consistency check , received error "storage bucket profile does not exists in the live cache".

Can anyone help on how to correct the issue if you had a similar situations in the past.Any suggestions would be helpful.

Thanks

[former_member229109]

Hello Geethika p,

you already reported the case in SAP message. I recommend to close this thread to avoid any misleading information.

a) The transaction data will be lost after you will initialize the liveCache in LC10.

Review the SAP note:

640107

Using program /sapapo/delete_lc_anchors in APO 3.0 or higher

You could bring the transaction data back via initial transfer from R/3 system and TS data need to be loaded from backup infocubes.

b) See a) on TS data.

c) Case was that you initialized the liveCache and selected the option as for migration or upgrade.

    Then used //om17 to correct inconsistencies.

    I was wrong.

    You could not use the option as for migration or upgrade when you run the liveCache initialization in LC10, if you are NOT run the system migration or upgrade.

Best regards, Natalia Khlopina

[RahulHanda]

Geethika,

This was given as you deactivated live cache. I hope you maintained right back-up for the same for the first point.

a)All the transactional data even belonging to XYZ was deleted from the system.

For point two before loading it back, de-initialize PA and re-initialize planning area. Do consistency check for PA, MPOS & OM17 (DP time series) but after resolving next point.

b)While trying to load data in DP planning book , received error "key figure does not exist" and planning book could not be processed further.

Check in your storage bucket profile, do you have posting period (fiscal year)? Have you made any change for the same which is assigned to planning area? Check in OB29 for your fiscal periods do they exist in fiscal year variants. Example SBP is from 2011 to 2019. But fiscal year 2011 & 2012 is not available in fiscal variant in OB29.

c)While running the planning area consistency check , received error "storage bucket profile does not exists in the live cache".

Let us know if it helped.

Regards

Rahul

[former_member229109]

Hello Rahul,

you are given the misleading information.

a) If the transaction data will be lost after you will initialize the liveCache in LC10, the following steps in your post:

For point two before loading it back, de-initialize PA and re-initialize planning area. Do consistency check for PA, MPOS & OM17 (DP time series) but after resolving next point.

WILL NOT HELP.

Review the SAP note:

640107

Using program /sapapo/delete_lc_anchors in APO 3.0 or higher

You could bring the transaction data back via initial transfer from connected R/3 system and TS data need to be loaded from backup infocubes.

b) Review the SAP note -

1612107 - Transaction /SAPAPO/SDP94 - COM Error with Return Code 40,134

or search the notes on error "key figure does not exist" .

See the document Deinitializing and reinitializing a Planning Area on SCM-APO system - Supply Chain Management (SCM) ...

As the liveCache is empty < see a) >, you could NOT load the data to infocube any more.

Steps to solve in the customer case:

-De-initialize the planning area.

-Re-initialize the planning area 

- load TS data data from infocube.

c) See SAP note -

425825 - Consistency checks, /sapapo/om17, /sapapo/cif_deltareport

"Storage buckets profile in the liveCache:

With the storage buckets profile the system checks, in addition to the existence, whether the start times of the time buckets and the weighting factors are correct.The system runs its checks on the basis of the settings of the planning area's storage buckets profile (cf. transaction /SAPAPO/TR32).Any inconsistencies here cannot be repaired.However, this case only occurs very rarely (for example, if the fiscal year variant has been subsequently changed).The inconsistencies can only be eliminated by creating (initializing) the time series again."

In the customer's case, initialize the liveCache with the proper option as post-initialization step,

then bring the transaction data back via initial transfer from R/3 system and TS data need to be loaded from backup infocubes < b) >.

Regards, Natalia Khlopina

[Former Member]

Hi,

Do you see your DB of Livecache is active in LC10 ?

Have you checked the Alert Monitor in LC10 ?

Check whether any locks established in LC10 , SQL locks, I/O Locks etc.

its a DB which has the cache residing within memory (data algorithms,run time data etc), so i guess when you drop all the data which are available with the cache would have gone, though am not sure.

Try running /n/sapapo/om17 and check the logs.

Check whether you've all of your MPOS, PA , SBP in your system or not. Though my knowledge is very limited as this issue seems to be a BASIS issue.

You can post this query on the below thread, hope you'll get the solution here.

Try Exploring SCN you get some answers for your questions.

Regards

Vinoth