Symphony importer fails to download data due to SQL Time Out errors.
Article ID: 1000733901
Updated On:
Description
Error Message
Logging may show the following:
2025-01-22 02:28:43,110 [5] ERROR Merge1.DataAccess.DownloadHistoryDao - Failed to execute [StoredProcedure [[DownloadHistory.UpdateById]] (@Id=374360, @Status=New, @FailureReason=)] after trying 3 times. Giving up.
Error: Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
Operation cancelled by user.
SqlError -2 class 11 in at line 0. State: 0. Error: Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
SqlError 0 class 11 in at line 0. State: 0. Error: Operation cancelled by user.
Cause
This issue can occur due to resource contention and or unresponsiveness on the SQL server.
Resolution
Check the health of the SQL server that the Merge1 databases are hosted on and verify responsiveness and resource availability and resolve.
Check for memory, CPU, disk space, and network connectivity.
Issue/Introduction
Additional Information
