Virtual unit integration health failed

[former_member652383]

Hi Experts,

We have deployed an HA scenario, since the last week our integration VU is not working in one of the servers, we try to solve this but we don't know why is not working (the VU are working before we install the WUpdate)

The logs that we have are:

01:06:40.217 (09924) ALW> LogManager: Application [webclient] version [7.0.4.100] in virtual unit [Integration] in computer [server1] with process id [fde7759d-974a-4d52-a6aa-f5e3ab017565] since [2019-12-28 01:06:39]

01:06:40.218 (09924) ALW> LogManager: Global log level = warning

01:06:40.218 (09924) ALW> LogManager: EventCollection log level = inherited

01:06:40.218 (09924) ALW> LogManager: Webclient log level = inherited

01:06:40.218 (09924) ALW> LogManager: Network log level = inherited

01:06:40.218 (09924) ALW> LogManager: Database log level = inherited

01:06:40.218 (09924) ALW> LogManager: Security log level = inherited

01:06:40.218 (09924) ALW> LogManager: ObjectManagement log level = inherited

01:06:40.218 (09924) ALW> LogManager: CommonLib log level = inherited

01:06:40.218 (09924) ALW> LogManager: BcmApi log level = inherited

01:06:40.218 (09924) ALW> LogManager: LibIpc log level = inherited

01:06:40.218 (09924) ALW> Webclient version = 7.0.4.0, SAP BCM 7.0.4.100

01:06:40.218 (09924) ALW> Windows process id = 8564

01:08:14.862 (10764) ERR> ODBCConnection::SetAutoCommit : No connection : Connected = [false]

01:08:14.862 (10764) ERR> SQLExecute failed (CONFIG/01000/[Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionRead (recv()).|CONFIG/08S01/[Microsoft][ODBC SQL Server Driver][DBNETLIB]General network error. Check your network documentation.) : Connected = [false]

01:08:14.862 (10764) ERR> Database = [CONFIG], SQLState = [01000], errorCode = [10054] : [Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionRead (recv()).

01:08:14.862 (10764) ERR> Database = [CONFIG], SQLState = [08S01], errorCode = [11] : [Microsoft][ODBC SQL Server Driver][DBNETLIB]General network error. Check your network documentation.

01:08:14.955 (10764) ERR> ODBCConnection::SetAutoCommit : No connection : Connected = [false]

01:08:14.956 (10764) ERR> SQLExecute failed (OPERATIVE/01000/[Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionRead (recv()).|OPERATIVE/08S01/[Microsoft][ODBC SQL Server Driver][DBNETLIB]General network error. Check your network documentation.) : Connected = [false]

01:08:14.956 (10764) ERR> Database = [OPERATIVE], SQLState = [01000], errorCode = [10054] : [Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionRead (recv()).

01:08:14.956 (10764) ERR> Database = [OPERATIVE], SQLState = [08S01], errorCode = [11] : [Microsoft][ODBC SQL Server Driver][DBNETLIB]General network error. Check your network documentation.

01:08:14.957 (10764) ERR> ODBCConnection::SetAutoCommit : No connection : Connected = [false]

01:08:14.957 (10764) ERR> SQLExecute failed (DIRECTORY/01000/[Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionRead (recv()).|DIRECTORY/08S01/[Microsoft][ODBC SQL Server Driver][DBNETLIB]General network error. Check your network documentation.) : Connected = [false]

01:08:14.958 (10764) ERR> Database = [DIRECTORY], SQLState = [01000], errorCode = [10054] : [Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionRead (recv()).

01:08:14.958 (10764) ERR> Database = [DIRECTORY], SQLState = [08S01], errorCode = [11] : [Microsoft][ODBC SQL Server Driver][DBNETLIB]General network error. Check your network documentation.

01:08:14.961 (10764) ERR> ODBCConnection::SetAutoCommit : No connection : Connected = [false]

01:08:14.962 (10764) ERR> SQLExecute failed (OUTBOUND/01000/[Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionRead (recv()).|OUTBOUND/08S01/[Microsoft][ODBC SQL Server Driver][DBNETLIB]General network error. Check your network documentation.) : Connected = [false]

01:08:14.962 (10764) ERR> Database = [OUTBOUND], SQLState = [01000], errorCode = [10054] : [Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionRead (recv()).

01:08:14.963 (10764) ERR> Database = [OUTBOUND], SQLState = [08S01], errorCode = [11] : [Microsoft][ODBC SQL Server Driver][DBNETLIB]General network error. Check your network documentation.

01:08:29.753 (08576) ALW> TerminateExtension complete:

Requests=0

TotalClients=0

PeakClients=0

PeakUsers=0

PeakAnonynousUsers=0

01:08:29.753 (08576) ALW> Unload v 7.0.4.0, SAP BCM 7.0.4.100

In the server 2, the integrartion is working without problems.

[Former Member]

Hi,

Like Dawood said the 7.0.4.100 is extremely old version and strong recommendation is to investigate options to upgrade. As the jump from SP4 Patch 1 to latest FP15 is quite high I recommend to consult an partner in this upgrade project.

Clearly there is an issue making connection to databases. The good thing is that the loglines are giving clear error from SQL server, for example errorCode = [11] & errorCode = [10054]. If you Google SQL error 11 and 10054 you get quite nice answers.

For me that seems like normal connection failed message. Quite typically customers have several networks cards in the server and other network has no access to database. Maybe the integrations is now running on that network card. In other words the VU network interface binding is lost when your server was restarted after Windows update.

BR,
Jukka

[former_member652383]

Hi,

Thanks for the comments and yes, we know that the version is too old, but the customer are moving the solution to another provider, so they decided to don't do the upgrade.

By the other hand, we are testing the network and we don't think that could be a problem, we are using VM with only one "physical" interface and several IP address on it, each one for each VU, all in the same vlan. We can switch the rest of VU, for example Agents and there is no problem, so we discard a network poblems.

As jukkasuhonen said, we are checking the DB and all looks OK, but all the docs that we found to solve the 10054 error code for MySQL involve a reboot of the DB, we are trying to do that, but we don't have a maintenance window yet.

Regrads

[former_member158363]

Hi Rodriguez,

first of all - the SP04 version you are using is very very old, most current version is FP15. But I guess you are aware of this and you have good reason.

Do you have DB instance shared with application server or is it on a separated box? Is it in the same network or is there firewall between app servers and DB instance?

You wrote that on some servers it is working, on others not. Do you have same Win patches on all servers? Did you try to switch off all windows firewall/defender/antivirus on both DB instance and the affected application server?

Regards,

Dawood