Data Collector SSIS error in component DFT

Question

I found a periodic error in the Application Event Log that states:

06/01/2021 08:00:03,\Data Collector\QueryActivityUpload,Error,186647,Abfragestatistik,Abfragestatistik - Abfrageaktivität,Error,SSIS error. Component name: DFT - Create Interesting Queries Upload Batch<c/> Code: -2147467259<c/> Subcomponent: SSIS.Pipeline<c/> Description: Unspecified error<nl/>.,Upload,01.06.2021
08:00:03,,01.06.2021 08:00:06,3,NT AUTHORITY\SYSTEM,b21064ea-e4a5-418c-92ba-2ad2dcf75af6,,

06/01/2021 08:00:03,QueryActivityUpload,Information,186647,,,,Beginning of package execution.,,01.06.2021 08:00:03,,01.06.2021 08:00:03,,,,PackageStart,0

06/01/2021 08:00:06,QueryActivityUpload,Error,186647,,,,Unspecified error,,01.06.2021 08:00:06,,01.06.2021 08:00:06,,,,OnError,-2147467259

The error code -2147467259 cannot be found on https://learn.microsoft.com/en-us/sql/integration-services/integration-services-error-and-message-reference?view=sql-server-ver15.

The error occurs in Microsoft SQL Server 2019 (RTM-GDR) (KB4517790) - 15.0.2070.41 (X64).

What is the root cause of this error and how to fix it?

Answer 1

You have already been told in another thread to install the most recent Cumulative Update, so it seems like a good idea to see if the CU also resolves this issue.