When a SQL Query activity encounters a system error or fails 24 consecutive times, we suspend it. To find out why your query is suspended, check the action log.
You can’t copy a suspended query, add it to an automation, or run it once.
- When a query is suspended, go to that query’s action log and view the error.
-
Resolve the error, if applicable.
- If the log detail shows the error, “Query activity was terminated,” don’t modify the query activity. The system error will automatically resolve and re-enable your SQL activity.
- For all other errors, fix the problem stated in the error message.
- If you’re not sure what caused the error, check the activity’s settings for issues or optimize the query using intermediate tables. See Optimizing a SQL Query Activity.
-
Save your work.
After you edit and save the query activity, it’s automatically restarted.