Thread Info
  • State Not Answered
  • Locked Locked
  • Replies 2 replies
  • Subscribers 0 subscribers
  • Views 7940 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

Corrupted database ?

JacquesMONROY

Hello,


We have discovered some mismatches on the databse viewed on the console. For example :

- some computers, added to the AD for some days are not visible on the console (AD view)

- other computers, not registered on the AD (ESX Host Servers) are visible on the console (they not have Sophos installed)

- some computers are mentionned to have not updates from 15 days... They have been registered yesterday.


We are not really confident about informations now.


Can we refresh the database used by the main server and several Update managers (which we re-deploy these days) ?


Thank a lot



This thread was automatically locked due to age.
  • 0
    In addition to this question, when I try to view the "Synchronization Properties", it "could not complete" with this error message

    ErrorNotFound
    ----- [outer exception] -----
    -- error: 0x829C0016
    -- facility: Sophos Management Service Database Stored Procedure Exception
    -- source: struct ISMT_SynchronizationPoint

    at bool __thiscall CADPropsDlg::GetADDetails(void)
    at __w64 long __thiscall CADPropsDlg::OnInitDialog(unsigned int,__w64 unsigned int,__w64 long,int &)
    at __w64 long __thiscall CGroupTreeCtrl::OnADGroupProps(unsigned short,unsigned short,struct HWND__ *,int &)
    at int __cdecl Run(int,class bl::CommandLine,enum bl::ConsoleType::Type)
    at int __stdcall wWinMain(struct HINSTANCE__ *,struct HINSTANCE__ *,wchar_t *,int)

    Perhaps it should be a useful information
  • 0

    Hello JacquesMONROY,

    as for the error when you try to open the sync properties - I think you should open a case with Support. This is something which shouldn't happen - whether it's "just" some inconsistency or a serious corruption I can't say.

    As to the above points:
    not visible - very likely related
    computers [w/o Sophos] visible - they can't magically appear. Either they are imported somehow (import, discover, AD sync) or they do have Sophos installed and the RMS component has contacted the management server. Do they appear as unmanaged (greyed) or managed (and if the latter, which details are set)?
    have not updated - the endpoint reports its (SAV) software details (version, number of IDEs). Whenever SEC downloads updates it records these attributes together with the timestamp. Comparing the information from the endpoint and the known packages it calculate the not since. How do you install/deploy Sophos? From the CID or with a custom installer?
    Only the management server accesses the database.

    Christian   

Unfiltered HTML