[SA-list] ODBC Check stops cause SA to hang

[Carter, Phillip]

Currently running SA 4.1.1609 on Windows 2000 sp4.   We have a number of checks that use the External ODBC com check. Basically they run a query against a database that resides on the server being checked.   For the last three evenings, Servers Alive has stopped responding when performing this check. The check is performed throughout the day without any problems and it is at approximately the same time that it stops.   The log shows usually shows something like this 30/09/2004 7:19:58 PM      External COM check started (W00000002,209) 30/09/2004 7:19:58 PM      External COM check (W00000002,209):Successfull connection (0)   When SA hangs it shows this, 30/09/2004 7:27:31 PM Disk space checking on \\WEBTEST\D$: 13967.6640625 Mbytes free 30/09/2004 7:27:32 PM External COM check started (W00000002,209) 1/10/2004 11:45:21 AM Servers Alive version 4.1.1609.3 1/10/2004 11:45:21 AM Running on Microsoft Windows 2000 Professional (2195) Service Pack 4 1/10/2004 11:45:21 AM Oracle Core40.dll/core35.dll/oracore8.dll/oracore9.dll library not available 1/10/2004 11:45:22 AM DUN installed and available for SA As you can see the check executed successfully just 7 mins before it hung. There are no other error messages or event log entries to explain why it stops at this point.   Hope someone can help with this.     Thanks Phillip Carter Ph: +61 3 9235 1691 IMPORTANT DISCLAIMER - THIS MAY AFFECT YOUR LEGAL RIGHTS: Because this document has been prepared without consideration of any specific clients investment objectives, financial situation or needs, a Bell Potter Securities Limited investment adviser should be consulted before any investment decision is made. While this document is based on the information from sources which are considered reliable, Bell Potter Securities Limited, its directors, employees and consultants do not represent, warrant or guarantee, expressly or impliedly, that the information contained in this document is complete or accurate. Nor does Bell Potter Securities Limited accept any responsibility to inform you of any matter that subsequently comes to its notice, which may affect any of the information contained in this document. This document is a private communication to clients and is not intended for public circulation or for the use of any third party, without the prior approval of Bell Potter Securities. Disclosure of Interest: Bell Potter Securities Limited receives commission from dealing in securities and its authorised representatives, or introducers of business, may directly share in this commission. Bell Potter Securities and its associates may hold shares in the companies recommended. Bell Potter Securities Limited ABN 25 006 390 772 AFS Licence No. 243480