Skip to Content
0
Former Member
Jun 09, 2014 at 02:17 PM

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

135 Views

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!