Troubleshooting and Exception Handling

Common problems and how to fix them

• Issues when loading data in Snowflake and Amazon Redshift
• Errors when executing JavaScript
• Cannot connect to a web service
• Illegal character in path error when working with web services
• Cannot authenticate HTTP call when working with user-defined API
• Cannot add a Flow, a Connection, or a Format

See all 10 articles

Handling exceptions

• Handle exceptions in the Flows and in the transformations
• Execute Flows in case of any error
• Handle exceptions when executing Flows using API

Debugging, monitoring, and troubleshooting flows

• Flow log
• Debug information
• Monitor Flows
• View Last Executed SQL
• Debug a database loop
• Test event-driven Flows in the Etlworks Integrator

See all 7 articles

Debugging and troubleshooting transformations

• Test transformation
• Test a payload

Debugging and troubleshooting HTTP requests

• Parse the response from the HTTP request
• Test and explore API endpoints
• How to debug HTTP requests
• Save the HTTP response to a file

Debugging and troubleshooting JavaScripts

• Add information to the Flow log
• Add debug information
• Throw an exception
• Handle exceptions in JavaScript