getting "DBM Access is Possible - NO" Error.

[Former Member]

Hi,

I have installed SCM 7.0 EHP1.

Also Installed Live Cache Server (Not Installed Client Software)

Please check the attached screenshot.

I am getting "DBM Access is Possible - NO" Error.

SAPDB_DBM and SAPDB_DBM_DAEMON RFCs are Failing.

Live Cache Client software need to install ??? (SCM and Live Cache are there in same host)

Need to copy any files into SCM Kernel ???

Pls provide SAPDB_DBM and SAPDB_DBM_DAEMON RFC properties.

-------------------------------------------------

[root@cgiu1104a bin]# ./dbmcli inst_enum

OK

7.7.07.10    /sapdb/IDL/db

[root@cgiu1104a bin]#

---------------------------------------------

Following Max DB Processes are running -

[root@cgiu1104a bin]# ps -ef |grep sdb

root     23112 10844  0 17:14 pts/1    00:00:00 grep sdb

sdb      27161     1  0 14:36 pts/0    00:00:00 /sapdb/programs/pgm/vserver start

sdb      27162 27161  0 14:36 pts/0    00:00:00 xserver.prt logger

sdb      27753     1  0 14:36 ?        00:00:00 /sapdb/IDL/db/pgm/kernel IDL -diagpipe 14

sdb      27758 27753  0 14:36 ?        00:00:14 /sapdb/IDL/db/pgm/kernel IDL -diagpipe 14

[root@cgiu1104a bin]#

-----------------------------------------------------------

RFC Trace -

**** Trace file opened at 20160403 170412 EDT, by disp+work

**** Versions SAP-REL 722,0,101 RFC-VER U 3 1656744 MT-SL

======> CPIC-CALL: 'ThSAPOCMINIT' : cmRc=2 thRc=679

Transaction program not registered

ABAP Programm: SAPLSADC (Transaction: )

User: DDIC (Client: 800)

Destination: SAPDB_DBM_DAEMON (Handle: 2, DtConId: 570122E564B30B77E10000000A0002CE, DtConCnt: 0, ConvId: ,)

EPP RootContextId: 0A1FC68A527F1EE5BEBBAB9DB9AFD293, ConnectionId: 5701137664B00B75E10000000A0002CE, ConnectionCnt: 1

EPP TransactionId: 5701222264B30B77E10000000A0002CE

SERVER> RFC Server Session (handle: 1, 20696474, {57011376-64B0-0B75-E100-00000A0002CE})

SERVER> Caller host:

SERVER> Caller transaction code: DB59 (Caller Program: SAPLSADC)

SERVER> Called function module: DBM_CONNECT_PUR

Error RFCIO_ERROR_SYSERROR in abrfcpic.c : 1732

CPIC-CALL: 'ThSAPOCMINIT' : cmRc=2 thRc=679

Transaction program not registered

DEST =SAPDB_DBM_DAEMON

HOST =%%RFCSERVER%%

PROG =dbmrfc@sapdb

cgiu1104a:id3adm 65>

---------------------------------------------------

stderr logs

/sapdb/programs/bin/dbmrfc: error while loading shared libraries: libstdc++.so.5: cannot open shared object file: No such file or directory

/sapdb/programs/bin/dbmrfc: error while loading shared libraries: libstdc++.so.5: cannot open shared object file: No such file or directory

/sapdb/programs/bin/dbmrfc: error while loading shared libraries: libstdc++.so.5: cannot open shared object file: No such file or directory

-------------------------------------------

WP Logs -

M Sun Apr  3 17:25:39 2016

M  ***LOG R49=> ThReceive, CPIC-Error (020456) [thxxhead.c   8134]

M  ***LOG R5A=> ThReceive, CPIC-Error (21998193) [thxxhead.c   8139]

M  ***LOG R64=> ThReceive, CPIC-Error ( CMSEND(SAP)) [thxxhead.c   8144]

A  RFC 3730  CONVID 21998193

A   * CMRC=20 DATA=1 STATUS=1 SAPRC=456 ThSAPCMRCV

A  RFC> ABAP Programm: SAPLSADC (Transaction: DB59)

A  RFC> User: DDIC (Client: 800)

A  RFC> Destination: SAPDB_DBM (handle: 25, DtConId: 570114DA64B00B75E10000000A0002CE, DtConCnt: 1, ConvId: 21998193,{570114DB-64B0-0B75-E100-00000A0002CE})

A  RFC> Called function module: DBM_VERSION

A  *** ERROR => RFC ======> CPIC-CALL: 'ThSAPCMRCV' : cmRc=20 thRc=456

Timeout during connection setup (check that partner exists)

[abrfcio.c    9225]

A  {root-id=0A1FC68A527F1EE5BEBBAB9DB9AFD293}_{conn-id=00000000000000000000000000000000}_0

A  *** ERROR => RFC Error RFCIO_ERROR_SYSERROR in abrfcpic.c : 3732

CPIC-CALL: 'ThSAPCMRCV' : cmRc=20 thRc=456

Timeout during connection setup (check that partner exists)

[abrfcio.c    9225]

A  {root-id=0A1FC68A527F1EE5BEBBAB9DB9AFD293}_{conn-id=00000000000000000000000000000000}_0

A  *** ERROR => RFC Error RFCIO_ERROR_MESSAGE in abrfcio.c : 1984

[abrfcio.c    9225]

A  {root-id=0A1FC68A527F1EE5BEBBAB9DB9AFD293}_{conn-id=00000000000000000000000000000000}_0

[Former Member · Accepted solution]

Myself only resolved the issue.

Upgraded Max DB to 7.7.07.50

Also, Informed OS Team to take the action as per below Note -

1191732 - Error while loading shared libraries: libstdc++.so.5 - Linux Overall Rating 0 Votes Your Rating

Version 1 Validity: 30.09.2004 - active Language English

Content:   Summary   |  Header Data   |  Product

Symptom

Linux

Install error

libstdc++.so.5

C++ runtime environment

ERROR: error while loading shared libraries: libstdc++.so.5: cannot open shared object file: No such file or directory

Resolution

The latest C++ runtime version is not installed on the system. For Linux, the gcc version 3.2.3 must be loaded.

[root@cgiu1104a ~]# whereis libstdc++.so.5

libstdc++.so: /usr/lib64/libstdc++.so.6 /usr/lib64/libstdc++.so.5

[root@cgiu1104a ~]#

[former_member229109]

Hello,

- What is the type of the DB SCM 7.0 EHP1 running on?

- What is the version of the SAP kernel with patch & MAXDB DBSL installed on the appl. server?

- What is the SAP Basis SP?

- Post the output of the command:

sdbregview -l

to see the liveCache/MAXDB software packages installed on the server.

- On the appl. server the MAXDB client software and the MADB DBSL need to be installed.

Review the SAP note 649814. And if you have installed the client/liveCache/HAXDB software as of version 7.8, the clint software installed with CL_<SID> ( SID= appl. sid), as explained in the note.

- Review the SAP note:

1448333 - Check on DBMRFC connection to SAP MaxDB/liveCache

-

"

[root@cgiu1104a bin]# ./dbmcli -tpp dummy -tpi cgiu1104a -tpc IDL -d IDL db_state

Error! Connection failed to node (local) for database IDL:

tp error: sh: tp: command not found

[root@cgiu1104a bin]#"

You run it as root. And the env is set correctly to <appl-sid>adm user.

Run it as <appl-sid>adm user.

which tp

tp -version

- As you reported the connection issues with the LCA connection test to liveCache on MAXDB on SCM system,

the correct component to get SAP support will be -  BC-DB-LVC-CCM.

Best regards, Natalia Khlopina

[Former Member]

Hi Natalia,

Type of the DB SCM 7.0 EHP1 - DB2 - 10.05.0007

Kerenl -

cgiu1104a:id3adm 100> disp+work

--------------------

disp+work information

--------------------

kernel release                722

kernel make variant           722_EXT_REL

compiled on                   Linux GNU SLES-11 x86_64 cc4.3.4 use-pr160112 for linuxx86_64

compiled for                  64 BIT

compilation mode              UNICODE

compile time                  Mar 11 2016 22:47:37

update level                  0

patch number                  101

source id                     0.101

---------------------

supported environment

---------------------

database (SAP, table SVERS)   700

                              710

                              701

                              702

                              703

                              711

                              720

                              730

                              731

                              732

operating system

Linux

cgiu1104a:id3adm 101>

SAP_BASIS    702    0006    SAPKB70206    SAP Basis Component

[root@cgiu1104a bin]# ./sdbregview -l

Server Utilities    /sapdb/programs      7.7.07.10     64 bit    valid

DB Analyzer         /sapdb/programs      7.7.07.10     64 bit    valid

PCR 7300            /sapdb/programs      7.3.00.60               valid

PCR 7301            /sapdb/programs      7.3.01.22               valid

PCR 7500            /sapdb/programs      7.5.00.51     64 bit    valid

SAP Utilities       /sapdb/programs      7.7.07.10     64 bit    valid

APO LC APPS         /sapdb/IDL/db/sap    7.00.012      64 bit    valid

Base                /sapdb/programs      7.7.07.10     64 bit    valid

Redist Python       /sapdb/programs      7.7.07.10     64 bit    valid

JDBC                /sapdb/programs      7.6.06.05               valid

Messages            /sapdb/programs      MSG 0.8507              valid

ODBC                /sapdb/programs      7.7.07.10     64 bit    valid

SQLDBC 77           /sapdb/programs      7.7.07.10     64 bit    valid

Database Kernel     /sapdb/IDL/db        7.7.07.10     64 bit    valid

Loader              /sapdb/programs      7.7.07.10     64 bit    valid

SQLDBC              /sapdb/programs      7.7.07.10     64 bit    valid

SQLDBC 76           /sapdb/programs      7.6.06.07     64 bit    valid

Fastload API        /sapdb/programs      7.7.07.10     64 bit    valid

[root@cgiu1104a bin]#

cgiu1104a:id3adm 84> tp -v

This is tp version 380.40.04 (release 722, unicode enabled)

--------------------

cgiu1104a:id3adm 85> tp -VERSION

This is tp version 380.40.04 (release 722, unicode enabled)

"-VERSION" unknown command: use "help" for an overview of possible commands

tp returncode summary:

TOOLS: Highest return code of single steps was: 0

ERRORS: Highest tp internal error was: 0203

tp finished with return code: 203

meaning:

  wrong syntax in tp call

cgiu1104a:id3adm 86>

Regards

Pradeep Shetty

[Former Member]

My Issue is still exists.

Can anyone help ?

[JamesZ]

Actually I have the same problem , but the cause is wrong password maintained

for your case, please check:

HowTo - Analyze Connection Problems in DBACockpit, DB50 and LC10 - MaxDB - SCN Wiki

[Former Member]

Hi James,

[root@cgiu1104a bin]# ./dbmcli -tpp dummy -tpi cgiu1104a -tpc IDL -d IDL db_state

Error! Connection failed to node (local) for database IDL:

tp error: sh: tp: command not found

[root@cgiu1104a bin]#

Kindly suggest

[JamesZ]

What is the problems with tp check result by following link:

SAP MaxDB CCMS - Background information - MaxDB - SCN Wiki

[Former Member]

Hi James,

It seems, tp is having issue

1. In transaction SE37 choose function module GET_DBMCONNECT_INFO_SDB. Use button Test/Execute or press F8 to execute this function module.
2. Enter the logical connection name for CON_NAME - in this example LCA. For an OLTP system this would be the SID.

Result of this is -

Test for function group	SADC
Function module	GET_DBMCONNECT_INFO_SDB

Uppercase/Lowercase

Runtime:

583 Microseconds

Import parameters

Value

CON_NAME

LCA

Export parameters

Value

DBNAME	IDL
DBSERVER	cgiu1104a
PROFILE	no_longer_used
SYSID	ID3

Please suggest

[Former Member]

Attached screenshot of SE38 -> RSADA_CHECK_SERVERS

cgiu1104a_ID3_00    cgiu1104a    cgiu1104a    cgiu1104a.XXXXXXXX    cgiu1104a    cgiu1104a_ID3_00    O.K.    Conflict within profile parameters    @01\QO.K.@    @02\Q@

[Former Member]

LCA Connectivity Errors Screenshots

[JamesZ]

livecache client is installed during SCM installation.

Please show me with the screenshot of:

lc10-> lca, integration

the two users should be control, and sap<livecache sid>

[Former Member]

Hi James,

Both users correctly assigned.

Kindly find the attached screenshots which contains LC10 -> LCA Integration

[JamesZ]

Hi Pradeep,

Please remaintain the control user's password in the integration.

This time please do verify the password is correct via below:

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

Best regards,
James

[Former Member]

Hi James,

Grateful for your quick response.

[root@cgiu1104a bin]# ./dbmcli -d IDL -u control,XXXXXXXX db_state

OK

State

ONLINE

[root@cgiu1104a bin]#

Regards

Pradeep Shetty

[JamesZ]

you are welcome, as mentioned, please use this password to remaintain the control user in the integration tab. Afterwards please let me know the result

[Former Member]

Hi James,

Still I am getting the same issue.

Please find the screenshot of LC10-> LCA

Note that - Following RFCs are still failing. .... It should work for Live Cache .. Right ???

SAPDB_DBM and SAPDB_DBM_DAEMON