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..

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
  • Dear All,

    Thanks for all comments and finally I found a solution by going through all the discussions. I hope the problem was of increasing database size is due to enable all reporting’’’’s to console of client firewall. And I stopped it.  And I run following command for purge and shrink data base.

    Go to command prompt of Management server.

    #To purge database

    OSQL -E -S  .\SOPHOS -d sophos4 -Q "exec PurgeTask"

    #To shrink Database

    OSQL -E -S .\SOPHOS 
    1> DBCC SHRINKDATABASE(SOPHOS4)
    2> GO

    After all Database came to 2.2 GB and I reduce the settings of console purge setting to 1 month.

    Tools --> Configure Reporting --> Purge

    Thanks again to you all.

    Regards,

    Dilan Manjula Fernando

    :1829
Reply
  • Dear All,

    Thanks for all comments and finally I found a solution by going through all the discussions. I hope the problem was of increasing database size is due to enable all reporting’’’’s to console of client firewall. And I stopped it.  And I run following command for purge and shrink data base.

    Go to command prompt of Management server.

    #To purge database

    OSQL -E -S  .\SOPHOS -d sophos4 -Q "exec PurgeTask"

    #To shrink Database

    OSQL -E -S .\SOPHOS 
    1> DBCC SHRINKDATABASE(SOPHOS4)
    2> GO

    After all Database came to 2.2 GB and I reduce the settings of console purge setting to 1 month.

    Tools --> Configure Reporting --> Purge

    Thanks again to you all.

    Regards,

    Dilan Manjula Fernando

    :1829
Children
No Data