HostMonitor Crash After Ugrade

[RRing]

I have recently upgraded to 8.54 and started experiencing crashes on HostMonitor which is reporting an error on ODBC logging in the Windows Event Logs .
Faulting application hostmon.exe, version 8.0.54.661, time stamp 0x2a425e19, faulting module ODBC32.DLL, version 6.0.6002.18005

OS Version: Windows 2008 Server
Server:HPDL Series 8 Core, 12GB Memory
DataBase:SQL2008 Enterprise

Can you please assist with any recommendations or possible source? I have been running on 2008 Server and SQLDB 2008 for well over 6 months with no issues

[KS-Soft]

Sorry, we cannot fix bugs in ODBC drivers. Its not our property.
I think we have not changed logging/ODBC module since version 8.00 (just added macro variable) but we will check this to be sure.
What version of HostMonitor have you used before update?

What exactly ODBC driver (version) do you use?
Windows Service Pack? Do you use 32bit or 64bit Windows?

Regards
Alex

[RRing]

Alex,
I was running 8.32.
ODBC Driver is SQL Server Native Client 10.0
on 64 Bit Windows

[KS-Soft]

We do not see any mistake in our code, we added just 1 macro variable into logging module.
Also we did find any bug reports for SQL Server Native Client 10.0.

May be problem caused by some other ODBC driver? Did you setup some ODBC Query test items or SQL Query actions?

Regards
Alex

[RRing]

Alex,

I do have ODBC SQL Actions which do an insert to a failures table on reply failures. All use the ODBC Driver listed in the previous thread.

[KS-Soft]

Could you try one undocumented option: specify string like zdbc:mssql://hostname:port/databasename instead of name of ODBC data source?
hostname - name of the host (or IP address) where your SQL server is running
port - number of TCP port used by SQL server
database - name of database use for logging (or action)

This option is not well tested but in such case HostMonitor will not use ODBC Driver Manager and ODBC driver so it may help

Regards
Alex

[RRing]

Alex,
I added the string and get an error code 65535
Error: none of the dynamic libraries can be found:ntwdblib.dll

[KS-Soft]

Do you have SQL Client installed? If yes, then it must be corrupted... If not, please install it.

Regards
Alex

[RRing]

Alex,
Thanks for the help, it was a corrupt SQL load caused by a recent install of SQL Client Tools. I removed and reloaded and the crashes from the ODBC error have stopped.

[KS-Soft]

Great. Thank you for the notice

Regards
Alex

[RRing]

Alex,
I spoke to soon, I started having failures this morning. Any ideas from the below event log?

Faulting application hostmon.exe, version 8.0.54.661, time stamp 0x2a425e19, faulting module hostmon.exe, version 8.0.54.661, time stamp 0x2a425e19,
exception code 0xc0000005, fault offset 0x0001ab9e, process id 0x1668, application start time 0x01cad65adbe6e211.

[KS-Soft]

Nope, Windows exception 0xc0000005 can mean anything
Have you changed test settings so HostMonitor does not use ODBC driver anymore?

Regards
Alex

[RRing]

When I add the following in the Data Source for an ODBC Query test
zdbc:mssql://CSCTS01:1443/HMonitor
I always get the following error.
Error: None of the dynamic link libraries can be found: ntwdblib.dll
Note:
The database is on a remote server which is SQLServer2008 Enterprise running on Windows 2008 Server 64 Bit.

[KS-Soft]

Do you have installed 32bit version of SQL Native client?

Regards
Alex

[RRing]

I have completly reloaded the database which corrected the problem.