View previous topic :: View next topic |
Author |
Message |
RRing
Joined: 16 Aug 2006 Posts: 39
|
Posted: Mon Mar 29, 2010 10:10 am Post subject: HostMonitor Crash After Ugrade |
|
|
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 |
|
Back to top |
|
|
KS-Soft
Joined: 03 Apr 2002 Posts: 12807 Location: USA
|
Posted: Mon Mar 29, 2010 11:20 am Post subject: |
|
|
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 |
|
Back to top |
|
|
RRing
Joined: 16 Aug 2006 Posts: 39
|
Posted: Mon Mar 29, 2010 11:25 am Post subject: HostMonitor and ODBC issue |
|
|
Alex,
I was running 8.32.
ODBC Driver is SQL Server Native Client 10.0
on 64 Bit Windows |
|
Back to top |
|
|
KS-Soft
Joined: 03 Apr 2002 Posts: 12807 Location: USA
|
Posted: Wed Mar 31, 2010 10:50 am Post subject: |
|
|
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 |
|
Back to top |
|
|
RRing
Joined: 16 Aug 2006 Posts: 39
|
Posted: Thu Apr 01, 2010 6:36 am Post subject: Hostmonitor ODBC Error |
|
|
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. |
|
Back to top |
|
|
KS-Soft
Joined: 03 Apr 2002 Posts: 12807 Location: USA
|
Posted: Thu Apr 01, 2010 6:29 pm Post subject: |
|
|
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 |
|
Back to top |
|
|
RRing
Joined: 16 Aug 2006 Posts: 39
|
Posted: Fri Apr 02, 2010 12:05 pm Post subject: ODBC Error |
|
|
Alex,
I added the string and get an error code 65535
Error: none of the dynamic libraries can be found:ntwdblib.dll |
|
Back to top |
|
|
KS-Soft
Joined: 03 Apr 2002 Posts: 12807 Location: USA
|
Posted: Fri Apr 02, 2010 1:17 pm Post subject: |
|
|
Do you have SQL Client installed? If yes, then it must be corrupted... If not, please install it.
Regards
Alex |
|
Back to top |
|
|
RRing
Joined: 16 Aug 2006 Posts: 39
|
Posted: Tue Apr 06, 2010 7:44 am Post subject: ODBC Error |
|
|
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. |
|
Back to top |
|
|
KS-Soft
Joined: 03 Apr 2002 Posts: 12807 Location: USA
|
Posted: Tue Apr 06, 2010 11:24 am Post subject: |
|
|
Great. Thank you for the notice
Regards
Alex |
|
Back to top |
|
|
RRing
Joined: 16 Aug 2006 Posts: 39
|
Posted: Wed Apr 07, 2010 9:05 am Post subject: Crashes |
|
|
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. |
|
Back to top |
|
|
KS-Soft
Joined: 03 Apr 2002 Posts: 12807 Location: USA
|
Posted: Wed Apr 07, 2010 9:33 am Post subject: |
|
|
Nope, Windows exception 0xc0000005 can mean anything
Have you changed test settings so HostMonitor does not use ODBC driver anymore?
Regards
Alex |
|
Back to top |
|
|
RRing
Joined: 16 Aug 2006 Posts: 39
|
Posted: Wed Apr 07, 2010 9:58 am Post subject: Crashes |
|
|
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. |
|
Back to top |
|
|
KS-Soft
Joined: 03 Apr 2002 Posts: 12807 Location: USA
|
Posted: Wed Apr 07, 2010 10:38 am Post subject: |
|
|
Do you have installed 32bit version of SQL Native client?
Regards
Alex |
|
Back to top |
|
|
RRing
Joined: 16 Aug 2006 Posts: 39
|
Posted: Fri Apr 16, 2010 6:21 am Post subject: Database Error Causing Crash |
|
|
I have completly reloaded the database which corrected the problem. |
|
Back to top |
|
|
|