Upgrade Livecache 7.6 to 7.9 Error: liveCache is not ready for upgrade

[former_member251231]

Hi,

We excucted a Combined Upgrade & Unicode Conversion from SCM 5.0 to SCM 7.03 and after this
We want to upgrade Livecache 7.6.06  to 7.9.08.23, when we run LCUPDATE.SH we get this error:

Switching liveCache state back to OFFLINE

ERR:  Upgrade failed

ERR:    Error checking Upgrade

ERR:      Checking data consistency for liveCache migration...

liveCache state is OFFLINE

Switching liveCache state to ONLINE

Looking for ready for update flag...

Value of MCOD-Parameter is NO

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 upgrade

According to Notes:

1566982 - Additional information about upgrading to SAP liveCache 7.9

This issue is because the download of the SAP liveCache data was not performed successfully in one of the REQ_APOUPG phases, but when we executed /SAPAPO/OM_LC_UPGRADE_70 Section A and B fisnished with  green status "No Error".

If we execute manually  "sql_execute select owner,tablename from tables" without "where tablename = '__$__LCFLAG'" , we  found this similiar row:

'SAPLP2';'lc__$__upgrade'

How can we solve this issue?

[david_liu1]

Hello,

The error indeed refer to an empty livecache database. If indeed you

don't have any data in this livecache, you may try the following steps:

You can manually set the indicator as follows:

dbmcli -d LCA -u control,control

  db_online

  sql_connect <Standard-liveCache>,<password>

  sql_execute enable write transaction

  sql_execute create table "__$__LCFLAG" (flag CHAR(1),begin CHAR(23),

end CHAR(23),version CHAR(12))

  sql_execute insert into "__$__LCFLAG" values ('X','nix', 'nix','nix')

  sql_execute grant select on "__$__LCFLAG" to public

  sql_release

  db_offline

*The standard liveCache user is usually SAPR3, or SAP<SID>.

Regards,

David

[former_member251231]

Hi David,

This is LC before section A and B:

As you can see LC has data

And this is section A and B: