for some time we have the problem that SSIS packages sometimes terminated unexpectedly - not reproducible. I have already found other similar problems and also checked the suggested solutions like checking the retention of the SSISDB or see if auto cleanup is set to enable in this regard:
The exact error message (found in the Windows event log) is:
The SSIS Execution Process could not write to the IS catalog: SERVERNAME:SSISDB Error details: Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding.; at System.Data.SqlClient.SqlConnection.OnError
SQL Server: Microsoft SQL Server 2019 (RTM-CU16-GDR) (KB5014353) - 15.0.4236.7 (X64) May 29 2022 15:55:47 Copyright (C) 2019 Microsoft Corporation Enterprise Edition (64-bit) on Windows Server 2019 Standard 10.0 (Build 17763: )
Further info: Its our production environment which is a failover cluster with three nodes.
The error does not occur so far in our development and test environment (Non-cluster environments).
Anyone tips or could observe similar?
