We are running Bigfix 9.5.13. Every morning we are finding we need to restart the Bigfix services on the root server because fillDB has lost a connection to the database and apparently cannot reestablish it. These are the errors in the fillDB log that keep repeating until services are stopped.
Tue, 11 Aug 2020 03:06:12 -0700 – 5776 – Encountered error during computer sequences update: Database Error: [Microsoft][SQL Server Native Client 11.0]Communication link failure (08S01: 0)
Tue, 11 Aug 2020 03:06:12 -0700 – 5776 – Error storing reports: Database Error: [Microsoft][SQL Server Native Client 11.0]Communication link failure (08S01: 0)
Tue, 11 Aug 2020 03:06:12 -0700 – 5776 – Encountered error during computer sequences update: Database Error: [Microsoft][SQL Server Native Client 11.0]Communication link failure (08S01: 0)
Tue, 11 Aug 2020 03:06:12 -0700 – 5776 – Error storing reports: Database Error: [Microsoft][SQL Server Native Client 11.0]Communication link failure (08S01: 0)
Tue, 11 Aug 2020 03:06:12 -0700 – 5776 – Encountered error during computer sequences update: Database Error: [Microsoft][SQL Server Native Client 11.0]Communication link failure (08S01: 0)
Tue, 11 Aug 2020 03:06:12 -0700 – 5776 – Error storing reports: Database Error: [Microsoft][SQL Server Native Client 11.0]Communication link failure (08S01: 0)
Tue, 11 Aug 2020 03:06:25 -0700 – 2008 – Encountered error during computer sequences update: Database Error: [Microsoft][SQL Server Native Client 11.0]Communication link failure (08S01: 0)
Tue, 11 Aug 2020 03:06:25 -0700 – 2008 – Error storing reports: Database Error: [Microsoft][SQL Server Native Client 11.0]Communication link failure (08S01: 0)
Tue, 11 Aug 2020 03:06:25 -0700 – 5776 – Encountered error during computer sequences update: Database Error: [Microsoft][SQL Server Native Client 11.0]Communication link failure (08S01: 0)
Tue, 11 Aug 2020 03:06:25 -0700 – 5776 – Error storing reports: Database Error: [Microsoft][SQL Server Native Client 11.0]Communication link failure (08S01: 0)
Tue, 11 Aug 2020 03:06:28 -0700 – 2008 – Encountered error during computer sequences update: Database Error: [Microsoft][SQL Server Native Client 11.0]Communication link failure (08S01: 0)
Tue, 11 Aug 2020 03:06:28 -0700 – 5776 – Encountered error during computer sequences update: Database Error: [Microsoft][SQL Server Native Client 11.0]Communication link failure (08S01: 0)
Tue, 11 Aug 2020 03:06:28 -0700 – 5776 – Error storing reports: Database Error: [Microsoft][SQL Server Native Client 11.0]Communication link failure (08S01: 0)
Tue, 11 Aug 2020 03:06:28 -0700 – 2008 – Error storing reports: Database Error: [Microsoft][SQL Server Native Client 11.0]Communication link failure (08S01: 0)