ETL+ Troubleshooting

Understanding error messages, troubleshooting and fixes to ETL+ problems

In this section

ETL+ Error Messages — ETL+ error and warning messages. Text of messages found in ETL+ log files or on ETL+ screens , their meaning and appropriate actions to take in response.

ETL+ Installation Troubleshooting — ETL+ not starting or crashing.

Extraction Errors

Upsert Missing or Duplicating Rows — Troubleshooting Upsert.

"Driver installation failure" "Access database engine" / Excel — Error message when attempting to open an Excel, .csv or MS Access file.

Access Database Engine: Required for ETL+ Excel, .csv & MS Access — ETL+ requires that the Microsoft Access database engine 2016 is available as a driver in order to read / connect, as data sources, to MS Excel workbooks, .CSV, text, and MS Access databases. This engine is a required driver for Excel, CSV, Text and MS Access source objects.

Convert version? Message. — Message: Convert version? Please confirm you want to convert from version <prior-version> to version <current-version>.

Warning: CSV ... has duplicated column name(s) — Warning: CSV <csv-file-name> has duplicated column name(s): <column-name>. ETL+ is mapping only the first occurrence of each column.

ETL+'s "Hidden Folders" — How to delete the so called “hidden folders”. These folders contain configuration information/metadata and are store locally on the computer server executing any copy of ETL+.

No Log Records for Run Job — After Run Job > Run Job via Agent on Job page no log records are added to ETL Log.

Other Troubleshooting Pages

ETL+ Issues Importing from Excel Also .csv and Microsoft Access files
Microsoft T-SQL – T-SQL is the SQL dialect used by the ETL+ Design Page, and the ETL+ Load Upsert, and ETL+ Load Replace panels.
ETL+ Extract SQL Statement Panel
DataSelf Agent Service - Configure for Auto Start – The DataSelf Agent service may not startup at Windows bootup unless properly configured.

The SQL statements and syntax used in the Extract SQL Statement panel must work with the SQL syntax supported by the ETL+ Source Driver used to connect to the associated Source Object.