Skip to Content

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

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?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Mar 09, 2016 at 01:24 AM

    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

    Add comment
    10|10000 characters needed characters exceeded