Troubleshooting ETL Issues

Recommendations

Some overall recommendations when working with ETL to minimize issues:

  • Extract Historian data for 30000 tags with 18MM samples per day.
  • Set the Regen Interval to be less than 10 minutes.

Unable to Start the ETL Tools

Issue: When you try to start the Historian ETL Extract, Historian ETL PI Extract, or the Historian ETL Load service, an error occurs.

Diagnostics: If there is a limited bandwidth of the internet, the certificate publisher service times out after 30 seconds. To avoid this issue, disable the publisher service:
  1. Access the configuration file for the service that you want to start. For example, for the Historian ETL Extract service, access the HistorianETLExtract.exe.config file.
  2. Set the element generatePublisherEvidence to disabled.

An Error Occurs When Importing Tag Data into an Excel Spreadsheet

Issue: To specify tags using a template spreadsheet, when you import the tags stored in an .xml file, an error occurs, stating that the data is not valid according to the schema.

Diagnostics: Verify that:
  • You have provided values in all the red-colored columns.
  • Values in the Name column are unique.
  • There are no blank rows.
  • The values that you have entered are valid and of the same data type as defined for each property.
For details, refer to the Tag Properties topic.

Issue: When you attempt to import tag data to an Excel spreadsheet from an .xml file, an error occurs, stating that the .xml file is not linked to schema.

Workaround: Ignore the message.