ETL Refresh Diagnosis & Repair
A refresh (a.k.a. ETL refresh, refresh job, refresh process) is a DataSelf ETL process that updates a DataSelf Data Warehouse with data from a data source. Do not confuse this type of refresh with a DSA refresh.
Problems & Solutions / Troubleshooting
This section covers ETL refresh issues that are not connected to any one ETL refresh log error message.
- ETL Refresh is taking too long (SQL Server Performance and RAM) - The DataSelf ETL refresh refresh is taking much more time to finish than it did previously. For example a refresh which recently took 2 hours to complete, now takes 3, 4, or even 5 hours.
- Error sending emails from some servers
- How to Abort a Refresh
- ODBC Connection Problems - ODBC connections rely on a number of factors that can fail during an overnight refresh. In many cases the ODBC connection worked yesterday and it works now but a problem was encountered during an overnight refresh.
- Tables not Refreshing
- Excel Troubleshooting - Refreshing data when an Excel file is the Data Source.
More Information on the Refresh Process