Thread Info
  • State Not Answered
  • +1 person also asked this people also asked this
  • Locked Locked
  • Replies 10 replies
  • Subscribers 3 subscribers
  • Views 21530 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

Patches have not been successfully updated in the last three days

saadshawwa

I upgraded Sophos Console from 5.4.1 to 5.5.0 and since then i have been getting this error in event logs

Event ID 0 ; Source PatchFeedProcessor

Patches have not been successfully updated in the last three days

any quick fix for this issue ?

thanks 



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

    Hello saadshawwa,

    for most unspecific errors there's no quick fix. Please check (and if necessary post a relevant part of) the PatchFeedProcessor.log in %ProgramData%\Sophos\Patch\Logs\. 

    Christian

  • 0 in reply to QC

    Hello Christian

    thank your for your  reply 

    that is what i found

    Information | -----PROGRAM END-----
    2017-03-22 03:35:00 | PID 13020 | TID 1 | Information | -----PROGRAM START-----
    2017-03-22 03:36:22 | PID 13020 | TID 1 | Warning | Failed to verify signature of Mcescan.cab
    2017-03-22 03:36:22 | PID 13020 | TID 1 | Information | There were errors while processing feed (handled error):'Failed to verify signature of Mcescan.cab'
    2017-03-22 03:36:22 | PID 13020 | TID 1 | Error | Patches have not been successfully updated in the last three days
    2017-03-22 03:36:22 | PID 13020 | TID 1 | Information | -----PROGRAM END-----

  • 0 in reply to saadshawwa

    Hello saadshawwa,

    can't say what it really signifies. I've seen it occasionally, lasting a few hours/cycles at most, but last time is several months ago.
    Dunno if it downloads directly to %ProgramData%\Sophos\Patch\PatchDataLoader\Download\, this is where the file usually resides (mine's from 4:30am today). You could try check its Digital Signatures (from the right-click Properties) but this might not give any insight. I think you have to contact Support directly.

    Christian

  • 0 in reply to QC

    Hello 

    I have the same issue , Patches have not been successfully updated in the last three days in the windows events 

    In the log we found this lane several times : 

    2017-11-10 21:26:38 | PID 856 | 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 x64 (KB2753842)).
    Failed to update patch
    The statement has been terminated.'
    2017-11-10 21:26:39 | PID 856 | 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 x64 (KB2753842)).',Source='.Net SqlClient Data Provider',State='1')
    2017-11-10 21:26:39 | PID 856 | TID 1 | Information | Error(Number='50000',Message='Failed to update patch',Source='.Net SqlClient Data Provider',State='22')
    2017-11-10 21:26:39 | PID 856 | TID 1 | Information | Error(Number='3621',Message='The statement has been terminated.',Source='.Net SqlClient Data Provider',State='0')
    2017-11-10 21:26:39 | PID 856 | 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 x64 (KB2753842)).
    Failed to update patch

     

    This morning update the server (windows 2012 server ) and the enterprise console from 5.3 to 5.5 .This dont work . 

Reply
  • 0 in reply to QC

    Hello 

    I have the same issue , Patches have not been successfully updated in the last three days in the windows events 

    In the log we found this lane several times : 

    2017-11-10 21:26:38 | PID 856 | 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 x64 (KB2753842)).
    Failed to update patch
    The statement has been terminated.'
    2017-11-10 21:26:39 | PID 856 | 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 x64 (KB2753842)).',Source='.Net SqlClient Data Provider',State='1')
    2017-11-10 21:26:39 | PID 856 | TID 1 | Information | Error(Number='50000',Message='Failed to update patch',Source='.Net SqlClient Data Provider',State='22')
    2017-11-10 21:26:39 | PID 856 | TID 1 | Information | Error(Number='3621',Message='The statement has been terminated.',Source='.Net SqlClient Data Provider',State='0')
    2017-11-10 21:26:39 | PID 856 | 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 x64 (KB2753842)).
    Failed to update patch

     

    This morning update the server (windows 2012 server ) and the enterprise console from 5.3 to 5.5 .This dont work . 

Children
Unfiltered HTML