cancel
Showing results for 
Search instead for 
Did you mean: 

Windows Server 2012 R2 Hyper-V Multiple Virtual Machines with ASE Startup Problem

Former Member
0 Kudos

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!

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

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:

Solved: Hyper-V’s VMConnect tool sporadically losing connection to VM | Nathan Evans&#...

Answers (1)

Answers (1)

former_member188883
Active Contributor
0 Kudos

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

Former Member
0 Kudos

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)

former_member188883
Active Contributor
0 Kudos

Hi Shrinivas,

Can you attach trans.log after executing r3trans -d command

Regards,

Deepak Kori