Hi Everybody
I noticed that in PatchFeederProcessor.log there is a warning occurring every 6 hours and applicable to a specific patch.
2018-02-27 09:08:02 | PID 15052 | TID 1 | Information | -----PROGRAM START-----
2018-02-27 09:11:35 | PID 15052 | 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 = 'Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding.'
2018-02-27 09:11:35 | PID 15052 | TID 1 | Information | Error(Number='-2',Message='Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding.',Source='.Net SqlClient Data Provider',State='0')
2018-02-27 09:14:36 | PID 15052 | 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 = 'Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding.'
2018-02-27 09:14:36 | PID 15052 | TID 1 | Information | Error(Number='-2',Message='Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding.',Source='.Net SqlClient Data Provider',State='0')
2018-02-27 09:17:36 | PID 15052 | TID 1 | Warning | An SQL exception has been caught while executing 'usp_pf_insupdPatch'. Location = 'Execute command', SQL Error Code = '-2146232060', Message = 'Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding.'
2018-02-27 09:17:36 | PID 15052 | TID 1 | Information | Error(Number='-2',Message='Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding.',Source='.Net SqlClient Data Provider',State='0')
2018-02-27 09:17:36 | PID 15052 | TID 1 | Warning | Failure encountered while inserting or updating patch 2018-02 Security Update for Adobe Flash Player for Windows 8.1 for x86 -based Systems (KB4074595) : Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
2018-02-27 09:17:44 | PID 15052 | TID 1 | Information | -----PROGRAM END-----
We are running Enterprise Console Version 5.5.0. since mid January when we did the last upgrade. The SophosPatch52 database is rather large 1673 MB as we it was upgraded over the years.
SQL Server version is: Microsoft SQL Server 2016 (SP1-GDR) (KB4019089) - 13.0.4206.0 (X64) Jul 6 2017 07:55:03
Copyright (c) Microsoft Corporation Standard Edition (64-bit) on Windows Server 2016 Standard 6.3 <X64> (Build 14393: ) (Hypervisor)
Every failure indicates to the same "2018-02 Security Update for Adobe Flash Player"... The first message was on 23rd of February.
So here are my questions:
1. What is the impact of this on application? Are the other protection files still collected and processed?
2. Is there a way to clear this (e.g. processing this patch manually?)
Any advice would be appreciated?
Regards
Maciej
This thread was automatically locked due to age.
