Increasing the Timeout Value for an Import/Export Scheduler Job

Overview

This article aims to resolve issues with timeouts in the import/export scheduler job. Depending on the size of the export file, this may be due to the scheduler's job timing out.

When you run SELECT * FROM ExportImportJobLogs WHERE Level > 2 to look at the import-export failure logs, you will see an error such as:

234653 83 EXCEPTION importing job #83 Timeout.
Database is locked for more than 00:01:00. 3 2019-11-13T08:16:14.477 

234651 83 EXCEPTION importing job #83 Timeout.
Database is locked for more than 00:01:00. 3 2019-11-13T08:14:36.33 

Solution

The unreliability of your import process could be due to multiple timeouts that occurred during the import process.

To work around this issue, you will need to increase the database connection timeout and max pool size.

• Apply the configuration below to DNN's web.config file, which is located in the root directory of the DNN installation directory.
  
  

  <add name="SiteSqlServer" connectionString="<YourDatabase URL>;Initial
    Catalog=<Your database name>;User ID=<DB User>;Password=<DB user
    password>;Connect Timeout=14400;Max Pool Size=100;Pooling=True;"
   providerName="System.Data.SqlClient" />

Restart your instance and recycle the application pool once the modification has been made. Try to re-import again and see if the issue persists.

Back to top