Livecache Connection Error

[Former Member]

Hi Everyone,

There seems to be some peculiar problem in our SCM system, where in there is no connection possible to livecache although the livecache is online, no authorization problems or anything except that it says

"Connect. test with session mode "dbmrfc db_state" Unsuccessful"

Below is the error I get when trying to connect to livecache

Name and Server : L9D - z3gmvd09

DBMRFC Function : DBM_EXECUTE

Command : dbm_version

Error : DBM Error

Return Code : -16

Error Message : command timeout exceeded

General Connection Data

Connection Name....: LCA

Database Name......: L9D

Database Server....: z3gmvd09

Test Scope

1. Execute an external operating system command (DBMCLI)

2. Determine status using TCP/IP connection SAPDB_DBM (DBMRFC command mode)

3. Determine status using TCP/IP connection SAPDB_DBM_DAEMON (DBMRFC session mode)

4. Test the SQL connection (Native SQL at CON_NAME)

This is the log of the connection test from the Livecache Alert Monitor.

Application Server: z3gmvd09_A9D_00 ( HP-UX )

1. Connect. test with "dbmcli db_state" Successful

2. Connect. test with command mode "dbmrfc db_state" Successful

3. Connect. test with session mode "dbmrfc db_state" Unsuccessful

dbm_system_error

Name and Server : L9D - z3gmvd09

DBMRFC Function : DBM_EXECUTE

Command : db_state

Error : DBM Error

Return Code : -16

Error Message : command timeout exceeded

4. Connect. test with "native SQL" ( LCA ) Successful

Below is the work process trace file;

Tue Feb 24 15:56:23 2009

B Connect to LCA as SAPL9D with z3gmvd09-L9D

C Try to connect as SAPL9D/<pwd>@z3gmvd09-L9D on connection 1 ...

C Attach to SAP DB : Kernel 7.6.03 Build 012-123-169-237

C Database release is SAP DB 7.6.03.012

C INFO : Database 'L9D' instance is running on 'z3gmvd09'

C INFO : LVC DEFAULTCODE = UNICODE

C INFO : Connect to DB as 'SAPL9D'

C Command info enabled

C Now I'm connected to SAP DB

C 01: z3gmvd09-L9D, since=20090224155623, ABAP= <unknown> (0)

B Connection 1 opened (DBSL handle 1)

B Wp Hdl ConName ConId ConState TX PRM RCT TIM MAX OPT Date Time DBHost

B 001 000 R/3 000000000 INACTIVE NO YES NO 000 255 255 20090223 040838 z3gmvd09

B 001 001 LCA 001000247 ACTIVE NO NO NO 004 255 255 20090224 155623 z3gmvd09

B 001 002 LEA 001000243 DISCONNECTED NO NO NO 000 255 255 20090224 145734 z3gmvd09

B 001 003 L9D 001000011 DISCONNECTED NO NO NO 000 255 255 20090121 104613 z3gmvd09

B 001 004 R/3*INACT_PACK 001000231 DISCONNECTED NO NO NO 000 255 255 20090224 014733 z3gmvd09

B 001 005 R/3*TIMESTAMP 001000236 DISCONNECTED NO NO NO 004 255 255 20090224 142550 z3gmvd09

B 001 006 R/3*BWDIM 001000199 DISCONNECTED NO NO NO 000 255 255 20090220 114725 z3gmvd09

B 001 007 R/3* 001000230 DISCONNECTED NO NO NO 004 255 255 20090224 013218 z3gmvd09

B 001 008 R/3*BWMON 001000237 DISCONNECTED NO NO NO 000 255 255 20090224 144234 z3gmvd09

B 001 009 R/3*DTPLOG 001000222 DISCONNECTED NO NO NO 000 255 255 20090223 140732 z3gmvd09

B 001 010 R/3*BWSLG1LOG 000005659 DISCONNECTED NO NO NO 000 255 255 20090218 155720 z3gmvd09

B 001 011 R/3*_RSD 001000246 DISCONNECTED NO NO NO 000 255 255 20090224 152734 z3gmvd09

C

C Tue Feb 24 16:12:34 2009

C Disconnecting from connection 1 ...

C Now I'm disconnected from SAP DB

B Disconnected from connection con_da={LCA,1000247,1}

M

M Tue Feb 24 16:34:54 2009

M *** ERROR => SosIAnchorArrayCreatable: T19/M0 in state cancel [thxxtool2.c 946]

M

M Tue Feb 24 16:36:15 2009

M *** ERROR => SosIAnchorArrayCreatable: T19/M0 in state cancel [thxxtool2.c 946]

B Connect to LCA as SAPL9D with z3gmvd09-L9D

C Try to connect as SAPL9D/<pwd>@z3gmvd09-L9D on connection 1 ...

C *** ERROR => Connect to database failed, rc = -10709 (Connection failed (RTE:database not running: no request pipe))

[dbsdbsql.cpp 208]

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

B ***LOG BY0=> Connection failed (RTE:database not running: no request pipe) [dbds#1 @ 1044] [dbds 1044 ]

M

M Tue Feb 24 16:36:24 2009

M *** ERROR => SosIAnchorArrayCreatable: T25/M0 in state cancel [thxxtool2.c 946]

M

M Tue Feb 24 16:40:00 2009

M *** ERROR => SosIAnchorArrayCreatable: T29/M0 in state cancel [thxxtool2.c 946]

M

M Tue Feb 24 16:49:15 2009

M *** ERROR => SosIAnchorArrayCreatable: T29/M0 in state cancel [thxxtool2.c 946]

M

M Tue Feb 24 16:55:43 2009

M *** ERROR => SosIAnchorArrayCreatable: T29/M0 in state cancel [thxxtool2.c 946]

Kindly help.

EV

[Former Member · Accepted solution]

Check this link

[Former Member · Accepted solution]

Hi Mahesh,

Thanks! Yes your solution worked. Actually in the note they are asking to upgrade the MaxDb client version. But current workaround is to input Parameter n value as suggested.

Cheers

EV

[Former Member]

Hi,

Make an Entry in the users parameter as

DBM_SMODE value is N. check for this SAP Note 1128989

And try for test connection.

Mahesh