KS-Soft. Network Management Solutions
 FAQFAQ   SearchSearch   MemberlistMemberlist   UsergroupsUsergroups   RegisterRegister    ProfileProfile    Log inLog in 

Passive RMA (ODBC): "RMA: Access violation...'ntdll.dll
Goto page 1, 2  Next
 
Post new topic   Reply to topic    KS-Soft Forum Index -> Bug reports
View previous topic :: View next topic  
Author Message
pebjorke



Joined: 25 Jan 2011
Posts: 1

PostPosted: Tue Jan 25, 2011 3:59 am    Post subject: Passive RMA (ODBC): "RMA: Access violation...'ntdll.dll Reply with quote

We are using Hostmonitor version 8.82 running on Windows Server 2003 Standard Edition SP2. At the moment we are using RMA version 4.12 for all monitored Microsoft Windows computers. All agents are installed in passive mode.

Description of the problem
We are using a passive RMA to run ODBC queries locally on each computer. Occasionally we get a reply value from the agent giving an unknown status due to message "RMA: 301 - Access violation at address XXXXXXXX in module 'xxxxx.xxx'. Write of address XXXXXXXX". We have several queries using the same ODBC on each computer and all the tests gives the unknown status whne it fails. All other tests at the same computer using the same RMA is OK when the ODBC fails (Check Service, Performance Counters, Free Disk space, Available memory etc). The problem has also occured on earlier versions of both Hostmonitor and RMA. It also occures on two different monitored computers.

How we solve it
The RMAs are installed as service. After restarting the RMA.exe service locally it works fine again.

Computer 1:
OS: Microsoft Windows Server 2003 R2 Standard Edition SP2
Database: MS SQL 2005 Database - SQL Server 9.0.4053
ODBC: ODBC driver version SQL Server 2000.86.3959.00 (File: SQLSRV32.DLL 18.02.2007)
Example:
15.01.2011: RMA: 301 - Access violation at address 7C82BC52 in module 'ntdll.dll'. Read of address 00000004

Computer 2:
OS: Microsoft Windows Server 2003 Enterprise Edition SP2
Database: Oracle Database version 10.2.0
ODBC: ODBC driver version 10.02.00.04 (File: SQORA32.DLL 07.07.2010)
Examples:
25.01.2011: RMA: 301 - Access violation at address 7C81A379 in module 'ntdll.dll'. Write of address 00000008
12.01.2011: RMA: 301 - Access violation at address 7C82C873 in module 'ntdll.dll'. Read of address 00000000
12.01.2011: RMA: 301 - Access violation at address 48899621 in module 'ODBC32.dll'. Read of address 000C3350
12.01.2011: RMA: 301 - Access violation at address 77BD765F in module 'msvcrt.dll'. Read of address 00000000
12.01.2011: RMA: 301 - Access violation at address 7C82C873 in module 'ntdll.dll'. Read of address 00000007
25.11.2010: RMA: 301 - Access violation at address 48899E2D in module 'ODBC32.dll'. Read of address 00740072


Our goal is of course to avoid the failure situation.
Also a solution where we can monitore the failure without bursting messages from all ODBC tests is better than it is today. All ODBC tests are already dependent on a sucessful PING response and the RMA Service running on the computer.
Will the action "Reload agent" inside RMA Manager give the same result as a restart of the service locally?
Back to top
View user's profile Send private message
KS-Soft



Joined: 03 Apr 2002
Posts: 12337
Location: USA

PostPosted: Tue Jan 25, 2011 4:03 pm    Post subject: Reply with quote

I think you should send this bug report to ODBC driver developers. Bugs in ODBC drivers and antivirus monitors are two biggest problems for us

However we will try to investigate this problem on our side as well.
We are testing ODBC Query test using
- MS SQL driver version 2000.85.1132.00
- MS SQL driver version 2000.86.1830.00
- Oracle driver 10.02.00.01
cannot reproduce any problem so far. Will check source codes as well.

Could you please provide SQL query and structure of the table you are using for these tests? Or may be you can provide access to your SQL servers for testing?
You may send details by e-mail to support@ks-soft.net

Regards
Alex
Back to top
View user's profile Send private message Visit poster's website
totte



Joined: 30 May 2007
Posts: 43

PostPosted: Mon Feb 07, 2011 5:43 am    Post subject: Reply with quote

I have the same problem on a similar platform. The problems started to occur after I upgraded to RMA 4.12. Only to this problem in one of my RMAer

Christoffer
Hogia
Back to top
View user's profile Send private message
KS-Soft



Joined: 03 Apr 2002
Posts: 12337
Location: USA

PostPosted: Mon Feb 07, 2011 12:24 pm    Post subject: Reply with quote

Same question - same answer.
Bugs in ODBC drivers and antivirus monitors are two biggest problems for us. However we will try to investigate this problem on our side as well.
Could you please provide more information?
- What version of the agent (RMA) have you used before update?
- What exactly ODBC driver do you use? Version?
- Could you please provide SQL query and structure of the table you are using for these tests?

Regards
Alex
Back to top
View user's profile Send private message Visit poster's website
rhaba



Joined: 02 Jul 2007
Posts: 6

PostPosted: Wed Mar 02, 2011 10:52 am    Post subject: Reply with quote

Just a question here, as I'm having the same issue (in both 8.82 and 8.84) and this problem did not present itself until I upgraded to either version.

Why exactly is this an ODBC issue, when it did not start happening until I upgraded your software?

You should also know that the error does not occur right away. The issue presents itself after 24-36 hours of monitoring successfully.
Back to top
View user's profile Send private message
KS-Soft



Joined: 03 Apr 2002
Posts: 12337
Location: USA

PostPosted: Wed Mar 02, 2011 11:26 am    Post subject: Reply with quote

Could you please provide more information?
- Windows? Service Pack?
- What version of HostMonitor have you used before update?
- What exactly ODBC drivers do you use?
- Do you have installed some antivirus monitors, personal firewall, content monitoring software? Non stanard winsock components?

Regards
Alex
Back to top
View user's profile Send private message Visit poster's website
rhaba



Joined: 02 Jul 2007
Posts: 6

PostPosted: Wed Mar 02, 2011 12:58 pm    Post subject: Reply with quote

Could you please provide more information?
- Windows? Service Pack? Server 2003 SP2
- What version of HostMonitor have you used before update? 7.X (Not sure which, but never had this issue)
- What exactly ODBC drivers do you use? SQL Server 2000.86.3959.00
- Do you have installed some antivirus monitors, personal firewall, content monitoring software? Non stanard winsock components? No to all.
Back to top
View user's profile Send private message
KS-Soft



Joined: 03 Apr 2002
Posts: 12337
Location: USA

PostPosted: Wed Mar 02, 2011 1:12 pm    Post subject: Reply with quote

Quote:
What version of HostMonitor have you used before update? 7.X (Not sure which, but never had this issue)

We made hunderd changes between version 7.x and 8.82...

MS SQL ODBC driver should work fine. May be this problem is not related to ODBC... Could you please try to disable ODBC logging and ODBC related test items. If this will not help, please send your configuration files to support@ks-soft.net. We need HML file with tests and all *.LST, *.INI files from HostMonitor folder.

Regards
Alex
Back to top
View user's profile Send private message Visit poster's website
rhaba



Joined: 02 Jul 2007
Posts: 6

PostPosted: Thu Mar 03, 2011 9:01 am    Post subject: Reply with quote

Sorry for the question here, but where do I disable ODBC logging? Also, we run several ODBC tests against our data set, so are you telling me to disable any test that uses the ODBC test method? If so, this is not a solution that will work for us.

Our primary logging is set to log to file if that's what you're referring to.
Back to top
View user's profile Send private message
KS-Soft Europe



Joined: 16 May 2006
Posts: 2832

PostPosted: Thu Mar 03, 2011 9:19 am    Post subject: Reply with quote

Quote:
where do I disable ODBC logging?

menu Options -> "Primary log" and "Backup log" tabs. "Database" type means HostMonitor will use ODBC for logging.
Quote:
Also, we run several ODBC tests against our data set, so are you telling me to disable any test that uses the ODBC test method? If so, this is not a solution that will work for us.

This should be done just for testing. If problem will disappeare after disabling ODBC tests and logging, then we will know what cause the issue.
Quote:
Our primary logging is set to log to file if that's what you're referring to.

Please check Backup log also.
Back to top
View user's profile Send private message Send e-mail Visit poster's website
rhaba



Joined: 02 Jul 2007
Posts: 6

PostPosted: Thu Mar 03, 2011 9:33 am    Post subject: Reply with quote

We do not use the backup log.

Disabling the test will certainly get rid of the issue as I am no longer using ODBC tests. It's the ODBC tests that fail and it's the ODBC tests that I need. No other tests fail. It's just the ODBC tests that present these errors.
Back to top
View user's profile Send private message
rhaba



Joined: 02 Jul 2007
Posts: 6

PostPosted: Thu Mar 03, 2011 9:46 am    Post subject: Reply with quote

Thought I'd post once more. I haven't updated one of our other hostmon servers yet. It's running 8.58 and not presenting these issues.
Back to top
View user's profile Send private message
KS-Soft



Joined: 03 Apr 2002
Posts: 12337
Location: USA

PostPosted: Thu Mar 03, 2011 11:43 am    Post subject: Reply with quote

Quote:
Sorry for the question here, but where do I disable ODBC logging?

Primary Log and Backup Log pages in HostMonitor Options dialog.
I assume you are using default File logging (so you don't know about these settings).

Quote:
Also, we run several ODBC tests against our data set, so are you telling me to disable any test that uses the ODBC test method?

Yes

Quote:
If so, this is not a solution that will work for us.

Then you may setup HostMonitor to restart agent when this error occurs (you may use "advanced mode" Restart Service action).

Regards
Alex
Back to top
View user's profile Send private message Visit poster's website
KS-Soft



Joined: 03 Apr 2002
Posts: 12337
Location: USA

PostPosted: Thu Mar 03, 2011 11:46 am    Post subject: Reply with quote

Quote:
Thought I'd post once more. I haven't updated one of our other hostmon servers yet. It's running 8.58 and not presenting these issues.

I though you are using RMA to perform these tests. Am I wrong?
If your configuration different from configuration described in original post, I think its better to start new thread. Or better send e-mail to support@ks-soft.net. We usually work with e-mails.

Regards
Alex
Back to top
View user's profile Send private message Visit poster's website
KS-Soft



Joined: 03 Apr 2002
Posts: 12337
Location: USA

PostPosted: Fri Mar 04, 2011 7:17 am    Post subject: Reply with quote

There is update for RMA: www.ks-soft.net/download/rma415.zip
Could you update agent and add "ODBC_UseSharedEnvHandle=0" line into [Misc] section of rma.ini file?
(if you add this line while agent is running, you should restart agent or use RMA Manager "Reload settings" command)

Regards
Alex
Back to top
View user's profile Send private message Visit poster's website
Display posts from previous:   
Post new topic   Reply to topic    KS-Soft Forum Index -> Bug reports All times are GMT - 6 Hours
Goto page 1, 2  Next
Page 1 of 2

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group

KS-Soft Forum Index