Error: sql.SQLError: [-4008] (at 1) Unknown user name/password combination

[Former Member]

Hello Experts,

After a Test refresh for SCM system, we restored Livecache. The database has been changed and starts using database manager, during registration (Register LCApps) it gives the following error:

Logical Command: DBMRFC

Parameter: exec_lcinit register

Name and Server : LCQ - dusepierp12

DBMRFC Function : DBM_EXECUTE

Command : exec_lcinit register

Error : DBM Error

Return Code : -24964

Error Message : ERR_EXECUTE: error in program execution#

0,sap\lcinit LCQ register -uDBM , -uDBA , -uSQL ,

liveCache LCQ (register)

The liveCache state is ONLINE

DBMServer 7.6.04 Build 009-123-182-193

Creating liveCache application procedures

ERROR : liveCache LCQ not registered (see "s:\sapdb\data\wrk\LCQ\lcinit.log").

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

liveCache LCQ (register)

Thu 07/30/2009

10:26 PM

-

---

installation path = S:\sapdb\LCQ\db

OK

DBMServer 7.6.04 Build 009-123-182-193

Creating liveCache application procedures

ERR

-24964,ERR_EXECUTE: error in program execution

1,""S:\sapdb\LCQ\db\bin\x_python" "S:\sapdb\LCQ\db\env\lapps.py" -R "S:\sapdb\LCQ\db" -d LCQ -u DBADMIN,*"

-

---

Traceback----

---

-

---

Error----

---

sql.SQLError: [-4008] (at 1) Unknown user name/password combination

Traceback (most recent call last):

File "S:\sapdb\LCQ\db\env\lapps.py", line 38, in ?

connectAndInstall (install, install.__doc__)

File "S:\sapdb\LCQ\db\env\installib.py", line 398, in connectAndInstall

session = connect (options)

File "S:\sapdb\LCQ\db\env\installib.py", line 350, in connect

alterUserNotExclusive(options)

File "S:\sapdb\LCQ\db\env\installib.py", line 338, in alterUserNotExclusive

session.release()

AttributeError: 'NoneType' object has no attribute 'release'

ERROR : liveCache LCQ not registered

-

---

Thu 07/30/2009

10:26 PM

• END ******************************

Many Thanks,

TIA,

Nisch

[lbreddemann · Accepted solution]

>

> Hello Experts,

>

> After a Test refresh for SCM system, we restored Livecache. The database has been changed and starts using database manager, during registration (Register LCApps) it gives the following error:

> -24964,ERR_EXECUTE: error in program execution

> 1,""S:\sapdb\LCQ\db\bin\x_python" "S:\sapdb\LCQ\db\env\lapps.py" -R "S:\sapdb\LCQ\db" -d LCQ -u DBADMIN,*"

> -

---

Traceback----

---

Hi there,

looks like you entered "DBADMIN" when you created the liveCache instance in DBMGUI as the DBM Operator.

For SAP installations, this user is always named "CONTROL".

So, drop the instance again, recreate it with "CONTROL" and re-do the recovery of the liveCache backup.

regards,

Lars

[Former Member · Accepted solution]

Hi Lars,

Thanks for your response.

I tried to reload system tables are advised, but it failed with error:

S:\>dbmcli -d LCQ -u control,<pw> load_systab -u DBADMIN,<pw>

ERR

-24907,ERR_DBAWRONG: wrong SYSDBA

please advice.

Thanks,

Regards,

Nischal

[former_member229109 · Accepted solution]

Hello Nischal,

-> Did you create the SAP ticket, where this problem was reported?

-> Please review the SAP notes:

877203 Post steps after the Homogenous liveCache copy using backup/restore

457425 Homogenous liveCache copy using backup/restore

886103 System Landscape Copy for SAP SCM

-> What are the versions of the source & target database?

What are the versions of OS on source & target database? Version 7.6.04 Build 009-123-182-193?

What are the SYSDBA user/password & Standard liveCache user/password in source liveCache?

Please update with output of the dbm command 'user_getall" & SQL statement "select * from users"

< for both instances >.

Thank you and best regards, Natalia Khlopina