I suggest that you go into sql manager and look at the jobs that may have
failed and the log. I've experienced similar issues and it's usually the
database. We had to configure the database to autogrow and to process the
transaction logs more frequently then the default. You may be able to fix this
by increasing the available space of the db and then manually running one or
more jobs job that failed. The sql log should give you some insight into the
situation at least.
-Derek
-----Original Message-----
From: issforum-bounces@iss.net
To: issforum@iss.net
Sent: 2/13/2005 3:08 PM
Subject: [ISSForum] SP DB error. Pls help??
Hi everyone.
Relatively new to working with Real Secure Site Protector (1 month) and
new to this discussion forum/list. I am hoping someone can help me. I
have one of my consoles showing the SP DB "error" as its' status.
Below, I have included the details from the DB. Anyone have experience
with this or know where I can find the answer as to how to fix this??
Any guidance or help would be greatly appreciated!!!
Also, we have a lot of extra events coming in, so I am wondering if this
could be the catalyst for the error status?? The other 4 consoles I
monitor are NOT set to auto purge or auto maintenance.
Thank you for your valuable time,
Traci
License State Key Good
Sensor Status Error - Loading:Error: The event collector is not
properly registered to request a working set
Data File Status 26% Full
Transaction Log Status 1% Full
SQL Server Agent Status Running.
Data Load Status 0 rows were loaded on Feb 13 2005 10:39PM. 39
SensorData rows were rejected. 18 SensorDataAVP rows were rejected.
Analysis Purge Status Purge Status: Complete; LastUpdated: Feb 8 2005
12:01AM (GMT) Status Description: Complete. No errors.
SensorData Purge Status Purge Status: Complete; LastUpdated: Feb
8 2005 12:01AM (GMT) Status Description: Complete. No errors.
Data Used (MB) 767 MB
Metrics Last Loaded Feb 13 2005 7:00AM
Auto Maintenance Job Job Enabled; Last Run Succeeded; Last Run Time:
Feb 13 2005 10:32PM
Auto Purge Setting ON
Auto Maint Setting ON
Defragment Index Setting ON
Health Status Last Checked At 2005-02-13 22:47:12 (GMT)
Version 2.0 (SP 1.3:XPU 1.50)
Available XPU Yes
Last Installed XPU SP 1.3
Site Name w/held for security reasons
Install Date Jun 28 2004 11:27AM
XPU Date None
Option Flag Default
Logging Level Informational
Last Modified By Sensor Controller(w/held for security reasons)
at 2005-02-13 16:47:34.567(GMT)
_______________________________________________
ISSForum mailing list
ISSForum@iss.net
TO UNSUBSCRIBE OR CHANGE YOUR SUBSCRIPTION, go to
https://atla-mm1.iss.net/mailman/listinfo/issforum
To contact the ISSForum Moderator, send email to mod-issforum@iss.net
The ISSForum mailing list is hosted and managed by Internet Security
Systems, 6303 Barfield Road, Atlanta, Georgia, USA 30328.
_______________________________________________
ISSForum mailing list
ISSForum@iss.net
TO UNSUBSCRIBE OR CHANGE YOUR SUBSCRIPTION, go to
https://atla-mm1.iss.net/mailman/listinfo/issforum
To contact the ISSForum Moderator, send email to mod-issforum@iss.net
The ISSForum mailing list is hosted and managed by Internet Security Systems,
6303 Barfield Road, Atlanta, Georgia, USA 30328.
