Cannot open SQL connection to liveCache LCA - SCM 5.0, LC 14

[Former Member]

Good day,

After initial installation, MSSQL kernel 111 and LC 7.6.00 all working fine.

After patching the kernel to 146 and LC to 14, I get "Cannot open SQL connection to liveCache LCA" accompanied by the following in the trace files:

Loading SQLDBC client runtime ...

SQLDBC SDK Version : SQLDBC.H 7.6.0 BUILD 007-123-091-175

SQLDBC Library Version : libSQLDBC 7.6.3 BUILD 012-123-169-237

SQLDBC client runtime is MaxDB 7.6.3.012 CL 169237

SQLDBC supports new DECIMAL interface : 0

SQLDBC supports VARIABLE INPUT data : 1

Try to connect as LC5ADM/<pwd>@MBDEVSCM-LC5 on connection 1 ...

ue Apr 08 23:12:14 2008

• ERROR => Connect to database failed, rc = -4008 (POS(1) Unknown user name/password combination)

bsdbsql.cpp 200]

***LOG BY2=> sql error -4008 performing CON [dbds#1 @ 1044] [dbds 1044 ]

***LOG BY0=> POS(1) Unknown user name/password combination [dbds#1 @ 1044] [dbds 1044 ]

Connect to LCA as LC5ADM with MBDEVSCM-LC5

Try to connect as LC5ADM/<pwd>@MBDEVSCM-LC5 on connection 1 ...

My User LC5ADM does work, I can connect with a SQL_CONNECT in dbmcli.

Is the following a possibility:

Version of SQLDBC SDK Version : SQLDBC.H 7.6.0 BUILD 007-123-091-175?

My kernel versions of dbmssslib.dll and dbmssslib.pdb(146?)

Should I patch dbmssslib.dll and dbmssslib.pdb to 152(available on SAPnet).

Many Thanks in advance,

Derek

[lbreddemann · Accepted solution]

Hi Derek,

please try to enter the password in CAPITAL letters in the DBCON/DB59.

Does it work then?

KR Lars

[Former Member · Accepted solution]

Hi Lars,

Thanks for your reply, the password is an UPPER case password, it is maintained in upper case in LC10, also I can connect in dbmcli with the user and the password.

It did work until I patched LC to 7.6.3.012.

Any other ideas greatly welcomed,

Regards

[former_member229109 · Accepted solution]

Hello Derek Galt ,

You reported the problems to connect to the liveCache LC5 on the server MBDEVSCM

as user LC5ADM. I think that it's NOT a liveCache standard user, it's the OS user, please check it.

Please connect to the liveCache as SYSDBA user < SUPERDBA by default , admin is the default pwd >

and run the SQL statement 'select * from users', please update the thread with output.

The brief description of the database user types is given in the SAP note No. 25591.

Please review the additional information in the SAP notes:: 877203 &

616555 liveCache >= 7.4: Password change

=> Run the following steps:

In a dbmcli session (e.g. in LC10 -> … -> tools) :

sql_execute select * from users

Please check what user is listed as the DBA user SAPR3 or SAPLC5. I assumed the SAPLC5.

Reset the LCA/LDA/LEA connections to the correct Standard liveCache user

SAPLC5, ( default pwd 'sap' ), in LC10 -> Integration.

To make sure that the lcinit script works with the correct user 'SAPLC5' you should

run the commands to check the liveCache user in the upc container:

In a dbmcli session (e.g. in LC10 -> ...-> tools) ::

sql_execute user-type=SAP select user from dual

Should return this user.

When an error returns ( unknown user/password ), then no user or wrong user/pwd is set. To set the 'SAPLC5' user run:

< Try to connect as SAPLC5 user to check the correct password >

dbmcli -d LC5 -n <LC-server> -u control,<control> user_sap saplc5,<PWD>

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

in an dbmcli session. This sets the new user in the upc container.

After that the above command should return sapelc5.

Restart the liveCache in the LC10 transaction.

Thank you and best regards, Natalia Khlopina

[Former Member · Accepted solution]

Hi Natalia,

Thank you for your reply. I have already checked these from a previous post you have on SDN.

Here is the output of the commands for your review. The user LC5ADM is the correct user, here we go:

sql_execute select * from users

LC5>OK

END

'CONTROL';'';'CONTROL';'ADMIN';'MULTIPLE';(null);(null);(null);'DEFAULT';'20080408';'00170104';'20080408';'00170104';'20080408';'00170104';'LC5';'MBDEVSCM.neusiedler.local';0;'NO';(null)

'SUPERDBA';'';'SUPERDBA';'SYSDBA';'MULTIPLE';(null);(null);(null);'DEFAULT';'20080408';'00170104';'20080410';'00190253';'20080408';'00170104';'LC5';'MBDEVSCM.neusiedler.local';10;'NO';(null)

'SUPERDBA';'';'LC5ADM';'DBA';'MULTIPLE';(null);(null);(null);'UNICODE';'20080408';'00170116';'20080408';'00170116';'20080409';'00221530';'LC5';'MBDEVSCM.neusiedler.local';28;'NO';(null)

sql_execute user-type=SAP select user from dual

LC5>OK

END

'LC5ADM'

I have since deleted and recreated LCA, LDA and LEA.

When I tried to start LC, got the following error:

10.04.2008 19:36:32

Server: MBDEVSCM

Users: GALTD

Logical Command: DBMRFC

Parameter: exec_lcinit restart

Name and Server : LC5 - MBDEVSCM

DBMRFC Function : DBM_EXECUTE

Command : exec_lcinit restart

Error : DBM Error

Return Code : -24964

Error Message : ERR_EXECUTE: error in program execution#

Here is the contents of the trace file:

race file:

Loading SQLDBC client runtime ...

SQLDBC SDK Version : SQLDBC.H 7.6.0 BUILD 007-123-091-175

SQLDBC Library Version : libSQLDBC 7.6.3 BUILD 012-123-169-237

SQLDBC client runtime is MaxDB 7.6.3.012 CL 169237

SQLDBC supports new DECIMAL interface : 0

SQLDBC supports VARIABLE INPUT data : 1

SQLDBC supports keepAlive indicator : 0

Try to connect as LC5ADM/<pwd>@MBDEVSCM-LC5 on connection 1 ...

hu Apr 10 19:38:57 2008

• ERROR => Connect to database failed, rc = -4008 (POS(1) Unknown user name/password combination)

bsdbsql.cpp 208]

***LOG BY2=> sql error -4008 performing CON [dbds#1 @ 1044] [dbds 1044 ]

***LOG BY0=> POS(1) Unknown user name/password combination [dbds#1 @ 1044] [dbds 1044 ]

Connect to LCA as LC5ADM with MBDEVSCM-LC5

Try to connect as LC5ADM/<pwd>@MBDEVSCM-LC5 on connection 1 ...

hu Apr 10 19:38:58 2008

• ERROR => Connect to database failed, rc = -4008 (POS(1) Unknown user name/password combination)

bsdbsql.cpp 208]

***LOG BY2=> sql error -4008 performing CON [dbds#1 @ 1044] [dbds 1044 ]

***LOG BY0=> POS(1) Unknown user name/password combination [dbds#1 @ 1044] [dbds 1044 ]

Connect to LCA as LC5ADM with MBDEVSCM-LC5

Try to connect as LC5ADM/<pwd>@MBDEVSCM-LC5 on connection 1 ...

Any other suggestions will be appreciated.

Thank you and Regards,

Derek

[Former Member · Accepted solution]

Natalia,

Does the LiveCache user NEED to be SAPSID? Could this be the problem that the user is LC5ADM?

This is from the install guide:

During the installation, SAPinst prompted you to specify the DBM operator and the standard

liveCache user. The DBM operator is control. The standard liveCache user is SAP<SID> by default

but you can change this during the liveCache installation if required. The standard liveCache user

is created by the lcinit script, which is automatically executed when the liveCache is initialized.

Should I change the user to SAPSID?

Thanks

[former_member229109 · Accepted solution]

Hello Derek Galt ,

1) Yes you could change the standard liveCache user during the installation.

It was the reason that I asked you to run the SQL statement "select * from users"

& wrote "assummed that the DBA user is SAPLC5".

What user did you set for the standard liveCache user during the installation?

From the provided information, it is 'LC5ADM'. Correct?

2) Did you have problems during the liveCache/LCA upgrade?

Did you follow the SAP note 1119052 & SAP Note 875662 to update the liveCache/LCA

to SAP liveCache 5.0 LCA Build 14 patch level 002 and the corresponding liveCache kernel 7.6.03 Build 012?

3) You wrote that were able to connect to the database as LC5ADM user. Correct?

Please go to the TA /nsm49 -> dbmcli tool & run using 'dbmcli' tool::

-d LC5 -n MBDEVSCM -u control,<control> -uSQL LC5ADM,<pwd> sql_execute select * from users

"Name and Server : LC5 - MBDEVSCM

DBMRFC Function : DBM_EXECUTE

Command : exec_lcinit restart

Error : DBM Error

Return Code : -24964

Error Message : ERR_EXECUTE: error in program execution#"

==> Please post the lcinit.log file to the ticket.

4) You wrote, that you recreated the LCA/LDA & LEA connections.

Please give more details about LCA connection recreate steps. What users/passwords did you set?

Thank you and best regards, Natalia Khlopina

[Former Member · Accepted solution]

Hi Natalia,

As this is a new installation and no one has started configuring yet, I decided to get this back to "SAP Standard".

I unistalled LiveCache following the steps in the LC installation guide and also SAP Note 599129 - Uninstalling MaxDB SAP DB software using SDBUNINST.

I reinstalled LiveCache with SAPLC5 instead of LC5ADM as the LiveCache user.

After the installation, I recreated the 3 connections in LC10(LCA/LCD/LEA)

Re-initialized LiveCache, all OK.

After that, stopped and when restarted LC got the following in the trace file:

KERNEL 7.6.00 BUILD 029-123-130-265

C *** ERROR => Connect to database failed, rc = -10709 (Connection failed (RTE:Path part contains characters which must be escaped)

[dbsdbsql.cpp 208]

B ***LOG BY2=> sql error -10709 performing CON [dbds#1 @ 1044] [dbds 1044 ]

B ***LOG BY0=> Connection failed (RTE:Path part contains characters which must be escaped) [dbds#1 @ 1044] [dbds 1044 ]

B Connect to LCA as SAPLC5 with MBDEVSCM- LC5

C Try to connect as SAPLC5/<pwd>@MBDEVSCM- LC5 on connection 1 ...

So a different error now, any ideas on this one?

I'm still searching around, nothing yet.

Thank you

Edited by: Derek Galt on Apr 11, 2008 11:24 AM

[Former Member · Accepted solution]

Thanks Natalia for all your help, a couple of your posts helped me. My last problem was in the connection LDA, resolved.