on 08-23-2013 3:36 AM
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:
Second node downtime:
6. Sp_help_revlogin + add sysadmin role for SAPserivce<SID> + SWPM(7.3) -> Database copy completion
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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]
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?
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
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
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.
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 "
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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]
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
Please attach dev_ms log file after you switch to second node.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Dennis
Could you check the port 3901 ?
Thanks
Ram
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
101 | |
13 | |
13 | |
11 | |
11 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.