Starting of LiveCache fails after patching

[former_member186587]

We have applied Support Pack 09 to SCM 7.01 System and updated LiveCache according to SAP Note 1751103. But still we are getting same error when we are trying to start LiveCache using program RSLVCSTART --> LCA

SCM 7.01 SP09

Live Cache: 7.7.07   BUILD 042-123-246-013

ST22 Dump:
Triggering SQL statement: "EXECUTE PROCEDURE "APS_PLAN_VERS_GET_ALL""                         |
|    Database error code: "-4016"

Work Process Trace:
C  *** ERROR =>   prepare() of C_0050, rc=1, rcSQL=-4016 (POS(1) Unknown procedure name:LCK_LIST_OWNERS)  [dbsdbsql.cpp 2601] C  {root-id=519255317CF22030E10080000A0B024E}_{conn-id=519257767CF22030E10080000A0B024E}_1
C  *** ERROR => SQL PREPARE on connection 2, rc=-4016 (POS(1) Unknown procedure name:LCK_LIST_OWNERS) [dbslsdb.cpp  8907]

We are able to start & stop Live Cache using DBM commands (dbmcli). We are able to see it in LC10 as well. But then we try to start it throws above errors.

DB59 --> All good
/n/sapapo/om17 --> Consistency Check LiveCache - APO DB --> Execute; It throws Runtime error as above
se38 --> RSLVCSTART --> LCA It throws above errors

Bhavin

[former_member229109 · Accepted solution]

Hello Bhavin,

As far as I know you created SAP message  435627/2013 and got SAP support. Correct?

To avoid any further missleading info, I recommend you to update the created SDN threads on the same issue as SAP message with some info on solution and close those threads.

Thank you & best regards, Natalia Khlopina

[former_member186587 · Accepted solution]

Thanks Natalia. Yes we were able to resolve the issue.

Solution:

Step 1.

We have updated user id & password in LC10 -> Integration for

LCA/LDA/LEA

yes we know password of SAP<SID> {user id of source system} and is maintained in LC10.

- After doing DB restore from Dev LiveCache, we ran below command to

Load System Tables.

/sapdb/programs/bin/dbmcli -d LCS -u control,<passowrd> load_systab -u

superdba,<password>

Step 2. (Note 1015489 - Connection problems after system copy)

dbmcli -d <LC Instance> -n <LC Server> -u DBM,<Password> -uSQL sap<sid> ,<Password> sql_execute DROP TABLE APPSYSPARAM

Immediately afterwards, restart the liveCache.  During the first liveCache call, the name of the new system is saved.

Bhavin

[former_member188883]

Hi Bhavin,

1)  Please check that LCA/LDA/LEA connected to the same liveCache instance name/sever

    in LC10 -> Integration. And the same liveCache user set.

1) Stop the liveCache, then start the liveCache in LC10 & check that LCK_LIST_OWNERS routine was listed in lcinit.log as created.

Hope this helps.

Regards,

Deepak Kori