Troubleshooting the FactoryTalk Batch Extractor

Use a yml Lint site to validate your .yml file.

View the log file in the logging folder (as configured in the configuration file) for any error messages.

Double-check your connection string.

Double-check that all references to dataset and pipeline IDs are correct.

Double-check that the client ID and secret in the on-prem configuration file is correct.

If the extractor starts and data is fetched successfully but fails while pushing data into CDF, verify that the scopes are properly assigned in auth0.

If the extractor ran successfully and extraction was complete, but no data or only few rows is pushed into CDF, check whether the primary key defined in the config.yml file exists in the source table.

If the extractor ran successfully but no data was extracted, try running the query defined in the queries section of the config.yml file into the SQL server.