Skip to Content

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

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

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

5 Answers

  • Best Answer
    Aug 23, 2013 at 07:52 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

    • 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.

  • Aug 23, 2013 at 01:22 PM

    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 "


    Add comment
    10|10000 characters needed characters exceeded

    • Dennis Lee Americo Goncalves Qualho

      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

  • Aug 23, 2013 at 03:57 AM

    Hi Dennis

    Could you check the port 3901 ?

    Thanks

    Ram

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Aug 23, 2013 at 07:08 AM

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

    Add comment
    10|10000 characters needed characters exceeded

  • Aug 23, 2013 at 12:55 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

    • 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