liveCache is not ready for update

[Former Member]

Hello,

I am trying to upgrade livecache version 7.7.02.08 to version7.7.04.23 (after upgrade SCM 2007 to 7.0). The upgrade fails however with following in the log:

sql_execute select owner,tablename from tables where tablename = '__$__LCFLAG'
ERR
-24988,ERR_SQL: SQL error
100,Row not found

liveCache is not ready for update

make sure that all liveCache transaction data
stored in the APO system
by using step B1 (download liveCache data) of report /SAPAPO/OM_LC_UPGRADE_50

switch liveCache state back to OFFLINE

SYS: "C:\sapdb\programs\bin\x_server" stop
x_server is not running
STDERR: SAP liveCache instance update exited abnormally at Tu, Jul 27, 2010 at 14:47:16
MSG: don't need to write package registry
MSG: install registry successfully unlocked

I have seen that this error occurred to others too, but I couldn't really find a solution yet.

I use the cd 51035655_13 - SAP SCM 7.0 liveCache 7.7.04.23 Windows Server on x64 64bit

• Extra note: The old version has never been used in the past so report /SAPAPO/OM_LC_UPGRADE_70 doesn't do anything.

kind regards,

Nicolas

Edited by: Nicolas De Corte on Jul 27, 2010 3:05 PM

[lbreddemann · Accepted solution]

Hi there,

why not read note 1072392 -"Enhancements to the upgrade to liveCache 7.7" which explains this issue ??

regards,

Lars

[Former Member · Accepted solution]

Hello Lars,

Thanks for your response.

I have already read SAP note 1072392, and the solution they provide is to run /SAPAPO/OM_LC_UPGRADE_70.

Since the old version of the database has never been used, report /SAPAPO/OM_LC_UPGRADE_70 gives me following output:

System does not contain any data, upgrade program not necessary

.

So the report does not do anything and the problem remains...

Or did I overlook something?

Kind regards,

Nicolas

[lbreddemann · Accepted solution]

Ok, in this rather special situation, you can set the flag yourself.

To get the required commands you need to open a support message.

Alternatively you could just run SDBINST to change the liveCache software and run 'load_systab' and register the procedures afterwards.

regards,

Lars

[Former Member · Accepted solution]

That sounds like a solution...

I already opened an OSS message but haven't received a response yet.

where can I find a more detailed description of these actions? I'm quite new to MaxDB

[lbreddemann · Accepted solution]

>

> That sounds like a solution... 
> I already opened an OSS message but haven't received a response yet.
> where can I find a more detailed description of these actions? I'm quite new to MaxDB

In that case you'll have to wait for the answer from support.

The actions required here are capable to delete the data in liveCache so they are not made available for public.

regards,

Lars

[former_member229109 · Accepted solution]

Hello,

You wrote:

u201CExtra note: The old version has never been used in the past so report /SAPAPO/OM_LC_UPGRADE_70 doesn't do anything.u201D

If you didnu2019t run the liveCache applications on the source upgrade system & didnu2019t run the B section step of the report

SAPAPO/OM_LC_UPGRADE_70 on the source upgrade system, you could run the following steps to solve the reported

Issue:

1. Continue the upgrade of your system.

2. After the system will be upgraded, install the liveCache SCM 7.0 software using SDBINST, as recommended by Lars.

Then initialize the liveCache in LC10 in the liveCache relevant client, see more details in the SAP note:

640107 Using program /sapapo/delete_lc_anchors in APO 3.0 or higher

The transactional data will be lost on the system, but itu2019s not the issue for you, as you didnu2019t use the liveCache on the source upgrade system. Correct?

Regards, Natalia Khlopina

[Former Member · Accepted solution]

Hello Natalia,

Thanks a lot for the info!

I have been able to upgrade the LiveCache with SDBINST, but now I get following error when trying to start LC via transaction LC10:

Server: bewetms69
Users: BWETNDC
Logical Command: DBMRFC
Parameter: exec_lcinit restart

Name and Server     : LCT - bewetms69
DBMRFC Function     : DBM_EXECUTE
Command             : exec_lcinit restart
Error               : DBM Error
Return Code         :     -24979
Error Message       : ERR_XPNOTFOUND: Parameter InstanceType n

-24994,ERR_RTE: Runtime environment error
20035,Parameter InstanceType not found

Any idea?

Also, when I run command dbmcli db_enum on the server, I get:

OK
LCT	C:\sapdb\LCT\db                        	7.7.04.29	fast	offline
LCT	C:\sapdb\LCT\db                        	7.7.04.29	slow	offline

Both nodes seem to be offline, is that normal?

gr.

Nicolas

Edited by: Nicolas De Corte on Jul 28, 2010 10:04 AM

[Former Member · Accepted solution]

Hi again,

I have been able to solve this issue by executing the SDBUPD program.

However, I'm facing again another issue, when I try to save a planning version, I get following error:

An application error has occurred in the LiveCache
Message no. /SAPAPO/MVM075

Anyone an idea what I can do with this information?

Kind regards,

Nicolas De Corte

EDIT: I have been able to solve this issue by initializing Livecache again. Thanks all for your help!

Edited by: Nicolas De Corte on Jul 28, 2010 11:11 AM