Logon failure while starting livecache

[Former Member]

Hello All,

While starting livecache we are facing problems for SUPERDBA's login:

lcinit.log file says,

• START ****************************

liveCache LCF (restart)

-

---

installation path: /sapdb/LCF/db

operating system : SunOS

OK State OFFLINE

Starting LCF into ADMIN

OK

OK DBMServer 7.5.0 Build 035-123-123-944

Starting LCF into ONLINE

OK

Creating liveCache application procedures

ERR

-24964,ERR_EXECUTE: error in program execution

768,/sapdb/LCF/db/bin/x_python /sapdb/LCF/db/env/lapps.py -R /sapdb/LCF/db -d LCF -u superdba,*

Installing APPS

-

---

Traceback----

---

File "/sapdb/LCF/db/env/installib.py", line 374, in connectAndInstall

installRoutine (session, options)

File "/sapdb/LCF/db/env/lapps.py", line 44, in install

"APPS"

File "/sapdb/LCF/db/env/installib.py", line 159, in include

install (session, options)

File "/sapdb/LCF/db/env/APPS.py", line 75, in install

loaderCmd (session, 'USE USER %s %s' % (sapuser[0], sapuser[1]))

-

---

Command----

---

USE USER SAPLCD CONTROL

-

---

Error----

---

loader.LoaderError: [-25008] Logon failure; previous user's (SUPERDBA) connection was restored.

ERROR : liveCache LCF not restarted (see /sapdb/data/wrk/LCF/lcinit.log)

Can somebody help.

Regards,

Tushar

[Former Member · Accepted solution]

Hello Markus,

We have not loaded system tables.

Also we found out that users like SAPSID etc are same of those source system.

DB59 works fine with users of source system in Integration.

So do you want to delete users and create users on of targer system.(like control,SAPSID,SUPERDBA) or should we use same users of source system.

which are appeared on target system due to system copy.

Also should we load system tables as:

dbmcli -d SID -u control,control load_systab -u superdba,<password>

Thanks in advance

Regards,

Tushar

[former_member229109 · Accepted solution]

Hello Tushar,

-> Did you do the Homogenous liveCache copy using backup/restore?

-> please check which user you set for LCA connection in LC10 -> Integration.

-> run the SQL statement as superdba user & check if this user is listed:

select * from domain.users

-> To make sure that the lcinit script works with the correct Standard liveCache

user then you should run the commands to check the

liveCache user in the upc container:

In a dbmcli session (e.g. in LC10 -> liveCache:Monitoring -> Tools)

sql_execute user-type=SAP select user from dual

Should return this user.

When an error returns ( unknown user/password ), then no user is set.

To set the Standard user run:

dbmcli -d <SID> -n <LC-server> -u control,<control> user_sap <user>,<pwd>

( please see the SAP note 616555 for more details ).

This sets the new user in the upc container.

After that the above command should return the user.

Restart the liveCache in the LC10 transaction.

Thank you and best regards, Natalia Khlopina

[Former Member]

Hello Natalia,

Thanks a lot.

Hats off to you.

We followed the steps and problem is solved.

Regards,

Tushar

[Former Member]

Hello Markus,

I have attached same file (lcinit.log)

I tried to restart livecache but got the same error.

<b>loader.LoaderError: [-25008] Logon failure; previous user's (SUPERDBA) connection was restored.</b>

We are facing this error after system copy.Should we check users or do we need to change password of SUPERDBA.

Thanks in advance.

Regards,

Tushar

[markus_doehr2]

Did you load the system tables after the restore?

--

Markus

[markus_doehr2]

> loader.LoaderError: [-25008] Logon failure; previous

> user's (SUPERDBA) connection was restored.

> ERROR : liveCache LCF not restarted (see

> /sapdb/data/wrk/LCF/lcinit.log)

What do you see in that logfile?

--

Markus