Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

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

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

Former Member
Former Member replied

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

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question