Workflow Failure Script

Issue: Workflow fails in workspace

Error: Time out issue
Solution:
  1. go to the failing workflow,
  2. go to the section that fails,
  3. limit steps, you can do auto or Manuel limit. Recommended CSM Limit Steps to 100

Issue: Workflow failure

Error: Failed to preview
Solution:
  1. Check workflow error message, see error message
  2. Check the integration set that failed
  3. Check the sources in the int integration set
  4. Find the source failing to preview
  5. Run Source and Debug after it fails (in SSMS or datagrip or whatever tool you want to use to hit the source directly)
  6. Other option would be to ask the client if they changed anything at the source (Like a column name)