Unable to connect sap by sapgui 730

[Former Member]

Hi all,

My oracle is running.

The startsap command execute successfully as well. However, even with the sap up and running, i am not able to connect the sap system using sap gui730.

I checked the sap services by

ps -ef | grep SAP | wc -l

and I found only 11 sap running processes

but when I execute in a server that I connect sap by sapgui i have

46 SAP running processes.

I dont know if this can be the problems.

Please help me to solve this issue.

best regards

Ernesto

[csaba_goetz · Accepted solution]

Hello Ernesto,

However, even with the sap up and running, i am not able to connect the sap system using sap gui730.

What is the error you get?

You can check the status of processes with <sid>adm user by

sapcontrol -nr <instance nr.> -host <hostname> -prot NI_HTTP -function GetProcessList

command. Let us know the result.

Best regards,

Adam

[Former Member · Accepted solution]

Hi Adam,

I start the oracle database and sap, but when i want to connect sap via sapgui it returns the error

Partner ‘172.16.0.200:sapdp00’ not reached

WSAEXCONNREFUSED: Connection refused

Please find bellow the output of the command  sapcontrol -nr 00 -host srvmap20 -prot NI_HTTP -function GetProcessList

srvmap20:dsvadm 123> sapcontrol -nr 00 -host srvmap20 -prot NI_HTTP -function GetProcessList

18.07.2013 10:23:16

GetProcessList

OK

name, description, dispstatus, textstatus, starttime, elapsedtime, pid

msg_server, MessageServer, GREEN, Running, 2013 07 18 10:04:23, 0:18:53, 46572

disp+work, Dispatcher, GRAY, Stopped, , , 46573

rslgcoll, Central Syslog Collector, GREEN, Running, 2013 07 18 10:04:23, 0:18:53, 46574

rslgsend, Central Syslog Sender, GREEN, Running, 2013 07 18 10:04:23, 0:18:53, 46575

igswd_mt, , GREEN, Running, 2013 07 18 10:04:23, 0:18:53, 46576

srvmap20:dsvadm 124>

Best regards

Ernesto

[csaba_goetz · Accepted solution]

Hello Ernesto,

Partner ‘172.16.0.200:sapdp00’ not reached
WSAECONNREFUSED: Connection refused

This error comes because dispatcher is simply not running, therefore it is nothing to connect to.

disp+work, Dispatcher, GRAY, Stopped, , , 46573

This shows the same, dispatcher is not running.

First of all you need to check dev_disp and dev_wNN traces. There you can find more information about the root cause. If you have doubt, just attach (not copy the content but attach) these traces to this discussion.

Best regards,

Adam

[Former Member · Accepted solution]

Hi Adam,

I had already asked these stuff to Ernesto as I was the first one who answered this thread (Please check the developer-files, starting with dev_disp one.)...

Regards,

Andre

[csaba_goetz · Accepted solution]

Hi Andre, Yes you did it indeed 🙂 BR, Adam

[former_member188883 · Accepted solution]

Hi Ernesto,

I doubt some shared memory bottleneck in the system.

Please also share the output of command

sidadm> sappfpar -check pf=<path of instance profile>

Ensure that there no errors in the output.

Hope this helps.

Regards,

Deepak Kori

[Former Member · Accepted solution]

Hi all again,

Thank you so much once more for your suggestions.

I have attached the output of dev_disp.

All the dev_w* logs are empty.

I am sorry A. Wahjudi for not replaying on time.

I am also checking the logs but I would be very if you too help me again in these issue.

Best regards

Ernesto

dev_disp.txt.zip

[Former Member · Accepted solution]

Hi Ernesto,

I checked your dev_disp logfile, and I think somehow the hostname between your SAP system and the actual hostname of your server is inconsistent.

If you have a new installation, this is maybe during your input parameter, or else there was some change in the host-file or network configuration.

Check the /etc/hosts entry and check the result of uname -n, if this is "consistent"

dev_disp:

***LOG Q0I=> NiPGetHostByName: hostname 'localhost' not found: gethostbyname [niuxi.c 1477]

*** ERROR => NiGetLoopbackAddr: NiIGetNodeAddr failed (rc=-2) [nixx.c       1894]

*** ERROR => NiDgHdlBindName: invalid hostname 'localhost' (rc=-2;hdl 0) [nixx.c

3659]

*** ERROR => DpCommInit: NiDgHdlBindName failed: -8 [dpxxdisp.c   10302]

*** DP_FATAL_ERROR => DpSapEnvInit: DpCommInit

*** DISPATCHER EMERGENCY SHUTDOWN ***

dev_rd:

GwPrintMyHostAddr: my host addresses are :

  1 : [172.16.0.200] srvmap20.bancomoc.mz (HOSTNAME)

  2 : [127.0.0.1] localhost (LOCALHOST)

Full qualified hostname = srvmap20.bancomoc.mz

I hope this will help you.

Regards,

Andre

[csaba_goetz · Accepted solution]

Hello Ernesto,

In addition to Andre's A. Wahjudi memo:

You can check the correct hostname resolution by running this command as <sid>adm:

niping -v -H localhost

This must be consistent in both directions (both hostname to address and address to hostname):

localhost is resolved to 127.0.0.1

127.0.0.1 is resolved to localhost

e.g.:

probud2:bcsadm 52>  niping -v -H localhost

Hostname/Nodeaddr verification:
===============================

[...]

Lookup of hostname: localhost                                (NiHostToAddr)
    --> IP-Addr.: 127.0.0.1
Lookup of IP-Addr.: 127.0.0.1                                (NiAddrToHost)
    --> Hostname: localhost

Adam

[Former Member · Accepted solution]

Hi all again,

I really had probolem with

dsvadm#niping -v -H localhost

But now, i have solved it . Now, niping -v -H localhost doesnt return error.

srvmap20:dsvadm 23> niping -v -H localhost

Hostname/Nodeaddr verification:

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

  Hostname of local computer: srvmap20

  Lookup of hostname: srvmap20

    --> IP-Addr.: 172.16.0.200

Lookup of IP-Addr.: 172.16.0.200

    --> Hostname: srvmap20

  Lookup of hostname: localhost

    --> IP-Addr.: 127.0.0.1

Lookup of IP-Addr.: 127.0.0.1

    --> Hostname: localhost

Thank you so much, but I am still in trouble and I am getting crazy.

The SAP still return the error when logging through sapgui.

I am checking the dev_disp and there are some error.(please take a look to the attached file)

I am working on it but I still count on you.

Thanks a lot to all of you. Since I posted this issue I have been running through to solution with your valuable suggestions.

Ernesto

dev_disp_1907.txt.zip

[Former Member · Accepted solution]

Hi Ernesto,

When you have solved the niping-issue, the hostname is srvmap20.

Now I saw in your new dev_disp it uses: srvmap20_DSV_00

So you need to find out where is this come from: Please check your SAP-profiles.

dev_disp:

>>Fri Jul 19 09:23:33 2013

rdisp/http_min_wait_dia_wp : 1 -> 1

***LOG Q0K=> DpMsAttach, mscon ( srvmap20) [dpxxdisp.c   12778]

DpStartStopMsg: send start message (myname is >srvmap20_DSV_00                         <)

DpStartStopMsg: start msg sent

CCMS: start to initalize 3.X shared alert area (first segment).

*** ERROR => DpWPCheck: W0 (pid 3972) died (severity=0, status=65280) [dpxxdisp.c   15891]

child (pid=3972) exited with exit code 255

I hope this will help you.

Regards,

Andre

[Former Member · Accepted solution]

Hi Alberto,

Now we cant trace error by checking dev_disp log.

Please attach latest dev_w* log. But i doubt this is due to missing cryptolib files from kernel.

Please check do you have sapcryptolib files in kernel and make sure that parameter

snc/enable = 0 in DEFAULT .PFL or Instance profile instead of snc/enable = 1

.

I am not sure about this...For more analysis we need latest dev_w* logs.

Regards,

Surojit

[Former Member · Accepted solution]

Thank you guys,

You are very smart.

The last thing to do was to change the parameter snc/enable from 1 to 0.

Now I am a normal again because of your help.

Thank you Surojit Guha, A. Wahjudi, Adam Csaba Goetz, A. Wahjudi

Ernesto

[Former Member · Accepted solution]

Hi Ernesto,

I'm glad that you are back to "normal" now.

You did have several problems to solve, and one of them was the hostname, that's why your SAP couldn't start in the first place.

And I did found this via the dev_disp log, which I asked you, despite that other people said "Now we cant trace error by checking dev_disp log"

And by default is the parameter snc/enable value=0, so you need to know what you need for your environment and why you did changed this to 1 previously.

I'm just surprised to see that you have marked this snc parameter as the "correct answer"....

Regards,

Andre

[Former Member]

Hi Alberto,,

Please check SAP Note

1872990 - various error messages related to incorrect resolution of localhost

The workproces use "localhost" for internal communications. Please check whether the entries in /etc/hosts are correct or paste /etc/hosts file here.

Please check if such entry exists in /etc/hosts:

127.0.0.1       localhost

Please award point if this helps.

If this also doesn't helps please provide us trace 2 file of dev_disp. I want to check details of part of below lines because it can be network issue also.

*** ERROR => NiDgHdlBindName: invalid hostname 'localhost' (rc=-2;hdl 0) [nixx.c       3659]

*** ERROR => DpCommInit: NiDgHdlBindName failed: -8 [dpxxdisp.c   10302]

*** DP_FATAL_ERROR => DpSapEnvInit: DpCommInit

*** DISPATCHER EMERGENCY SHUTDOWN ***

Regards,

Surojit

[former_member188883]

Hi Ernesto,

Please check the results from following

1) ps -eaf | grep dw

2) ps -eaf | grep ms

3) Share dev_rd logs

4) Share output log from R3trans -d command

Regards,

Deepak Kori

[Former Member]

Hi Deepak,

Thank u so much by replay.

Please find the output of the commands.

1) ps -eaf | grep dw

     dsvadm 47538 44801  0 10:11:26 pts/tb    0:00 grep dw

2) ps -eaf | grep ms

    root    37     0  0 21:46:47 ?         0:00 usbmsd

    root    36     0  0 21:46:47 ?         0:00 lvmschedd

cimsrvr  1892  1891  0 21:50:20 ?         0:16 cimservermain --executor-socket 4

    root  1891     1  0 21:50:20 ?         0:01 /opt/wbem/lbin/cimserver

    root  2109     1  0 21:50:51 ?         0:00 /etc/opt/resmon/lbin/emsagent

    root  2053     1  0 21:50:46 ?         0:00 /opt/omni/lbin/kms

  dsvadm 46572 46514  0 10:04:23 ?         0:00 ms.sapDSV_DVEBMGS00 pf=/usr/sap/DSV/SYS/profile/DSV_DVEBMGS00_srvmap20

    root 15665     1  0 23:09:06 ?         0:00 /usr/sbin/stm/uut/bin/tools/monitor/msamon

    root 15674     1  0 23:09:08 ?         0:00 /usr/sbin/stm/uut/bin/tools/monitor/msamon_sas

  dsvadm 47583 44801  0 10:11:50 pts/tb    0:00 grep ms

3) Share dev_rd logs

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

trc file: "dev_rd", trc level: 1, release: "700"

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

Sat Jun 29 01:18:07 2013

***LOG S00=> GwInitReader, gateway started ( 16522) [gwxxrd.c     1759]

systemid   274 (HP (IA-64) with HP-UX)

relno      7000

patchlevel 0

patchno    331

intno      20050900

make:      single threaded, ASCII, 64 bit, optimized

pid        16522

gateway runs with dp version 247(ext=110) (@(#) DPLIB-INT-VERSION-247)

gateway (version=700.2011.12.02)

gw/reg_no_conn_info = 0

gw/local_addr : 0.0.0.0

* SWITCH TRC-RESOLUTION from 1 TO 1

gw/process_external_ping = 1

Sat Jun 29 01:18:08 2013

CCMS: Initalizing shared memory of size 40000000 for monitoring segment.

CCMS: Checking Downtime Configuration of Monitoring Segment.

Bind service sapgw00 (socket) to port 3300

GwIRegInitRegInfo: reg_info file /usr/sap/DSV/DVEBMGS00/data/reginfo not found

GwPrintMyHostAddr: my host addresses are :

  1 : [172.16.0.200] srvmap20.bancomoc.mz (HOSTNAME)

  2 : [127.0.0.1] localhost (LOCALHOST)

Full qualified hostname = srvmap20.bancomoc.mz

DpSysAdmExtCreate: ABAP is active

DpSysAdmExtCreate: VMC (JAVA VM in WP) is not active

Sat Jun 29 01:18:17 2013

DpShMCreate: sizeof(wp_adm)             30608   (1224)

DpShMCreate: sizeof(tm_adm)             5351424 (26624)

DpShMCreate: sizeof(wp_ca_adm)          22912   (76)

DpShMCreate: sizeof(appc_ca_adm)        7600    (76)

DpCommTableSize: max/headSize/ftSize/tableSize=500/16/552048/552064

DpShMCreate: sizeof(comm_adm)           552064  (1088)

DpSlockTableSize: max/headSize/ftSize/fiSize/tableSize=0/0/0/0/0

DpShMCreate: sizeof(slock_adm)          0       (104)

DpFileTableSize: max/headSize/ftSize/tableSize=0/0/0/0

DpShMCreate: sizeof(file_adm)           0       (72)

DpShMCreate: sizeof(vmc_adm)            0       (1760)

DpShMCreate: sizeof(wall_adm)           (25648/36736/80/104)

DpShMCreate: sizeof(gw_adm)     48

DpShMCreate: SHM_DP_ADM_KEY             (addr: c00000000f400000, size: 6035120)

DpShMCreate: allocated sys_adm at c00000000f400000

DpShMCreate: allocated wp_adm at c00000000f401de0

DpShMCreate: allocated tm_adm_list at c00000000f409570

DpShMCreate: allocated tm_adm at c00000000f4095d0

DpShMCreate: allocated appc_ca_adm at c00000000f929750

DpShMCreate: allocated comm_adm at c00000000f92b500

DpShMCreate: system runs without slock table

DpShMCreate: system runs without file table

DpShMCreate: allocated vmc_adm_list at c00000000f9b2180

DpShMCreate: allocated gw_adm at c00000000f9b2200

DpShMCreate: system runs without vmc_adm

DpShMCreate: allocated ca_info at c00000000f9b2230

MtxInit: -2 0 0

DpRqQInit: Parameter rdisp/queue_lock_level = 2

Sat Jun 29 01:18:19 2013

GwDpInit: attached to gw_adm at c00000000f9b2200

Mon Jul  1 19:00:22 2013

caught SIGINT (2)

***LOG S30=> GwStopGateway, gateway stopped () [gwxxrd.c     15104]

4) Share output log from R3trans -d command

This is R3trans version 6.14 (release 700 - 26.10.11 - 13:00:00).

R3trans finished (0000).

[Former Member]

Hi Ernesto,

Please check the developer-files, starting with dev_disp one.

Also the result and log of R3trans -d, as a check that the connection to the DB is OK.

If you noticed that there are way less sap running processes, then there should be an error mentioned there in the developer-files.

You could also check using dpmon, to check the status of your work-processes (like SM50 overview) from the OS-level. Are they all "running"? You should compare the amount of them with the amount defined in your profile.

Also check the Oracle alert.log file, just to make sure everything is OK there.

I hope this will help you.

Regards,

Andre