LCA -- Live cache not accessible

[former_member226820]

Hi All,

We are unable to connect to our Live cache database. Here are the details and the error i'm facing while accessing LCA administration from LC10. Once i enter LC10 -->LCA below error is thrown and all the other options are disabled. even start & stop options are disabled. Our live cache is running on a standalone server which is different from our SCM server. Attached the error files screenshots below. Please check and suggest us how to troubleshoot & find root cause of this issue.

==============================================================================

Exception CX_DBA_ADBC in class CL_SDB_ADBC method DBM_EXECUTE line 82 / RC=ADBC error

Exception CX_DBA_ADBC in class CL_SDB_ADBC method DBM_EXECUTE line 82

  Kernel Error ID: 

  WP ID: 14 

  WP PID: 21491

  SYSID: LCA+

  SY-SUBRC: 1208 

  Message: ADBC error

  SQL statement: dbm_version

  Database: LCA+

caused by

Exception CX_SQL_EXCEPTION in class CL_SQL_CONNECTION 

  Kernel Error ID: 

  DB Error: No

  SQL Code: 0 

  SQL Message: 

  DB Object Exists: No

  Duplicated Key: No

  Internal Error: 10 

  Invalid Cursor: No

  Unknown Connection: Yes

  Connection Closed: No

===================================================================================

Regards,

Vihari

[former_member226820]

Thanks to all. Issue is resolved. X_server was not running. once it's started, we were able to administer the live cache smoothly.

Regards,

Vihari

[Former Member]

Hi,

In LC10 did you maintained the integration parameters? Execute LC10, enter data base connection LCA and then  press Integration button and open tab Administration Report.

Check if the Initialize and start live cache are fulfilled with the below parameters: 

Follow up processing - /SAPAPO/DELETE_LC_ANCHORS (initialize livecache)

Follow up processing - SLCA_LCK_SYNCHOWNERS (Start live cache)

Thanks,

Regards, Marius 

[former_member226820]

Hi Marius,

Yes, The above parameters are already maintained in the administration tab report.

Regards,

Vihari

[Former Member]

Hi,

Check DB59 to test the connection between DB and LiveCache. Also check the live cache IP address and name!

[former_member226820]

Yes. I have tested the connection. Same issue occurs. Check and let me know how to troubleshoot the error

[Former Member]

Hi,

Better to contact SAP support! However it seems that the SQL connection is down.

Thanks, Marius

[former_member204080]

Hi ,

Is live cache database online ,seems issue is with livecahce executable

Go to SM59 and in TCP/ICP check if below RFCs are workign or not

SAPDB_DBM_DAEMON

SAPDB_DBM

can you check below

1.Login to os level where maxDB is installed

2.Switch to LCAADM and execute below commands

dbmcli -d <Max DB instance name> -u <username>,<password>

3.Once it connects check status of database ,db_state

4.if its not online start it manually using db_online and check afterthat

Regards,

Murali