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

Patches have not been successfully updated in the last three days

Sophos Enterprise Console

Sophos Enterprise Coonsole v 5.4.1 is installed

Since 16th of Sptember 2017 I get daily up to 4  errors in event logs

Event ID 0 ; Source PatchFeedProcessor

Patches have not been successfully updated in the last three days

 

In PatchFeedProcessor.log are lots of these entries:

2017-10-26 06:29:00 | PID  14896 | TID      1 | Information | -----PROGRAM START-----
2017-10-26 06:29:43 | PID  14896 | TID      1 | Information | An SQL exception has been caught while executing 'usp_pf_insupdPatch'. Execution will be retried. Location = 'Execute command', SQL Error Code = '-2146232060', Message = 'Cannot insert duplicate key row in object 'dbo.Patch' with unique index 'IX_Patch_2'. The duplicate key value is (MS12-078 Security Update for Windows Server 2008 (KB2753842)).
Failed to update patch
The statement has been terminated.'
2017-10-26 06:29:43 | PID  14896 | TID      1 | Information | Error(Number='2601',Message='Cannot insert duplicate key row in object 'dbo.Patch' with unique index 'IX_Patch_2'. The duplicate key value is (MS12-078 Security Update for Windows Server 2008 (KB2753842)).',Source='.Net SqlClient Data Provider',State='1')
2017-10-26 06:29:43 | PID  14896 | TID      1 | Information | Error(Number='50000',Message='Failed to update patch',Source='.Net SqlClient Data Provider',State='22')
2017-10-26 06:29:43 | PID  14896 | TID      1 | Information | Error(Number='3621',Message='The statement has been terminated.',Source='.Net SqlClient Data Provider',State='0')
2017-10-26 06:29:43 | PID  14896 | TID      1 | Information | An SQL exception has been caught while executing 'usp_pf_insupdPatch'. Execution will be retried. Location = 'Execute command', SQL Error Code = '-2146232060', Message = 'Cannot insert duplicate key row in object 'dbo.Patch' with unique index 'IX_Patch_2'. The duplicate key value is (MS12-078 Security Update for Windows Server 2008 (KB2753842)).
Failed to update patch

 

Any help is highly appreciated. Thanks,

Martin



This thread was automatically locked due to age.
Parents
  • For us, this started after Sophos deployed an emergency patch for HitmanPro back in September 2017.  The events were being overlooked until now, and our ability to deploy clients has never been the same.

    Like others in this thread, I am working with Level 1 to gather all the server logs and then begin the normal long wait for a reply.  According to that level 1, "This is a known issue and the development team is working on a fix."

    When I asked about simply deleting the false-positive "duplicate" record from the database their reply was "We don't support scripting against the database".  

Reply
  • For us, this started after Sophos deployed an emergency patch for HitmanPro back in September 2017.  The events were being overlooked until now, and our ability to deploy clients has never been the same.

    Like others in this thread, I am working with Level 1 to gather all the server logs and then begin the normal long wait for a reply.  According to that level 1, "This is a known issue and the development team is working on a fix."

    When I asked about simply deleting the false-positive "duplicate" record from the database their reply was "We don't support scripting against the database".  

Children
No Data