dev_disp: *** ERROR => NiPConnect2: SiPeekPendConn failed for hdl

[former_member211576]

Hi experts,

  I install a non shared disk cluster on SQL 2012 AlwaysOn like the procedure below. It runs on first node without any problems.

However, when I fail over ASCS to second node, I always get an error: login not possible(error in license check). I check every item in the KBA: 1512766 and I find it can't connect to MS on second node. I try to restart SAP servers but the problem persists, please help.

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

Thu Aug 22 17:58:59 2013

***LOG Q0I=> NiPConnect2: 10.243.23.60:3901: connect (10061: WSAECONNREFUSED: Connection refused) [nixxi.cpp 3286]

*** ERROR => NiPConnect2: SiPeekPendConn failed for hdl 17/sock 1232

    (SI_ECONN_REFUSE/10061; I4; ST; 10.243.23.60:3901) [nixxi.cpp    3286]

*** ERROR => MsIAttachEx: NiBufConnect to sapgrptcd/3901 failed (rc=NIECONN_REFUSED) [msxxi.c 718]

***LOG Q0L=> DpLoopInit, nomscon () [dpxxdisp.c   1801]

CCMS: SemInMgt: Semaphore Management initialized by AlAttachShm_Doublestack.

CCMS: SemInit: Semaphore 38 initialized by AlAttachShm_Doublestack.

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

DpAppcBlksLow: max appc blocks in queue is 1000 (50 %)

DpWpBlksLow: max wp blocks in queue is 1600 (80 %)

Thu Aug 22 17:59:40 2013

***LOG Q0I=> NiPConnect2: 10.243.23.60:3901: connect (10061: WSAECONNREFUSED: Connection refused) [nixxi.cpp 3286]

*** ERROR => NiPConnect2: SiPeekPendConn failed for hdl 49/sock 1544

    (SI_ECONN_REFUSE/10061; I4; ST; 10.243.23.60:3901) [nixxi.cpp    3286]

*** ERROR => MsIAttachEx: NiBufConnect to sapgrptcd/3901 failed (rc=NIECONN_REFUSED) [msxxi.c 718]

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

First node downtime:

1. 1.     1. 70SWPM -> System copy -> First node
2. 2.     2. Change dbs/mss/server & SAPDBHOST to node 1
3. 3.     3. 70SWPM -> System copy -> Database instance

Second node downtime:

1. 1.     4. 70SWPM -> System copy -> Additional node
2. 2.     5. Change SAPDBHost and dbs/mss/server to AG Listener

  6.     Sp_help_revlogin + add sysadmin role for SAPserivce<SID> + SWPM(7.3) -> Database copy completion

[former_member211576 · Accepted solution]

Hi SS,

  There is no programs running on port sapmsTCD 3601.

Hi Roman,

  I search the word "error" but no results found. But there is no msg_server.exe running after I started SAP instance. What is the log file of msg_server.exe? dev_ms?

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

trc file: "dev_ms", trc level: 1, release: "721"

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

[Thr 78904] Thu Aug 22 17:58:54 2013

[Thr 78904] ms/http_max_clients = 500 -> 500

[Thr 78904] MsSSetTrcLog: trc logging active, max size = 52428800 bytes

systemid   562 (PC with Windows NT)

relno      7210

patchlevel 0

patchno    42

intno      20020600

make       multithreaded, Unicode, 64 bit, optimized

pid        286072

[Thr 78904] ***LOG Q01=> MsSInit, MSStart (Msg Server 1 286072) [msxxserv.c   2292]

[Thr 78904] MsInitAclInfo: acl file C:\usr\sap\TCD\SYS\global\ms_acl_info.DAT not found, unrestricted access

[Thr 78904] MsGetOwnIpAddr: my host addresses are :

[Thr 78904]   1 : [192.168.28.232] tccqas2.qcisap.corp (HOSTNAME)

[Thr 78904]   2 : [127.0.0.1] tccqas2.qcisap.corp (LOCALHOST)

[Thr 78904]   3 : [10.243.23.232] tccqas2.qcisap.corp (NILIST)

[Thr 78904]   4 : [10.243.23.55] iscsigrptcd (NILIST)

[Thr 78904]   5 : [10.243.23.58] clusgrptcd (NILIST)

[Thr 78904]   6 : [10.243.23.59] dbgrptcd (NILIST)

[Thr 78904]   7 : [10.243.23.60] sapgrptcd (NILIST)

[Thr 78904]   8 : [192.168.28.55] tfcap3.qcisap.corp (NILIST)

[Thr 78904] Thu Aug 22 17:58:55 2013

[Thr 78904]   9 : [169.254.2.227] tccqas2.qcisap.corp (NILIST)

[Thr 78904] MsHttpInit: full qualified hostname = tccqas2.qcisap.corp

[Thr 78904] HTTP logging is switch off

[Thr 78904] set HTTP state to LISTEN

[Thr 78904] *** HTTP port 8101 state LISTEN ***

[Thr 78904] MsHttpOwnDomain: own domain[1] = qcisap.corp

[Thr 78904] *** I listen to port sapmsTCD (3601) ***

[Thr 78904] *** HTTP port 8101 state LISTEN ***

[Thr 78904] CUSTOMER KEY: >J0960849691<

[Thr 78904] build version=721.2013.01.17

[Former Member · Accepted solution]

What hostname you have used in installation for ASCS instance? You have configuration problems in HA environment. You message server (after failover) take hostname as tccqas2.qcisap.corp but need to have sapgrptcd as hostname. Therefore you receive 10061 (WSAECONNREFUSED) error:

***LOG Q0I=> NiPConnect2: 10.243.23.60:3901: connect (10061: WSAECONNREFUSED: Connection refused) [nixxi.cpp 3286]

*** ERROR => NiPConnect2: SiPeekPendConn failed for hdl 49/sock 1544

    (SI_ECONN_REFUSE/10061; I4; ST; 10.243.23.60:3901) [nixxi.cpp    3286]

*** ERROR => MsIAttachEx: NiBufConnect to sapgrptcd/3901 failed (rc=NIECONN_REFUSED) [msxxi.c 718]

[former_member211576 · Accepted solution]

Hi Roman,

   Could I install Central instance in the second node of cluster? I install first node and second node and I think the SAPLOCALHOST and SAPLOCALHOSTFULL is correct. That's sapgrptcd(vhostname).

  However, I install central instance in the second and I find probably SAP installer sets OS environment variables SAPLOCALHOST to tccqas2. I find this already sets in instance profile: TCD_ASCS01_sapgrptcd( SAPLOCALHOST = sapgrptcd )and it is what I want. So I remove this OS environment variables.

  But I can't login the second node still because SAPLOCALHOSTFULL is still tccqas2(not the clsuter vhostname). I check everywhere(start, instance profile, OS environment variables and registry but there is no such a setting there. Although I set SAPLOCALHOSTFULL in the instance profile, it is overwritten. Where is it located beside the places I mention above?

[Former Member · Accepted solution]

Your message server can't be reached via rdisp/mshost. Check profile parameter rdisp/mshost in DEFAULT.PFL. It should be your vhostname. Also check that your vhostname sapgrptcd (and its ip address 10.243.23.60) correctly failover between nodes in cluster with ASCS instance.

[former_member211576 · Accepted solution]

Hi Roman,

   This is my default.pfl. It is strange that when I failover to the second node, instance(TCD_ASCS01_sapgrptcd) can't get these parameters correctly. Please see screenshot below.

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

SAPSYSTEMNAME = TCD

SAPGLOBALHOST = sapgrptcd

system/type = ABAP

SAPFQDN = qcisap.corp

SAPLOCALHOSTFULL = $(SAPLOCALHOST).$(SAPFQDN)

rdisp/mshost = sapgrptcd

rdisp/msserv = sapmsTCD

rdisp/msserv_internal = 3901

enque/process_location = REMOTESA

enque/serverhost = sapgrptcd

enque/serverinst = 01

is/HTTP/show_detailed_errors = FALSE

icf/user_recheck = 1

gw/acl_mode = 1

icm/HTTP/ASJava/disable_url_session_tracking = TRUE

service/protectedwebmethods = SDEFAULT

rsec/ssfs_datapath = $(DIR_GLOBAL)$(DIR_SEP)security$(DIR_SEP)rsecssfs$(DIR_SEP)data

rsec/ssfs_keypath = $(DIR_GLOBAL)$(DIR_SEP)security$(DIR_SEP)rsecssfs$(DIR_SEP)key

enque/deque_wait_answer = TRUE

ssf/name = SAPSECULIB

login/system_client = 100

rsdb/ssfs_connect = 0

login/no_automatic_user_sapstar = 0

SAPDBHOST = DBGRPTCD

dbms/type = mss

dbs/mss/server = DBGRPTCD

dbs/mss/dbname = TCD

dbs/mss/schema = tcd

[former_member211576 · Accepted solution]

Hi Roman,

   I suspect because I install CI in the second node, ASCS use the wrong /sapmnt(c:\usr\sap, not \vhostname\sapmnt) and DIR_EXE(c:\usr\sap\..., not s(shared disk):\usr\sap )

If I filter sapmnt in the first node, it will return a lot.

[Former Member · Accepted solution]

Please run

>ipconfig /all

command and attach output to message. Please run it twice: on node where ASCS instance works correctly and then perform failover and run the same on second node.

I any way you need to read carefully installation guide about HA installation.

[former_member211576 · Accepted solution]

Hi Roman,

   FYI. I will read system copy guide of SWPM 1.0. again later.

--  1st node ---------------------------------------------------

Windows IP Configuration

   Host Name . . . . . . . . . . . . : tccdbm2

   Primary Dns Suffix  . . . . . . . : qcisap.corp

   Node Type . . . . . . . . . . . . : Hybrid

   IP Routing Enabled. . . . . . . . : No

   WINS Proxy Enabled. . . . . . . . : No

   DNS Suffix Search List. . . . . . : qcisap.corp

Ethernet adapter 28:

   Connection-specific DNS Suffix  . :

   Description . . . . . . . . . . . : Intel(R) 82576 Gigabit Dual Port Network Connection #2

   Physical Address. . . . . . . . . : 60-EB-69-DB-FD-2A

   DHCP Enabled. . . . . . . . . . . : No

   Autoconfiguration Enabled . . . . : Yes

   Link-local IPv6 Address . . . . . : fe80::2c7b:8b80:f301:a7a6%15(Preferred)

   IPv4 Address. . . . . . . . . . . : 192.168.28.235(Preferred)

   Subnet Mask . . . . . . . . . . . : 255.255.255.0

   IPv4 Address. . . . . . . . . . . : 192.168.28.55(Preferred)

   Subnet Mask . . . . . . . . . . . : 255.255.255.0

   Default Gateway . . . . . . . . . :

   DHCPv6 IAID . . . . . . . . . . . : 459336553

   DHCPv6 Client DUID. . . . . . . . : 00-01-00-01-19-87-6C-94-60-EB-69-DB-FD-2B

   DNS Servers . . . . . . . . . . . : 192.168.28.76

192.168.28.143

   Primary WINS Server . . . . . . . : 192.168.28.76

   Secondary WINS Server . . . . . . : 192.168.28.143

   NetBIOS over Tcpip. . . . . . . . : Disabled

Ethernet adapter 23:

   Connection-specific DNS Suffix  . :

   Description . . . . . . . . . . . : Intel(R) 82576 Gigabit Dual Port Network Connection

   Physical Address. . . . . . . . . : 60-EB-69-DB-FD-2B

   DHCP Enabled. . . . . . . . . . . : No

   Autoconfiguration Enabled . . . . : Yes

   Link-local IPv6 Address . . . . . : fe80::a817:aff:a937:df84%12(Preferred)

   IPv4 Address. . . . . . . . . . . : 10.243.23.235(Preferred)

   Subnet Mask . . . . . . . . . . . : 255.255.255.0

   IPv4 Address. . . . . . . . . . . : 10.243.23.55(Preferred)

   Subnet Mask . . . . . . . . . . . : 255.255.255.0

   IPv4 Address. . . . . . . . . . . : 10.243.23.60(Preferred)

   Subnet Mask . . . . . . . . . . . : 255.255.255.0

   Default Gateway . . . . . . . . . : 10.243.23.253

   DHCPv6 IAID . . . . . . . . . . . : 258009961

   DHCPv6 Client DUID. . . . . . . . : 00-01-00-01-19-87-6C-94-60-EB-69-DB-FD-2B

   DNS Servers . . . . . . . . . . . : 10.243.16.11

10.243.17.11

   Primary WINS Server . . . . . . . : 10.243.16.13

   Secondary WINS Server . . . . . . : 10.243.17.13

   NetBIOS over Tcpip. . . . . . . . : Disabled

Tunnel adapter Local Area Connection* 11:

   Connection-specific DNS Suffix  . :

   Description . . . . . . . . . . . : Microsoft Failover Cluster Virtual Adapter

   Physical Address. . . . . . . . . : 02-10-C6-48-4B-FC

   DHCP Enabled. . . . . . . . . . . : No

   Autoconfiguration Enabled . . . . : Yes

   Link-local IPv6 Address . . . . . : fe80::c019:954a:b7cf:6c7e%18(Preferred)

   IPv4 Address. . . . . . . . . . . : 169.254.1.62(Preferred)

   Subnet Mask . . . . . . . . . . . : 255.255.0.0

   Default Gateway . . . . . . . . . :

   DHCPv6 IAID . . . . . . . . . . . : 453120692

   DHCPv6 Client DUID. . . . . . . . : 00-01-00-01-19-87-6C-94-60-EB-69-DB-FD-2B

   NetBIOS over Tcpip. . . . . . . . : Enabled

Tunnel adapter isatap.{84C4AA9E-B5CE-4750-AFF9-CD884C456844}:

   Media State . . . . . . . . . . . : Media disconnected

   Connection-specific DNS Suffix  . :

   Description . . . . . . . . . . . : Microsoft ISATAP Adapter

   Physical Address. . . . . . . . . : 00-00-00-00-00-00-00-E0

   DHCP Enabled. . . . . . . . . . . : No

   Autoconfiguration Enabled . . . . : Yes

Tunnel adapter isatap.{946EF63C-8BA9-421C-8F6A-F9FCE701AB13}:

   Media State . . . . . . . . . . . : Media disconnected

   Connection-specific DNS Suffix  . :

   Description . . . . . . . . . . . : Microsoft ISATAP Adapter #2

   Physical Address. . . . . . . . . : 00-00-00-00-00-00-00-E0

   DHCP Enabled. . . . . . . . . . . : No

   Autoconfiguration Enabled . . . . : Yes

Tunnel adapter isatap.{C0F3FE3D-B2A1-4903-9194-90E810581B9B}:

   Media State . . . . . . . . . . . : Media disconnected

   Connection-specific DNS Suffix  . :

   Description . . . . . . . . . . . : Microsoft ISATAP Adapter #3

   Physical Address. . . . . . . . . : 00-00-00-00-00-00-00-E0

   DHCP Enabled. . . . . . . . . . . : No

   Autoconfiguration Enabled . . . . : Yes

--  2nd node ---------------------------------------------------

Windows IP Configuration

   Host Name . . . . . . . . . . . . : tccqas2

   Primary Dns Suffix  . . . . . . . : qcisap.corp

   Node Type . . . . . . . . . . . . : Hybrid

   IP Routing Enabled. . . . . . . . : No

   WINS Proxy Enabled. . . . . . . . : No

   DNS Suffix Search List. . . . . . : qcisap.corp

Ethernet adapter 23:

   Connection-specific DNS Suffix  . :

   Description . . . . . . . . . . . : Intel(R) 82576 Gigabit Dual Port Network Connection #2

   Physical Address. . . . . . . . . : 60-EB-69-DB-FC-FD

   DHCP Enabled. . . . . . . . . . . : No

   Autoconfiguration Enabled . . . . : Yes

   Link-local IPv6 Address . . . . . : fe80::921:fdb5:5dc3:fe7c%15(Preferred)

   IPv4 Address. . . . . . . . . . . : 10.243.23.232(Preferred)

   Subnet Mask . . . . . . . . . . . : 255.255.255.0

   IPv4 Address. . . . . . . . . . . : 10.243.23.58(Preferred)

   Subnet Mask . . . . . . . . . . . : 255.255.255.0

   IPv4 Address. . . . . . . . . . . : 10.243.23.59(Preferred)

   Subnet Mask . . . . . . . . . . . : 255.255.255.0

   Default Gateway . . . . . . . . . : 10.243.23.253

   DHCPv6 IAID . . . . . . . . . . . : 459336553

   DHCPv6 Client DUID. . . . . . . . : 00-01-00-01-19-87-6F-00-60-EB-69-D2-97-25

   DNS Servers . . . . . . . . . . . : 10.243.16.11

10.243.17.11

   Primary WINS Server . . . . . . . : 10.243.16.13

   Secondary WINS Server . . . . . . : 10.243.17.13

   NetBIOS over Tcpip. . . . . . . . : Disabled

Ethernet adapter 28:

   Connection-specific DNS Suffix  . :

   Description . . . . . . . . . . . : Intel(R) 82576 Gigabit Dual Port Network Connection

   Physical Address. . . . . . . . . : 60-EB-69-DB-FC-FC

   DHCP Enabled. . . . . . . . . . . : No

   Autoconfiguration Enabled . . . . : Yes

   Link-local IPv6 Address . . . . . : fe80::5874:a0ef:da46:efad%14(Preferred)

   IPv4 Address. . . . . . . . . . . : 192.168.28.232(Preferred)

   Subnet Mask . . . . . . . . . . . : 255.255.255.0

   Default Gateway . . . . . . . . . :

   DHCPv6 IAID . . . . . . . . . . . : 392227689

   DHCPv6 Client DUID. . . . . . . . : 00-01-00-01-19-87-6F-00-60-EB-69-D2-97-25

   DNS Servers . . . . . . . . . . . : 192.168.28.76

192.168.28.143

   Primary WINS Server . . . . . . . : 192.168.28.76

   Secondary WINS Server . . . . . . : 192.168.28.143

   NetBIOS over Tcpip. . . . . . . . : Disabled

Tunnel adapter Local Area Connection* 11:

   Connection-specific DNS Suffix  . :

   Description . . . . . . . . . . . : Microsoft Failover Cluster Virtual Adapter

   Physical Address. . . . . . . . . : 02-45-03-6E-AE-72

   DHCP Enabled. . . . . . . . . . . : No

   Autoconfiguration Enabled . . . . : Yes

   Link-local IPv6 Address . . . . . : fe80::8d8:3813:b09b:9c85%18(Preferred)

   IPv4 Address. . . . . . . . . . . : 169.254.2.180(Preferred)

   Subnet Mask . . . . . . . . . . . : 255.255.0.0

   Default Gateway . . . . . . . . . :

   DHCPv6 IAID . . . . . . . . . . . : 453173337

   DHCPv6 Client DUID. . . . . . . . : 00-01-00-01-19-87-6F-00-60-EB-69-D2-97-25

   NetBIOS over Tcpip. . . . . . . . : Enabled

Tunnel adapter isatap.{0417C9EA-FCAE-471E-8D13-A01537B462BA}:

   Media State . . . . . . . . . . . : Media disconnected

   Connection-specific DNS Suffix  . :

   Description . . . . . . . . . . . : Microsoft ISATAP Adapter

   Physical Address. . . . . . . . . : 00-00-00-00-00-00-00-E0

   DHCP Enabled. . . . . . . . . . . : No

   Autoconfiguration Enabled . . . . : Yes

Tunnel adapter isatap.{B473C541-AB4D-41B1-9F56-20E3C150C83F}:

   Media State . . . . . . . . . . . : Media disconnected

   Connection-specific DNS Suffix  . :

   Description . . . . . . . . . . . : Microsoft ISATAP Adapter #2

   Physical Address. . . . . . . . . : 00-00-00-00-00-00-00-E0

   DHCP Enabled. . . . . . . . . . . : No

   Autoconfiguration Enabled . . . . : Yes

Tunnel adapter isatap.{EFB39F5B-E1E3-4041-A5EB-CF2F523744FB}:

   Media State . . . . . . . . . . . : Media disconnected

   Connection-specific DNS Suffix  . :

   Description . . . . . . . . . . . : Microsoft ISATAP Adapter #3

   Physical Address. . . . . . . . . : 00-00-00-00-00-00-00-E0

   DHCP Enabled. . . . . . . . . . . : No

   Autoconfiguration Enabled . . . . : Yes

[former_member211576 · Accepted solution]

Hi Roman & Americo,

  Thanks for your helps. I finally solve this problem. I found the DIR_INSTALL and DIR_PROFILE is located in the central instance directory.(c:\usr\sap\...)

  So the solution is simple. I just one line DIR_INSTALL = \\sapgrptcd\sapmnt\TCD\sys in TCD_ASCS01_sapgrptcd. Problem solved.

[americo_goncalvesqualho]

The License mechanism relies on the message server.

If the message server is not up and running you'll get

" login not possible(error in license check "

[former_member211576]

Hi Americo,

   Thanks. I know. That's why I am troubleshooting MS issue. The message server and dialog instance are ok but ASCS and DI don't get the parameters correctly.

[americo_goncalvesqualho]

ok, can you please confirm that the message server is properly responding on the 3901 port?

lgtst -H sapgrptcd -S 3901

[americo_goncalvesqualho]

Please also use this command to confirm that DI doesn't get the parameters correctly:

sapcontrol -nr 00 -function ParameterValue rdisp/mshost

[former_member211576]

Hi Americo,

--- lgtst -H sapgrptcd -S 3901 ---

using trcfile: dev_lg

[Thr 4744]

[Thr 4744] *********************************************************************

********

[Thr 4744] *

[Thr 4744] *  ERROR       partner 'sapgrptcd:3901' not reached

[Thr 4744] *

[Thr 4744] *  TIME        Sat Aug 24 09:00:06 2013

[Thr 4744] *  RELEASE     721

[Thr 4744] *  COMPONENT   NI (network interface)

[Thr 4744] *  VERSION     40

[Thr 4744] *  RC          -10

[Thr 4744] *  MODULE      nixxi.cpp

[Thr 4744] *  LINE        3286

[Thr 4744] *  DETAIL      NiPConnect2: 10.243.23.60:3901

[Thr 4744] *  SYSTEM CALL connect

[Thr 4744] *  ERRNO       10061

[Thr 4744] *  ERRNO TEXT  WSAECONNREFUSED: Connection refused

[Thr 4744] *  COUNTER     1

[Thr 4744] *

[Thr 4744] *********************************************************************

********

[Thr 4744]

[former_member211576]

Hi Americo,

   Instance number 00 is DI. Instance number 01 is ASCS.

S:\usr\sap\TCD\SYS\profile>sapcontrol -nr 00 -function ParameterValue rdisp/msho

st

24.08.2013 09:12:56

ParameterValue

FAIL: HTTP error, HTTP/1.1 401 Unauthorized

S:\usr\sap\TCD\SYS\profile>sapcontrol -nr 01 -function ParameterValue rdisp/msho

st

24.08.2013 09:16:49

ParameterValue

OK

[former_member184473]

Hello Dennis,

When you face the issue on second, execute a "R3trans -d" (without quotation marks) and provide the trans.log generated.

Also, do you have the environment and profile variables correctly set on both nodes (note 1886616)?

Regards,

Eduardo Rezende

[former_member211576]

Hi Eduardo,

   I think r3trans is ok on the second node.

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

4 ETW000 r3trans version 6.23 (release 721 - 15.01.13 - 20:13:01 ).

4 ETW000 unicode enabled version

4 ETW000 ===============================================

4 ETW000

4 ETW000 date&time   : 23.08.2013 - 23:34:43

4 ETW000 control file: pf=s:\usr\sap\tcd\sys\profile\default.pfl

4 ETW000 R3trans was called as follows: r3trans -d pf=s:\usr\sap\tcd\sys\profile\default.pfl

4 ETW000  trace at level 2 opened for a given file pointer

4 ETW000  [     dev trc,00000]  Fri Aug 23 23:34:44 2013                                               12278  0.012278

4 ETW000  [     dev trc,00000]  db_con_init called                                                        56  0.012334

4 ETW000  [     dev trc,00000]  set_use_ext_con_info(): usage of ssfs switched off (rsdb/ssfs_connect=0)

4 ETW000                                                                                                 134  0.012468

4 ETW000  [     dev trc,00000]  determine_block_commit: no con_hdl found as blocked for con_name = R/3

4 ETW000                                                                                                  31  0.012499

4 ETW000  [     dev trc,00000]  create_con (con_name=R/3)                                                 15  0.012514

4 ETW000  [     dev trc,00000]  Loading DB library 'dbmssslib.dll' ...                                  1433  0.013947

4 ETW000  [     dev trc,00000]  DlLoadLib success: LoadLibrary("dbmssslib.dll"), hdl 0, addr 000007F98A040000

4 ETW000                                                                                               40894  0.054841

4 ETW000  [     dev trc,00000]      using "S:\usr\sap\TCD\SYS\exe\uc\NTAMD64\dbmssslib.dll"               19  0.054860

4 ETW000  [     dev trc,00000]  Library 'dbmssslib.dll' loaded                                            20  0.054880

4 ETW000  [     dev trc,00000]  function DbSlExpFuns loaded from library dbmssslib.dll                    22  0.054902

4 ETW000  [     dev trc,00000]  Version of 'dbmssslib.dll' is "721.02", patchlevel (0.44)              20054  0.074956

4 ETW000  [     dev trc,00000]  function dsql_db_init loaded from library dbmssslib.dll                  678  0.075634

4 ETW000  [     dev trc,00000]  function dbdd_exp_funs loaded from library dbmssslib.dll                  29  0.075663

4 ETW000  [     dev trc,00000]  New connection 0 created                                                2557  0.078220

4 ETW000  [     dev trc,00000]  0: name = R/3, con_id = -000000001, state = DISCONNECTED, tx = NO , bc = NO , hc = NO , perm = YES, reco = NO , frco = NO , timeout = 000, con_max = 255, con_opt = 255, occ = NO , prog = 

4 ETW000                                                                                                  57  0.078277

4 ETW000  [     dev trc,00000]  db_con_connect (con_name=R/3)                                             23  0.078300

4 ETW000  [     dev trc,00000]  determine_block_commit: no con_hdl found as blocked for con_name = R/3

4 ETW000                                                                                                  25  0.078325

4 ETW000  [     dev trc,00000]  find_con_by_name found the following connection:                          16  0.078341

4 ETW000  [     dev trc,00000]  0: name = R/3, con_id = 000000000, state = DISCONNECTED, tx = NO , bc = NO , hc = NO , perm = YES, reco = NO , frco = NO , timeout = 000, con_max = 255, con_opt = 255, occ = NO , prog = 

4 ETW000                                                                                                  36  0.078377

4 ETW000  [     dev trc,00000]  Thread ID:10008                                                         8895  0.087272

4 ETW000  [     dev trc,00000]  Thank You for using the SLODBC-interface                                  29  0.087301

4 ETW000  [     dev trc,00000]  Using dynamic link library 'S:\usr\sap\TCD\SYS\exe\uc\NTAMD64\dbmssslib.dll'

4 ETW000                                                                                                  35  0.087336

4 ETW000  [     dev trc,00000]  dbmssslib.dll patch info                                                  30  0.087366

4 ETW000  [     dev trc,00000]    SAP patchlevel  0                                                       59  0.087425

4 ETW000  [     dev trc,00000]    SAP patchno  100                                                        20  0.087445

4 ETW000  [     dev trc,00000]    Last MSSQL DBSL patchlevel 0                                            23  0.087468

4 ETW000  [     dev trc,00000]    Last MSSQL DBSL patchno         44                                      18  0.087486

4 ETW000  [     dev trc,00000]    Last MSSQL DBSL patchcomment DBSL support for Microsoft ODBC Driver 11 for SQL Server (1816426)

4 ETW000                                                                                                  32  0.087518

4 ETW000  [     dev trc,00000]  ODBC Driver chosen: SQL Server Native Client 11.0 native                 443  0.087961

4 ETW000  [     dev trc,00000]  Network connection used from tccqas2 to DBGRPTCD using tcp:DBGRPTCD      134  0.088095

4 ETW000  [     dev trc,00000]  Network connection used from tccqas2 to DBGRPTCD using tcp:DBGRPTCD    28713  0.116808

4 ETW000  [     dev trc,00000]  Network connection used from tccqas2 to DBGRPTCD using tcp:DBGRPTCD     4759  0.121567

4 ETW000  [     dev trc,00000]  Driver: sqlncli11.dll Driver release: 11.00.3000                        4303  0.125870

4 ETW000  [     dev trc,00000]  GetDbRelease: 11.00.3000.00                                              491  0.126361

4 ETW000  [     dev trc,00000]  GetDbRelease: Got DB release numbers (11,0,3000,0)                        36  0.126397

4 ETW000  [     dev trc,00000]  Connection 0 opened (DBSL handle 0)                                     8111  0.134508

4 ETW000  [     dev trc,00000]  NTAB: Structure of NTAB on DB is VERS_B                                14051  0.148559

4 ETW000  [     dev trc,00000]  NTAB: unicodelg of executable is 2                                        26  0.148585

4 ETW000  [     dev trc,00000]  NTAB: unicodelg of SVERS in nametab is 2                                  17  0.148602

4 ETW000  [     dev trc,00000]  NTAB: standalone processing                                             4143  0.152745

4 ETW000  [     dev trc,00000]  NTAB: ntprofile(), read profile                                           33  0.152778

4 ETW000  [     dev trc,00000]  NTAB: rsdb/ntab/entrycount 1000.                                          20  0.152798

4 ETW000  [     dev trc,00000]  NTAB: rsdb/ntab/ftabsize 500.                                             15  0.152813

4 ETW000  [     dev trc,00000]  NTAB: rsdb/ntab/irbdsize 100.                                             15  0.152828

4 ETW000  [     dev trc,00000]  NTAB: rsdb/ntab/sntabsize 100.                                            14  0.152842

4 ETW000  [     dev trc,00000]  NTAB: compute_hash_card: 2003.                                            26  0.152868

4 ETW000  [     dev trc,00000]  NTAB: maxcnt 1000.                                                        30  0.152898

4 ETW000  [     dev trc,00000]  NTAB: hfactor 2003.                                                       14  0.152912

4 ETW000  [     dev trc,00000]  NTAB: mem_protocol_size 112                                               14  0.152926

4 ETW000  [     dev trc,00000]  NTAB: hdr_backpack_offset 0                                               16  0.152942

4 ETW000  [     dev trc,00000]  NTAB: hdr_backpack_size 0                                                 14  0.152956

4 ETW000  [     dev trc,00000]  NTAB: FTAB: header_size 88.                                               14  0.152970

4 ETW000  [     dev trc,00000]  NTAB: FTAB: item_size 64.                                                 15  0.152985

4 ETW000  [     dev trc,00000]  NTAB: FTAB: item_cnt 1000.                                                14  0.152999

4 ETW000  [     dev trc,00000]  NTAB: FTAB: unit_size 4                                                   13  0.153012

4 ETW000  [     dev trc,00000]  NTAB: FTAB: unit_cnt 128000.                                              15  0.153027

4 ETW000  [     dev trc,00000]  NTAB: FTAB: data_size 512000.                                             58  0.153085

4 ETW000  [     dev trc,00000]  NTAB: IREC: header_size 88.                                               19  0.153104

4 ETW000  [     dev trc,00000]  NTAB: IREC: item_size 64.                                                 15  0.153119

4 ETW000  [     dev trc,00000]  NTAB: IREC: item_cnt 250.                                                 14  0.153133

4 ETW000  [     dev trc,00000]  NTAB: IREC: unit_size 16                                                  15  0.153148

4 ETW000  [     dev trc,00000]  NTAB: IREC: unit_cnt 6400.                                                14  0.153162

4 ETW000  [     dev trc,00000]  NTAB: IREC: data_size 102400.                                             15  0.153177

4 ETW000  [     dev trc,00000]  NTAB: STAB: header_size 88.                                               14  0.153191

4 ETW000  [     dev trc,00000]  NTAB: STAB: item_size 64.                                                 14  0.153205

4 ETW000  [     dev trc,00000]  NTAB: STAB: item_cnt 250.                                                 15  0.153220

4 ETW000  [     dev trc,00000]  NTAB: STAB: unit_size 4                                                   13  0.153233

4 ETW000  [     dev trc,00000]  NTAB: STAB: unit_cnt 25600.                                               15  0.153248

4 ETW000  [     dev trc,00000]  NTAB: STAB: data_size 102400.                                             14  0.153262

4 ETW000  [     dev trc,00000]  NTAB: TTAB: header_size 200.                                              15  0.153277

4 ETW000  [     dev trc,00000]  NTAB: TTAB: item_size 40.                                                 14  0.153291

4 ETW000  [     dev trc,00000]  NTAB: TTAB: item_cnt 1000.                                                14  0.153305

4 ETW000  [     dev trc,00000]  NTAB: TTAB: unit_size 256                                                 15  0.153320

4 ETW000  [     dev trc,00000]  NTAB: TTAB: unit_cnt 1000.                                                14  0.153334

4 ETW000  [     dev trc,00000]  NTAB: TTAB: data_size 256000.                                             15  0.153349

4 ETW000  [     dev trc,00000]  NTAB: FTAB: hh_p 2e3dd60, hh_len 88                                      528  0.153877

4 ETW000  [     dev trc,00000]  NTAB: FTAB: aa_p 6b4bec0, aa_len 16024                                    22  0.153899

4 ETW000  [     dev trc,00000]  NTAB: FTAB: ia_p 6b4fd60, ia_len 64000                                    17  0.153916

4 ETW000  [     dev trc,00000]  NTAB: FTAB: dat_p 6b5f770, dat_len 512000                                 16  0.153932

4 ETW000  [     dev trc,00000]  NTAB: IREC: hh_p 2e3ddc0, hh_len 88                                       15  0.153947

4 ETW000  [     dev trc,00000]  NTAB: IREC: aa_p 6bdc780, aa_len 16024                                    16  0.153963

4 ETW000  [     dev trc,00000]  NTAB: IREC: ia_p 6be0620, ia_len 16000                                    19  0.153982

4 ETW000  [     dev trc,00000]  NTAB: IREC: dat_p d290080, dat_len 102400                                 20  0.154002

4 ETW000  [     dev trc,00000]  NTAB: STAB: hh_p 2e3de20, hh_len 88                                       16  0.154018

4 ETW000  [     dev trc,00000]  NTAB: STAB: aa_p 6be44b0, aa_len 16024                                    16  0.154034

4 ETW000  [     dev trc,00000]  NTAB: STAB: ia_p 6be8350, ia_len 16000                                    15  0.154049

4 ETW000  [     dev trc,00000]  NTAB: STAB: dat_p d2a9090, dat_len 102400                                 16  0.154065

4 ETW000  [     dev trc,00000]  NTAB: TTAB: hh_p 2e3e820, hh_len 200                                      15  0.154080

4 ETW000  [     dev trc,00000]  NTAB: TTAB: aa_p d2c20a0, aa_len 16024                                    16  0.154096

4 ETW000  [     dev trc,00000]  NTAB: TTAB: ia_p d2c5f40, ia_len 40000                                    16  0.154112

4 ETW000  [     dev trc,00000]  NTAB: TTAB: dat_p d2cfb90, dat_len 256000                                 18  0.154130

4 ETW000  [     dev trc,00000]  NTAB: ntab_mem_protocol 2e3e820, ntab_mp_p 2e3e820, ntab_proc_id 0        25  0.154155

4 ETW000  [     dev trc,00000]  NTAB: FTAB: hh_p 2e3dd60, ha_list 6b4bec0, hi_list 6b4fd60, buffer 6b5f770

4 ETW000                                                                                                  75  0.154230

4 ETW000  [     dev trc,00000]  NTAB: IREC: hh_p 2e3ddc0, ha_list 6bdc780, hi_list 6be0620, buffer d290080

4 ETW000                                                                                                  26  0.154256

4 ETW000  [     dev trc,00000]  NTAB: STAB: hh_p 2e3de20, ha_list 6be44b0, hi_list 6be8350, buffer d2a9090

4 ETW000                                                                                                  26  0.154282

4 ETW000  [     dev trc,00000]  NTAB: TTAB: hh_p 2e3e890, ha_list d2c20a0, hi_list d2c5f40, buffer d2cfb90

4 ETW000                                                                                                  27  0.154309

4 ETW000  [     dev trc,00000]  NTAB: mem_handler: alloc for 500 elems, task 0, art 0                     22  0.154331

4 ETW000  [     dev trc,00000]  NTAB: mem_handler: alloc for 500 elems, task 0, art 1                     28  0.154359

4 ETW000  [     dev trc,00000]  NTAB: mem_handler: alloc for 500 elems, task 0, art 2                     26  0.154385

4 ETW000  [     dev trc,00000]  NTAB: mem_handler: alloc for 500 elems, task 0, art 3                     25  0.154410

4 ETW000  [     dev trc,00000]  { db_rtab( fcode = 'RT_READ_ONLY', tname = 'TADIR' ) {twdbcall.c:764}

4 ETW000                                                                                                4938  0.159348

4 ETW000  [     dev trc,00000]  } db_rtab( fcode = 'RT_READ_ONLY', retcode = 0 )                        2906  0.162254

4 ETW000  [     dev trc,00000]  { db_rtab( fcode = 'RT_READ_ONLY', tname = 'MTSETTINGS' ) {twdbcall.c:764}

4 ETW000                                                                                                1515  0.163769

4 ETW000  [    dbcrtab ,00000]  ***LOG BZ9=>table MTSETTINGS does not exist in nametab                   449  0.164218

4 ETW000  [     dev trc,00000]  } db_rtab( fcode = 'RT_READ_ONLY', retcode = 32 )                         27  0.164245

4 ETW000 Connected to DBMS = MSSQL ---  SERVER = 'DBGRPTCD' DBNAME = 'TCD' --- SYSTEM = 'TCD'.

4 ETW000  [     dev trc,00000]  { db_rtab( fcode = 'RT_INSERT', tname = 'PATCHHIST' ) {saprel.c:1479}

4 ETW000                                                                                                2208  0.166453

4 ETW000  [     dev trc,00000]  } db_rtab( fcode = 'RT_INSERT', retcode = 0 )                           1598  0.168051

4 ETW000  [     dev trc,00000]  { dsql_open (con_da=(0,R/3),#binds=0,#input=0,                            55  0.168106

4 ETW000                          name=UNKNOWN, stmtid=NULL,

4 ETW000                          stmt="SELECT EXECUTABLE,SAPRELEASE,HOSTNAME,PLATFORM,DBVENDOR,TIMESTAMP,PATCHNO,DBSLPATCHN FROM  ...")

4 ETW000  [     dev trc,00000]  } dsql_open()=0, *cu_id_p=1                                              551  0.168657

4 ETW000  [     dev trc,00000]  { dsql_fetch (con_da=(0,R/3),cu_id=1,#output=8)                           34  0.168691

4 ETW000  [     dev trc,00000]  } dsql_fetch()=0, rec_cnt=1, mod_cnt=1                                    78  0.168769

4 ETW000  [     dev trc,00000]  { dsql_close (con_da=(0,R/3),cu_id=1)                                     21  0.168790

4 ETW000  [     dev trc,00000]  } dsql_close()=0                                                          20  0.168810

4 ETW000  [     dev trc,00000]  { db_rtab( fcode = 'RT_DELETE', tname = 'PATCHHIST' ) {saprel.c:1591}

4 ETW000                                                                                                  27  0.168837

4 ETW000  [     dev trc,00000]  } db_rtab( fcode = 'RT_DELETE', retcode = 0 )                            544  0.169381

4 ETW690 COMMIT "0" "0"

4 ETW000  [     dev trc,00000]  db_con_commit (con_da={R/3,0,0},th_commit=1,tx=1,hold_cursor=0)           95  0.169476

4 ETW000  [     dev trc,00000]  dbsync[db_syflush]: to_be_committed = 1                                   23  0.169499

4 ETW000  trace to file pointer closed

4 ETW000  trace at level 1 opened for a given file pointer

4 ETW000

4 ETW000 ================== STEP 1 =====================

4 ETW000 date&time        : 23.08.2013 - 23:34:44

4 ETW000 function         : CONNECT

4 ETW000 buffersync       : YES

4 ETW000 clients          : default

4 ETW000 commit           : 100000

4 ETW000 table cache      : dynamic

4 ETW000

4 ETW000  [     dev trc,00000]  Disconnecting from ALL connections:                                     9069  0.009069

4 ETW000  [     dev trc,00000]  Disconnected from connection 0                                          2666  0.011735

4 ETW000  [     dev trc,00000]  statistics db_con_commit (com_total=1, com_tx=1)                          29  0.011764

4 ETW000  [     dev trc,00000]  statistics db_con_rollback (roll_total=0, roll_tx=0)                      21  0.011785

4 ETW000 Disconnected from database.

4 ETW000 End of Transport (0000).

4 ETW000 date&time: 23.08.2013 - 23:34:44

[Former Member]

Please attach dev_ms log file after you switch to second node.

[Sriram2009]

Hi Dennis

Could you check the port 3901 ?

Thanks

Ram