on 06-09-2014 3:17 PM
Hi,
Before I explain my problems I would like give you a high level overview of our server configuration:
Processors: Intel Xeon CPU E5-2620 2.00 GHz (x2) - 12 Cores
RAM: 88GB
Host OS: Windows Server 2012 R2 Standard
Network Adapter # 1 IP: 192.168.10.11 (dedicated to host OS)
Network Adapter # 2 IP: 192.168.10.12 (dedicated for Hyper-V as Virtual Switch)
Hyper-V Settings
NUMA Spanning: Allow
Enhanced Session Mode Policy (Server & User): Unchecked
On this machine, we have added Hyper-V role and installed 2 guest servers for SAP installation.
Hyper-V Guest OS 1 (EADSERV): Windows Server 2012 R2 Standard. Installed SAP ECC 6.0 using Sybase ASE 15.7 RDBMS
Hyper-V Guest OS 2 (EAPSERV): Windows Server 2012 R2 Standard. Installed SAP ECC 6.0 using Sybase ASE 15.7 RDBMS.
Both Guest VM Hyper-V Settings:
Memory: 20GB
Dynamic Memory: Disabled
Memory Weight: High
Processor: 2 Virtual processors
VM Virutal Processor reserve (percentage): 100
Network Adapter: Virtual switch from Network Adapter # 2
Now, when I start either one of two Guest VM and start SAP services then everything seems to work fine. But if I turn on another Guest VM and start SAP services then both systems SAP services would go down by loosing internal database connection. All the DIA processes would change to "Run" state from "Wait" state. The sequence of the VM startup doesn't matter. If I look at the dev_wX log files then I see below message:
C ERROR: -1 in function DoPing (SQLExecDirect failed) [line 24241]
C (30046) [08S01] [SAP][ASE ODBC Driver]Connection to the server has been lost. Connection died wh
C ile writing to socket. Socket returned error code 10054. Check the server to det
C ermine the status of any open transactions.
C syb_glob.dbsl_ca.errclass set to DBSL_EC_RESTART
B Reconnect state is entered by connection:
B 0: name = R/3, con_id = 000000000, state = INACTIVE , tx = NO , bc = NO , oc = 000, hc = NO , perm = YES, reco = YES, info = NO , timeout = 000, con_max = 255, con_opt = 255, occ = NO , prog =
B RECONNECT: rsdb/reco_trials: 3
B RECONNECT: rsdb/reco_sleep_time: 5
B RECONNECT: rsdb/reco_sync_all_server: OFF
B db_con_reconnect: reconnecting connection 0:
B 0: name = R/3, con_id = 000000000, state = INACTIVE , tx = NO , bc = NO , oc = 000, hc = NO , perm = YES, reco = YES, info = NO , timeout = 000, con_max = 255, con_opt = 255, occ = NO , prog =
B disconnecting from connection 0 ...
C DbSlDisconnect hdl: 0
C ERROR: -1 in function DbSlRollback (ROLLBACK) [line 6329]
C (30273) [08003] [SAP][ASE ODBC Driver]Attempting to use a dead connection in Rollback.
C Rollback Work (99)
B disconnected from connection 0
B opening connection 0 ...
C dbs/syb/fetchArraySize: 1000
C Thread ID:3156
C lib_dbsl 741 05/12/2014 20:35:00
C connection unquiesced
C Using dynamic link library 'C:\usr\sap\EAD\DVEBMGS00\exe\dbsybslib.dll'
C dbsybslib.dll patch info
C SAP patchlevel 0
C SAP patchno 35
C Last SYBASE DBSL patchlevel 0
C Last SYBASE DBSL patchno 35
C Last SYBASE DBSL patchcomment Sybase IQ:remote connection to IQ 16.0 SP8 (2016130)
If I try to connect to ASE using isql then it works fine. I was wondering if Sybase ASE has port conflicts with other VM? Shouldn't each VM work independently without impacting other VM's? I have already update Sybase ASE ports as per SAP Note 1729176 but still no help.
Any help or pointer would be really helpful.
Many Thanks!
Thanks Deepak for your response and apologies that I didn't this message as resolved.
I got this fixed by enabling IPv6 on host OS network adapter properties. For some reason Windows Server 2012 R2 internally communicates through this protocol and unchecking it doesn't completely disable it. Below link has more details on the problem and fix:
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Shrinivas,
1) Please check whether firewall is off ?
2) Share logs from R3trans -d command
3) Looks like your dbsl patch is 35. Can you update to atleast 121
Hope this helps
Regards,
Deepak Kori
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thanks Deepak for your response.
1) Firewall is turned off
2) Below is the output from R3trans -d command:
C:\Windows\system32>r3trans -d
This is r3trans version 6.24 (release 741 - 04.02.14 - 20:14:02 ).
unicode enabled version
2EETW169 no connect possible: "DBMS = SYBASE --- "
r3trans finished (0012).
3) The latest dbsl patch that I see on SMP is indeed 35 (Our Kernel is 7.41 64-bit Unicode)
User | Count |
---|---|
86 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.