Error in Connection Test DB59

[Former Member]

Hello,

I have a problem in connection between SAP and its database (MaxDB 7.9). When I check using DB59 -> Connection Test -> Connection Test, the check result was error. Here is the log:

Application Server:  prodbap_BAP_30                                         ( SunOS      )

   1. Connect. test with "dbmcli db_state"                                    Unsuccessful

      dbmcli_command_execute_error

      Error! Connection failed to node prodbap for database BAP:

      tp error:   connect failed

      External program terminated with exit code 2

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

      dbm_system_error

      Name and Server     : BAP - prodbap

      DBMRFC Function     : DBM_EXECUTE

      Command             : db_state

      Error               : DBM Error

      Return Code         :        -11

      Error Message       : tp error:   connect failed#

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

      dbm_system_error

      Name and Server     : BAP - prodbap

      DBMRFC Function     : DBM_CONNECT

      Error               : DBM Error

      Return Code         :        -11

      Error Message       : tp error:   connect failed#

The SAP are unable to get the database state through the db_state command. When I check using dbmcli, I was succesfully get the database state. Here is the result:

dbmcli -d BAP

dbmcli on BAP>user_logon SUPERDBA,<pwd>

OK

---

dbmcli on BAP>db_state

OK

State

ONLINE

---

I already check on KnlMsg but couldn't find any error on that log. I think that this issue is only about connecting the SAP and database but I have no idea what should I adjust.

Thanks for your help,

Kris

[JamesZ]

Hi Kris,

Is it a livecache or maxdb is the primary database of the system?

What is the result of "R3trans -d" by executing on SAP application server via user sidadm?

Best regards,

James

[Former Member]

James Zhang wrote:

Hi Kris,

Is it a livecache or maxdb is the primary database of the system?

What is the result of "R3trans -d" by executing on SAP application server via user sidadm?

Best regards,
James

Hi James,

It's a maxdb and yes, it's the primary database of the system.

Here is the result of the R3trans -d:

R3trans -d

This is R3trans version 6.24 (release 721 - 26.09.13 - 20:13:07 ).

unicode enabled version

R3trans finished (0000).

Thanks,

Kris

[JamesZ]

Hi Kris,

If the SAP system can be up? I think so.

Please do the comprehensive check as link below:

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

Best regards,
James