Thread Info
  • State Verified Answer
  • Locked Locked
  • Replies 6 replies
  • Subscribers 1 subscriber
  • Views 4717 views
  • Users 0 members are here
Options
Suggested
This discussion has been locked.
You can no longer post new replies to this discussion. If you have a question you can start a new discussion

Sophos Enterprise Console error..

DilanManjula

Hi,

One of our customer have issue with sophos ent. Console(v 4 with windows 2008 Ent 64 bit and SQL Express 2005).the database size has grown up to 4GB. We have installed around 3,500 PC’’’’s via this console in active directory integrated mode. When while working with console we are getting bellow error. And quit from the console. But can open again and can work for a while.

Further I run “C:\>osql -E -S .\sophos -d sophos4 -Q "select count(id) from groups" to count no: of OU’’’’s of AD and output is “941”

 And the details which we entered under “configure E-mail alerts”  in the console also not getting saved. Pls. advice ASAP.

note : having enough free disk space 

“ Could not allocate space for object 'dbo.Threats'.'IX_Threats_Status_ThreatInstanceID' in database 'SOPHOS4' because the 'PRIMARY' filegroup is full. Create disk space by deleting unneeded files, dropping objects in the filegroup, adding additional files to the filegroup, or setting autogrowth on for existing files in the filegroup.

----- [outer exception] -----

   -- error: 0x80004005 (Unspecified error)

   -- facility: Generic (System)

   at void __thiscall ResolveAlertsDlg::acknowledgeAlerts(class std::vector<unsigned long,class std::allocator<unsigned long> > &)

   at __w64 long __thiscall ResolveAlertsDlg::OnAcknowledge(unsigned short,unsigned short,struct HWND__ *,int &)

   at 1

   at __w64 long __thiscall CCompListCtrl::OnActionResolveAlertsAndErrors(unsigned short,unsigned short,struct HWND__ *,int &)

   at int __cdecl Run(int,enum bl::ConsoleType::Type)

   at int __stdcall wWinMain(struct HINSTANCE__ *,struct HINSTANCE__ *,wchar_t *,int) “

:1151


This thread was automatically locked due to age.
Parents
  • 0

    A 4gb db for 3500 computers is rather concerning, and as has already been pointed out is the limit for db size on SQL Express. So your disk space error is indeed correct, though the limit is being imposed by SQL and not the actual disk. I'd suggest contacting support to begin investigating why your database is so large. For the number of clients you have, I wouldn't expect the database to be much bigger then 100mb if all is working correctly and you don't have a malware or updating issue causing increased reporting to the console.

    :1186
Reply
  • 0

    A 4gb db for 3500 computers is rather concerning, and as has already been pointed out is the limit for db size on SQL Express. So your disk space error is indeed correct, though the limit is being imposed by SQL and not the actual disk. I'd suggest contacting support to begin investigating why your database is so large. For the number of clients you have, I wouldn't expect the database to be much bigger then 100mb if all is working correctly and you don't have a malware or updating issue causing increased reporting to the console.

    :1186
Children
No Data