RE: 20061122 build also stops scanning
|
Logged in as: Guest
|
|
Users viewing this topic:
none
|
|
Login  | |
|
RE: 20061122 build also stops scanning - 21.Dec.2006 4:39:57 AM
|
|
|
Arielle
Posts: 294
Score: 0
Joined: 15.Sep.2006
Status: offline
|
Hi,
We need some debug logs in order to troubleshoot your issue as the problem is specific for each user. Please follow my post above on how to send the debug logs to us.
Thanks.
_____________________________
Arielle Bonnici - Quality Metrics Analyst
GFI Software - www.gfi.com
|
|
|
|
|
RE: 20061122 build also stops scanning - 21.Dec.2006 6:22:15 PM
|
|
|
Looking4Answers
Posts: 38
Score: 0
Joined: 24.Nov.2006
Status: offline
|
PCPlumber / tdeering / MMueller / chris056@umn.edu / AESIT / RayPesek / srsb / petestorm / jsammari
Is this still an outstanding issue? If so fellow users compare notes. I have not been able to reproduce it. I have not been doing any backups via SQL nore any Database Maintenance via the EM7 Maintenance setup. I was wondering if this may be were the issue is originating from. I have been stress testing and tinkering with this EM7 for over 6 weeks now and was about to test/start doing backup's. After reading this thread I got nervous. I did see similar things like AESIT and tdeering. I had inquired about them in my posting "Upgrade to the GFI EventsManager 7 build (20061214) Issue" in which I have included an exerpt below. I have not recieved a response from GFI support to this yet. I did not have an issue with scanning with my original Datafolder but I did after an import of my exported data. The solution that worked for me was a one time restart of scanning the each Computer Group. Syslogs stayed up consistantly.
Exerpt from Upgrade to the GFI EventsManager 7 build (20061214) Issue
So I uninstalled 20061214. Deleted the Datafolder. Installed 20061129. Restored the Data folder (from my recycling bin). Launched the application and it started scanning jobs. I then stopped the service and imported my configs. (I don't think I needed to do this). I then relaunched the application and it no longer runs the window scans automatically. I had to start them by choosing the Scan now option for each Computer Group.
My configuration & stats
Windows Server 2003 SP1
SQL 2000 SP3
GFI EM7 Build 20061122
I am currently scanning 8 systems and have scanned up to 25
SQL DB = approx 2GB and is set to autoshrink
Transaction log = less than 1MB
Events in Events Browser = approx 1 million
Events Scanned by GFI = approx 110 million
Note: I cannot send any logs due to the strict security environment of my organization.
|
|
|
|
|
RE: 20061122 build also stops scanning - possible fix? - 22.Dec.2006 10:30:41 AM
|
|
|
petestorm
Posts: 10
Score: 0
Joined: 11.Oct.2006
Status: offline
|
Found a possible fix (using Build 20061214 by the way). As some of you may have found it stops pulling logs and the last message in the Operational History is "Maintenance Finished" from the Database module. Turns out my DBA is doing database backups every hour at the top of the hour. If I change my scanning schedule to pull logs from servers so that they are NOT pulling logs at the top of the hour everything keeps runnining smoothly. Been running fine for 24 hours now in this configuration.
Using SQL 2005 and every hour EventsManager will throw this in the debug logs (but it seems to keeping working if it's not actively trying to store logs):
"12/22/2006, 9:59:47 AM, 595, 0, dd4, b14, error, DbMaintenancePlugin, DatabaseUpdater, ConnectToServer, Unhandled exception: An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)
Call Stack listing:
at DbMaintenancePlugin.DatabaseUpdater.ConnectToServer(MaintenanceDPBase data)
at DbMaintenancePlugin.DatabaseManager.CompactDatabase(CompactDatabase data)
at DbMaintenancePlugin.DbMaintenancePlugin.ProcessData(String dataProtocol, Object inputObject, Boolean expectResults, String senderName, Boolean sync)
at ServiceProvider.ThreadProc(Object task)
at System.Threading._ThreadPoolWaitCallback.WaitCallback_Context(Object state)
at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
at System.Threading._ThreadPoolWaitCallback.PerformWaitCallback(Object state)
"
|
|
|
|
|
RE: 20061122 build also stops scanning - possible fix? - 11.Jan.2007 3:32:38 PM
|
|
|
petestorm
Posts: 10
Score: 0
Joined: 11.Oct.2006
Status: offline
|
Well, turns out this didn't fix squat. The piece still hangs randomely after DB maintenance and I have to force quit. Sure this isn't still in beta? And, yes, my SQL 2005 does allow remote connections.
< Message edited by petestorm -- 11.Jan.2007 3:33:51 PM >
|
|
|
|
|
RE: 20061122 build also stops scanning - possible fix? - 12.Jan.2007 9:32:14 AM
|
|
|
Arielle
Posts: 294
Score: 0
Joined: 15.Sep.2006
Status: offline
|
Hi,
The issue is caused because EventsManager performs some shrink operations. This does not require exclusive access, however it conflicts with any backup operations as per http://msdn2.microsoft.com/en-us/library/ms190488.aspx.
We are currently working on fixing this conflict, but for now the only workaround is to stop other maintenance operations to take place on the EventsManager database.
_____________________________
Arielle Bonnici - Quality Metrics Analyst
GFI Software - www.gfi.com
|
|
|
|
|
RE: 20061122 build also stops scanning - possible fix? - 12.Jan.2007 10:28:15 AM
|
|
|
petestorm
Posts: 10
Score: 0
Joined: 11.Oct.2006
Status: offline
|
quote:
ORIGINAL: Arielle
Hi,
The issue is caused because EventsManager performs some shrink operations. This does not require exclusive access, however it conflicts with any backup operations as per http://msdn2.microsoft.com/en-us/library/ms190488.aspx.
We are currently working on fixing this conflict, but for now the only workaround is to stop other maintenance operations to take place on the EventsManager database.
Hooray!!!!!!!!!
|
|
|
|
|
RE: 20061122 build also stops scanning - possible fix? - 18.Jan.2007 6:56:10 PM
|
|
|
Looking4Answers
Posts: 38
Score: 0
Joined: 24.Nov.2006
Status: offline
|
Would scheduling a job or batch process to stop the GFI Service then Restart it after the SQL backup completes be a valid workaround?
Also, What is the difference between starting and stoping the service through services.msc and through GFI Events Manager?
- When my system stopped processing this las time. . . I stopped and started the service via the service.msc. I waited approx 10 minutes and nothing happened as far as the jobs starting back up. I then stopped the service then started it through the GFI Events Manager. It then started scanning systems. **On a side note I did have to manually prompt it to scan some of my groups as not all of them started back up after starting it through GFI EM. I waited about 30 minutes to confirm this and all of my jobs run in 15 minute cycles or less.
|
|
|
|
|
RE: 20061122 build also stops scanning - possible fix? - 19.Jan.2007 6:48:07 AM
|
|
|
Arielle
Posts: 294
Score: 0
Joined: 15.Sep.2006
Status: offline
|
Hi,
Yes, scheduling a job to stop the EventsManager service before SQL Server backup and starting the service again when it is done should stop EventsManager from hanging.
There is really no difference if you start the service from the EventsManager console or from services.msc, however the status may update sooner when you start it from the console.
_____________________________
Arielle Bonnici - Quality Metrics Analyst
GFI Software - www.gfi.com
|
|
|
|
|
RE: 20061122 build also stops scanning - possible fix? - 19.Jan.2007 2:15:11 PM
|
|
|
Looking4Answers
Posts: 38
Score: 0
Joined: 24.Nov.2006
Status: offline
|
Any Ideas why 3 of my Groups did not start scanning but the rest did? I would think that the system would process these 3 since the time of their last scan was in the past and the scan interval time had been surpassed.
As far as the status updating quicker when starting the service from the Consol. . . I think there is something else here which comes into play. I waited in excess of 10 minutes before stopping the service then restarting it through the EM Console. There isn't anything else running on this system and it is hardly being stressed by EM7 when it is running. I think in 10 minutes it would start processing scans. I will try to set up a scheduled task to start and stop the service and see what happens.
|
|
|
|
|
RE: 20061122 build also stops scanning - possible fix? - 25.Jan.2007 10:28:50 AM
|
|
|
Arielle
Posts: 294
Score: 0
Joined: 15.Sep.2006
Status: offline
|
Hi,
We would need some debug logs in order to troubleshoot this problem. Can you please send us some debug logs by enabling debug logging as per http://kbase.gfi.com/showarticle.asp?id=KBID002896, then run the troubleshooter (Start > All Programs > GFI EventsManager 7 > Troubleshooter), ZIP the output files and send them to forums@gfi.com referencing this thread in the email.
Thanks.
_____________________________
Arielle Bonnici - Quality Metrics Analyst
GFI Software - www.gfi.com
|
|
|
|
|
RE: 20061122 build also stops scanning - possible fix? - 25.Jan.2007 1:28:56 PM
|
|
|
Looking4Answers
Posts: 38
Score: 0
Joined: 24.Nov.2006
Status: offline
|
I am in a very Security conscious environment so sending files out will be difficult if not impossible. Is there something in the files which you can direct me to look at as an alternate solution? Also, can you advise on what files in particular to you need to look at in order to further investigate this issue? If I do get approval to send files I can need to look at what data is contained in them. I won't be able to send you things like what services are running and the configuration of our jobs since they include our system names and probably other sensitve data.
Thank you,
|
|
|
|
|
RE: 20061122 build also stops scanning - possible fix? - 26.Jan.2007 4:37:30 AM
|
|
|
Arielle
Posts: 294
Score: 0
Joined: 15.Sep.2006
Status: offline
|
Hi,
To troubleshoot this issue effectively we would require all the files requested earlier.
What you may opt to do, is to overwrite the confidential information with an 'X' and inform us of the files from which data has been removed.
Please note however that all information sent over to us is treated with strictest confidentiality and deleted where no longer required.
_____________________________
Arielle Bonnici - Quality Metrics Analyst
GFI Software - www.gfi.com
|
|
|
|
|
RE: 20061122 build also stops scanning - possible fix? - 1.Feb.2007 11:12:51 AM
|
|
|
Arielle
Posts: 294
Score: 0
Joined: 15.Sep.2006
Status: offline
|
We have prepared a new build which has fixes for this issue in built.
WARNING: This is a BETA build for our next upload of GFI EventsManager which contains our new WAN Connector and Database Operations Module.
More information on the new add-on and download details for the BETA build are available from http://beta.gfi.com.
_____________________________
Arielle Bonnici - Quality Metrics Analyst
GFI Software - www.gfi.com
|
|
|
|
 New Messages |
 No New Messages |
 Hot Topic w/ New Messages |
 Hot Topic w/o New Messages |
 Locked w/ New Messages |
 Locked w/o New Messages |
|
 Post New Thread
Reply to Message
Post New Poll
Submit Vote
Delete My Own Post
Delete My Own Thread
Rate Posts |
|
|
Printable Version
