LiveCache connection problem

[Former Member]

Hello,

We have a SCM 7.0 system with EHP 3 with a liveCache (MaxDB 7.9.08) .

If I click the button "liveCache Monitoring with DBA Cockpit" in the TX LC10, I get the following error for each database connection (LCA, LDA and LEA) :

LCA	SQL not possible
LCA	SQL Error: 10709
LCA	Connection failed (RTE:[1] cannot connect to server socket) SBAC |
LCA	DBM not possible
LCA	Error when calling function module DBM_EXECUTE_SDB
LCA	Command:                                dbm_version
LCA	Name and Server     : LCD - <IP-Address>
LCA	Function            : DBM_EXECUTE
LCA	Command             : dbm_version
LCA	Error               : DBM Error
LCA	Return Code         :         -4
LCA	Error Message       : cannot connect to server socket
LCA	DBM Error 8  - DBM System Error

In the TX SM21 you can see the error message below:

     Database error -10709 at CON

     > Connection failed (RTE:[1] cannot connect to server socket)

Im Trace-File dev_w0 I found the following:

     Connect to LCA as SAPLCD with <IP-Address>-LCD

     Try to connect as SAPLCD/<pwd>@<IP-Address>-LCD on connection 1 ...

     *** ERROR => Connect to database failed, rc = -10709 (Connection failed (RTE:[1] cannot conn

     bmaxsql.cpp 607]

     {root-id=54217256A7094810E1008000AC110048}_{conn-id=00000000000000000000000000000000}_0

     ***LOG BY2=> sql error -10709 performing CON [dbds         919]

     ***LOG BY0=> Connection failed (RTE:[1] cannot connect to server socket) [dbds         919]

I would like to mention, that I have maintained the liveCache Integration as follows:

     Name of Database Connection: LCA (or LDA or LEA)

     liveCache Name: LDA

     liveCache Server: here I tried with the IP-address and also with the physical hostname, but none of them worked

     DBM User:

          User Name: CONTROL

          Password:    xxx

      Standard liveCache User:

          User Name: SAPLCD

          Password:    xxx

Furthermore, I have checked at database-level, the liveCache is up and running and the passwords are correct:

     dbmcli -d LCD -u control,<password> db_state

     OK

     State

     ONLINE

     dbmcli -d LCD -u saplcd,<password>

     dbmcli on LCD>

But in the TX LC10 the buttons "Start liveCache" and "Stop liveCache" are watermarked.

I have already tried to restart the liveCache and the SCM-system, but without success.

In my opinion the cause is, that the liveCache cannot be reached from the SCM-system.

Could you please advise?

Thanks a lot in advance.

Kind regards,

Noémi

[former_member229109]

Hello,

" liveCache Name: LDA" ???

Is the liveCache name LCD?

If yes then change the liveCache name to LCD in LC10-> Integration to all liveCache connections LCA/LDA/LEA.

Could you ping to the liveCache server from the application server?

Check with "ping <liveCache server name>".

Run on the application server as <applSID>adm user:

dbmcli -d LCD -n <LCD server name >-u control,<password> db_state

and post output.

Regards, Natalia Khlopina

[hugo_amo]

Hi Noemi,

Confirm whether you have installed the LiveCache kernel version as indicated in SAP Note:

1487269  - Installation of 720 kernel on SAP MaxDB-based SAP systems.

Regards,

Hugo