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
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;"
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.