Timeout While Getting Jobs Through APIs

GetJobs API error while having 1400+ Folders.

Issue: Timeout while getting jobs through APIs.

Troubleshooting Steps:

  1. SQL error is observed in event viewer log - Microsoft.Data.SqlException (0x80131904): Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
  2. Clean the entries in [dbo].[logs], timeout might still happen
  3. Attempts to increase the value of Connection Timeout in connectionString, issue persists
  4. Observed there are more than 1400 folders by checking [resx].[Folders] table

Resolution:

  • Reduce the folder number which exceeds 1000, may cause performance degrade and error.