Activate CCMS for SAP SRM with SAP DB

[Former Member]

Hi!

I would like to monitor SAP SRM 5.0 (OS: Windows, DB: SAP DB, Version 7.6.04.11) from SAP Solution Manager.

I have the following problems:

a) it is not posible to execute the tocde DB50 on SAP SRM.

b) it is not possible to see the DB monitor of SAP SRM in SAP Solution

(SAP CCMS Monitor Templates --> Database --> empty)

c)The database is integrated in tcode DB59.

Unfortunately when I execute the connection test I get:

General Connection Data

Connection Name....: SRM

Database Name......: SRM

Database Server....: olda8002

tp Profiles........: no_longer_used

DBM User...........: CONTROL

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)

Application Server: olda8002_SRM_00 (Windows NT)

1. Connect. test with "dbmcli db_state"

Successful

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

Unsuccessful system_failure

Name and Server : SRM - olda8002

DBMRFC Function : DBM_EXECUTE

Command : db_state

Error : System Error

Error Message : timeout during allocate / CPIC-CALL:

'ThSAPCMRCV' : cmRc=20 thRc=456#Timeout during connection setup

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

Unsuccessful

communication_failure

Name and Server : SRM - olda8002

DBMRFC Function : DBM_CONNECT

Error : Communication Error

Error Message : Error when opening an RFC connection

4. Connect. test with "native SQL" ( SRM )

Successful

What I have done:

I have upgraded the server as well the client software to the version 7.6.04.11

Can someone help me with suggestion?

Could it be the issue with independent path on windows or do I miss some programs?

In tcode DB59 in Connection test the following values could not be determined:

DBMRFC Release (empty)

DBMCLI Release (empty)

Thank you

regards

Thom

[former_member229109]

Hello Thom,

"a) it is not possible to execute the tocde DB50 on SAP SRM."

-> Run /ndb50n with the database connection SRM created in /ndb59.

Please give more details about errors.

"b) it is not possible to see the DB monitor of SAP SRM in SAP Solution

(SAP CCMS Monitor Templates --> Database --> empty)"

-> First fix the database connection in /ndb59.

Please let me know the version/SP of the SAP Basis on SAP Solution Manager system.

"c)The database is integrated in tcode DB59."??

You posted that you created the database connection for the database.

On the application server < Application Server: olda8002_SRM_00 > run ::

/nsm49 ->dbmrfc -> execute -> post results

/nsm59 -> SRM connection -> test connection ->

1) What are DBSL Release/DBSL Patch on the appl. Server?

2) Update with output from the /nsm49 -> dbmcli tool ::

dbmcli -s dbm_getpath IndepProgPath

3) Check that Path env. Variable of the srmadm on olda8002 adjusted with

<IndepProgPath>/bin & <IndepProgPath>/pgm

4) Test TCP/IP connections in /nsm59::

SAPDB_DBM SAP DB dbmrfc server

SAPDB_DBM_DAEMON SAP DB dbmrfc server daemon

< According your information the test connection in /ndb59 failed for :

Determine status using TCP/IP connection SAPDB_DBM (DBMRFC

command mode)

& Determine status using TCP/IP connection SAPDB_DBM_DAEMON (DBMRFC

session mode) >

Run /ndb59 -> Connection test -> select the appl. Server -> Connection test

=> /nst11 && check errors in dev_rd at the end.

/nsm21 -> check the system errors.

/nst11 -> check the errors in the corresponding dev log of WP.

Do you have blank space in the IndepProgPath path name?

Thank you and best regards, Natalia Khlopina