---
schema_version: "1"
id: 62e266c54cc8a49bc4a4531aa6afde677454795ad3d9d5f909c850b81a62b9b9
title: Automation Studio Errors
collection: admin
version: current
locale: en-us
portal_url: https://docs.salesforce.com/admin/current/en-us/mktg/264-0-0/mc_as_automation_studio_errors.md
canonical_url: https://help.salesforce.com/s/articleView?id=mktg.mc_as_automation_studio_errors.htm&release=264.0.0&type=5
source_site: help.salesforce.com
content_type: documentation
content_hash: a6f6653ecb47a414c84a258a8f6b71a739d5bf907b5877b172b289ff9ba6ffaa
description: Find out what Automation Studio error messages mean and how to resolve them. After applying the suggested action, run the activity or automation again to make sure that the error was addressed.
products:
  - Marketing
  - Marketing Cloud Engagement
release: "264"
---
# Automation Studio Errors

Find out what Automation Studio error messages mean and how to resolve them. After applying the suggested action, run the activity or automation again to make sure that the error was addressed.

## SQL Query Activity Errors

<table class="slds-table slds-table_bordered slds-max-medium-table_stacked slds-m-bottom_small ">
        <colgroup>
          <col style="width:33.33333333333333%">
          <col style="width:33.33333333333333%">
          <col style="width:33.33333333333333%">
        </colgroup>
        <thead class="slds-text-title_caps ">
          <tr class="">
            <th scope="col" class="slds-cell-wrap" style="vertical-align:top;" id="d55921e43">Error Text</th>
            <th scope="col" class="slds-cell-wrap" style="vertical-align:top;" id="d55921e46">Meaning</th>
            <th scope="col" class="slds-cell-wrap" style="vertical-align:top;" id="d55921e49">Suggested Action</th>
          </tr>
        </thead>
        <tbody>
          <tr class="">
            <td data-label="Error Text" class="slds-cell-wrap" style="vertical-align:top;" headers="d55921e43 ">Query definition doesn’t exist.</td>

            <td data-label="Meaning" class="slds-cell-wrap" style="vertical-align:top;" headers="d55921e46 ">The query was deleted.</td>

            <td data-label="Suggested Action" class="slds-cell-wrap" style="vertical-align:top;" headers="d55921e49 ">Recreate the SQL Query activity.</td>

          </tr>
          <tr class="">
            <td data-label="Error Text" class="slds-cell-wrap" style="vertical-align:top;" headers="d55921e43 ">Query failed during execution. Error: Violation of PRIMARY KEY
              constraint. Can’t insert duplicate key in object '{{DE name}}'. The
              duplicate key value is (123456789).</td>

            <td data-label="Meaning" class="slds-cell-wrap" style="vertical-align:top;" headers="d55921e46 ">The query source is missing a primary key, or it contains duplicate keys. The
              destination requires a unique primary key, and the mismatch causes duplicate records
              in the destination Data Extension.</td>

            <td data-label="Suggested Action" class="slds-cell-wrap" style="vertical-align:top;" headers="d55921e49 ">
              <ul>
                <li>Add a primary key field in the source Data Extension.</li>

                <li>Group records by the primary key of the destination Data Extension.</li>

                <li>Dedupe records using window functions.</li>

                <li>Remove the primary key from the destination.</li>

              </ul>
            </td>

          </tr>
          <tr class="">
            <td data-label="Error Text" class="slds-cell-wrap" style="vertical-align:top;" headers="d55921e43 ">Query failed: Timeout</td>

            <td data-label="Meaning" class="slds-cell-wrap" style="vertical-align:top;" headers="d55921e46 ">The query took too long to run.</td>

            <td data-label="Suggested Action" class="slds-cell-wrap" style="vertical-align:top;" headers="d55921e49 ">
              <ul>
                <li>If this timeout error doesn’t typically occur, retry the
                  activity or automation that it's part of.</li>

                <li>If this error recurs, see <a href="https://help.salesforce.com/s/articleView?id=mktg.mc_as_optimize_the_query_activity.htm&amp;release=264.0.0&amp;type=5" title="SQL query activities time out after 30 minutes. You can prevent timeouts and failures by optimizing your SQL query activities. If your query consistently runs longer than 10 minutes, we recommend using a different tool, such as Salesforce Customer Data Platform, to transform your data.">Optimizing a SQL Query Activity</a>.</li>

              </ul>
            </td>

          </tr>
          <tr class="">
            <td data-label="Error Text" class="slds-cell-wrap" style="vertical-align:top;" headers="d55921e43 ">Query failed during execution. Error: Conversion failed when
              converting the nvarchar value '123ABC' to data type int.</td>

            <td data-label="Meaning" class="slds-cell-wrap" style="vertical-align:top;" headers="d55921e46 ">The query source has an alphanumeric field, but the destination
              has a number field.</td>

            <td data-label="Suggested Action" class="slds-cell-wrap" style="vertical-align:top;" headers="d55921e49 ">Update either the query source or the destination so the data
              types match.</td>

          </tr>
          <tr class="">
            <td data-label="Error Text" class="slds-cell-wrap" style="vertical-align:top;" headers="d55921e43 ">Query failed during execution. Error: String or binary data would
              be truncated.</td>

            <td data-label="Meaning" class="slds-cell-wrap" style="vertical-align:top;" headers="d55921e46 ">The query source has a longer field length than the destination
              field.</td>

            <td data-label="Suggested Action" class="slds-cell-wrap" style="vertical-align:top;" headers="d55921e49 ">Increase the destination field length so that it allows the same
              number of characters.</td>

          </tr>
          <tr class="">
            <td data-label="Error Text" class="slds-cell-wrap" style="vertical-align:top;" headers="d55921e43 ">Query failed during execution. Error: Invalid column name
              '{{column name}}'.</td>

            <td data-label="Meaning" class="slds-cell-wrap" style="vertical-align:top;" headers="d55921e46 ">Either the source or the destination has a field that was renamed
              or deleted.</td>

            <td data-label="Suggested Action" class="slds-cell-wrap" style="vertical-align:top;" headers="d55921e49 ">Check for columns and fields that were changed or
              deleted.</td>

          </tr>
          <tr class="">
            <td data-label="Error Text" class="slds-cell-wrap" style="vertical-align:top;" headers="d55921e43 ">Query failed during execution. Error: Invalid object name
              'QueryTest_100'. Error has occurred.</td>

            <td data-label="Meaning" class="slds-cell-wrap" style="vertical-align:top;" headers="d55921e46 ">Either the source or the destination has been deleted, renamed,
              or is otherwise unavailable.</td>

            <td data-label="Suggested Action" class="slds-cell-wrap" style="vertical-align:top;" headers="d55921e49 ">Confirm that the source and destination data extensions
              exist.</td>

          </tr>
          <tr class="">
            <td data-label="Error Text" class="slds-cell-wrap" style="vertical-align:top;" headers="d55921e43 ">Query failed: Query not allowed</td>

            <td data-label="Meaning" class="slds-cell-wrap" style="vertical-align:top;" headers="d55921e46 ">Queries aren’t available for your account.</td>

            <td data-label="Suggested Action" class="slds-cell-wrap" style="vertical-align:top;" headers="d55921e49 ">Open a support case in Salesforce Help.</td>

          </tr>
          <tr class="">
            <td data-label="Error Text" class="slds-cell-wrap" style="vertical-align:top;" headers="d55921e43 ">Query failed due to system error.</td>

            <td data-label="Meaning" class="slds-cell-wrap" style="vertical-align:top;" headers="d55921e46 ">A system error occurred.</td>

            <td data-label="Suggested Action" class="slds-cell-wrap" style="vertical-align:top;" headers="d55921e49 ">Retry the activity or automation. If the error persists, open a
              support case in Salesforce Help.</td>

          </tr>
          <tr class="">
            <td data-label="Error Text" class="slds-cell-wrap" style="vertical-align:top;" headers="d55921e43 ">SQL Query activity cannot be executed at this time.</td>

            <td data-label="Meaning" class="slds-cell-wrap" style="vertical-align:top;" headers="d55921e46 ">This error can occur when the database has a high volume of write
              activity.</td>

            <td data-label="Suggested Action" class="slds-cell-wrap" style="vertical-align:top;" headers="d55921e49 ">Retry the activity or automation. If the error persists, open a
              support case in Salesforce Help.</td>

          </tr>
        </tbody>
      </table>

## File Transfer Activity Errors

<table class="slds-table slds-table_bordered slds-max-medium-table_stacked slds-m-bottom_small ">
        <colgroup>
          <col style="width:33.33333333333333%">
          <col style="width:33.33333333333333%">
          <col style="width:33.33333333333333%">
        </colgroup>
        <thead class="slds-text-title_caps ">
          <tr class="">
            <th scope="col" class="slds-cell-wrap" style="vertical-align:top;" id="d55921e231">Error Text</th>
            <th scope="col" class="slds-cell-wrap" style="vertical-align:top;" id="d55921e234">Meaning</th>
            <th scope="col" class="slds-cell-wrap" style="vertical-align:top;" id="d55921e237">Suggested Action</th>
          </tr>
        </thead>
        <tbody>
          <tr class="">
            <td data-label="Error Text" class="slds-cell-wrap" style="vertical-align:top;" headers="d55921e231 ">File not found matching the pattern: {{pattern}}</td>

            <td data-label="Meaning" class="slds-cell-wrap" style="vertical-align:top;" headers="d55921e234 ">The source file that the activity expected to find is missing, or no file
              matching the file naming pattern was found.</td>

            <td data-label="Suggested Action" class="slds-cell-wrap" style="vertical-align:top;" headers="d55921e237 ">
              <ul>
                <li>Verify that the naming pattern of the file matches the pattern configured for
                  the activity.</li>

                <li>Verify that the file was dropped in the intended location.</li>

              </ul>
            </td>

          </tr>
          <tr class="">
            <td data-label="Error Text" class="slds-cell-wrap" style="vertical-align:top;" headers="d55921e231 ">Invalid File Age</td>

            <td data-label="Meaning" class="slds-cell-wrap" style="vertical-align:top;" headers="d55921e234 ">The timestamp on the file is invalid, or a setting in the activity
              configuration prevents files of a specified age from being processed.</td>

            <td data-label="Suggested Action" class="slds-cell-wrap" style="vertical-align:top;" headers="d55921e237 ">Ensure that the file isn’t older than the defined age limit or modify the age
              limit setting.</td>

          </tr>
          <tr class="">
            <td data-label="Error Text" class="slds-cell-wrap" style="vertical-align:top;" headers="d55921e231 ">Authentication with the server failed</td>

            <td data-label="Meaning" class="slds-cell-wrap" style="vertical-align:top;" headers="d55921e234 ">Server authentication failed.</td>

            <td data-label="Suggested Action" class="slds-cell-wrap" style="vertical-align:top;" headers="d55921e237 ">
              <ul>
                <li>Confirm that your FTP location is valid.</li>

                <li>Confirm that your external file location credentials are valid and that your
                  session is active.</li>

              </ul>
            </td>

          </tr>
          <tr class="">
            <td data-label="Error Text" class="slds-cell-wrap" style="vertical-align:top;" headers="d55921e231 ">Invalid username or password reported by server.</td>

            <td data-label="Meaning" class="slds-cell-wrap" style="vertical-align:top;" headers="d55921e234 ">Server authentication failed due to an invalid username or password.</td>

            <td data-label="Suggested Action" class="slds-cell-wrap" style="vertical-align:top;" headers="d55921e237 ">
              <ul>
                <li>Confirm that your location is valid.</li>

                <li>Confirm that your external file location credentials are valid and that your
                  session is active.</li>

              </ul>
            </td>

          </tr>
          <tr class="">
            <td data-label="Error Text" class="slds-cell-wrap" style="vertical-align:top;" headers="d55921e231 ">Server returned an error: Permission denied</td>

            <td data-label="Meaning" class="slds-cell-wrap" style="vertical-align:top;" headers="d55921e234 ">Server authentication failed due to a permission error.</td>

            <td data-label="Suggested Action" class="slds-cell-wrap" style="vertical-align:top;" headers="d55921e237 ">
              <ul>
                <li>Confirm that your location is valid and configured correctly.</li>

                <li>Confirm that the username provided in the file location definition has
                  permission to access the destination folder.</li>

              </ul>
            </td>

          </tr>
          <tr class="">
            <td data-label="Error Text" class="slds-cell-wrap" style="vertical-align:top;" headers="d55921e231 ">The process can’t access the file '{{filename}}' because it’s being used by
              another process.</td>

            <td data-label="Meaning" class="slds-cell-wrap" style="vertical-align:top;" headers="d55921e234 ">A file lock error occurred.</td>

            <td data-label="Suggested Action" class="slds-cell-wrap" style="vertical-align:top;" headers="d55921e237 ">
              <ul>
                <li>If this error doesn’t typically occur, retry the activity or the
                  automation.</li>

                <li>If this error continues, make sure the file isn’t being used by another
                  process.</li>

              </ul>
            </td>

          </tr>
          <tr class="">
            <td data-label="Error Text" class="slds-cell-wrap" style="vertical-align:top;" headers="d55921e231 ">There was an error connecting to the target server.</td>

            <td data-label="Meaning" class="slds-cell-wrap" style="vertical-align:top;" headers="d55921e234 ">The connected host failed to respond.</td>

            <td data-label="Suggested Action" class="slds-cell-wrap" style="vertical-align:top;" headers="d55921e237 ">Verify that your FTP host entry is configured correctly.</td>

          </tr>
          <tr class="">
            <td data-label="Error Text" class="slds-cell-wrap" style="vertical-align:top;" headers="d55921e231 ">The remote host forcibly closed an existing connection.</td>

            <td data-label="Meaning" class="slds-cell-wrap" style="vertical-align:top;" headers="d55921e234 ">The remote host connection was lost.</td>

            <td data-label="Suggested Action" class="slds-cell-wrap" style="vertical-align:top;" headers="d55921e237 ">Check the destination server settings to reenable the connection.</td>

          </tr>
          <tr class="">
            <td data-label="Error Text" class="slds-cell-wrap" style="vertical-align:top;" headers="d55921e231 ">Idle connection category</td>

            <td data-label="Meaning" class="slds-cell-wrap" style="vertical-align:top;" headers="d55921e234 ">The FTP that you’re trying to transfer files to is having a connectivity
              issue.</td>

            <td data-label="Suggested Action" class="slds-cell-wrap" style="vertical-align:top;" headers="d55921e237 ">Check the FTP connection.</td>

          </tr>
          <tr class="">
            <td data-label="Error Text" class="slds-cell-wrap" style="vertical-align:top;" headers="d55921e231 ">We can’t decrypt the file because the packet type doesn’t follow the correct
              standard. Encrypt the file following the RFC 4880 standard and try again.</td>

            <td data-label="Meaning" class="slds-cell-wrap" style="vertical-align:top;" headers="d55921e234 ">The file contains a packet type that isn’t part of the RFC 4880 standard. For
              example, packet type 20 is a draft and not standardized.</td>

            <td data-label="Suggested Action" class="slds-cell-wrap" style="vertical-align:top;" headers="d55921e237 ">Encrypt the file in compliance with RFC 4880.</td>

          </tr>
          <tr class="">
            <td data-label="Error Text" class="slds-cell-wrap" style="vertical-align:top;" headers="d55921e231 ">We couldn't complete the file transfer. Validate the activity and file location
              parameters and try again.</td>

            <td data-label="Meaning" class="slds-cell-wrap" style="vertical-align:top;" headers="d55921e234 ">The file transfer wasn't completed.</td>

            <td data-label="Suggested Action" class="slds-cell-wrap" style="vertical-align:top;" headers="d55921e237 ">Verify the activity parameters and file locations. Wait for 30 minutes, and
              then retry the transfer.</td>

          </tr>
        </tbody>
      </table>

## Data Copy or Import Activity Errors

<table class="slds-table slds-table_bordered slds-max-medium-table_stacked slds-m-bottom_small ">
        <colgroup>
          <col style="width:33.33333333333333%">
          <col style="width:33.33333333333333%">
          <col style="width:33.33333333333333%">
        </colgroup>
        <thead class="slds-text-title_caps ">
          <tr class="">
            <th scope="col" class="slds-cell-wrap" style="vertical-align:top;" id="d55921e445">Error Text</th>
            <th scope="col" class="slds-cell-wrap" style="vertical-align:top;" id="d55921e448">Meaning</th>
            <th scope="col" class="slds-cell-wrap" style="vertical-align:top;" id="d55921e451">Suggested Action</th>
          </tr>
        </thead>
        <tbody>
          <tr class="">
            <td data-label="Error Text" class="slds-cell-wrap" style="vertical-align:top;" headers="d55921e445 ">Import failed: File {{filename}} not found</td>

            <td data-label="Meaning" class="slds-cell-wrap" style="vertical-align:top;" headers="d55921e448 ">The source file that the activity expected to find is missing, or
              no file matching the file naming pattern was found.</td>

            <td data-label="Suggested Action" class="slds-cell-wrap" style="vertical-align:top;" headers="d55921e451 ">
              <ul>
                <li>Verify that the naming pattern of the file matches the
                  pattern configured for the activity.</li>

                <li>Verify that the file was dropped in the intended
                  location.</li>

              </ul>
            </td>

          </tr>
          <tr class="">
            <td data-label="Error Text" class="slds-cell-wrap" style="vertical-align:top;" headers="d55921e445 ">Import failed: Invalid file age</td>

            <td data-label="Meaning" class="slds-cell-wrap" style="vertical-align:top;" headers="d55921e448 ">The timestamp on the file is invalid or a setting in the activity
              configuration prevents files of a specified age from being
              processed.</td>

            <td data-label="Suggested Action" class="slds-cell-wrap" style="vertical-align:top;" headers="d55921e451 ">Ensure that the file isn’t older than the defined age limit, or modify the age
              limit setting.</td>

          </tr>
          <tr class="">
            <td data-label="Error Text" class="slds-cell-wrap" style="vertical-align:top;" headers="d55921e445 ">Import failed: Invalid file source</td>

            <td data-label="Meaning" class="slds-cell-wrap" style="vertical-align:top;" headers="d55921e448 ">The file source is invalid.</td>

            <td data-label="Suggested Action" class="slds-cell-wrap" style="vertical-align:top;" headers="d55921e451 ">Enter a valid file source.</td>

          </tr>
          <tr class="">
            <td data-label="Error Text" class="slds-cell-wrap" style="vertical-align:top;" headers="d55921e445 ">Import failed: File location invalid</td>

            <td data-label="Meaning" class="slds-cell-wrap" style="vertical-align:top;" headers="d55921e448 ">The file location is invalid.</td>

            <td data-label="Suggested Action" class="slds-cell-wrap" style="vertical-align:top;" headers="d55921e451 ">Enter a valid file location.</td>

          </tr>
          <tr class="">
            <td data-label="Error Text" class="slds-cell-wrap" style="vertical-align:top;" headers="d55921e445 ">Import failed due to system error.</td>

            <td data-label="Meaning" class="slds-cell-wrap" style="vertical-align:top;" headers="d55921e448 ">A system error occurred.</td>

            <td data-label="Suggested Action" class="slds-cell-wrap" style="vertical-align:top;" headers="d55921e451 ">Retry the activity or automation. If this error persists, open a
              support case in Salesforce Help.</td>

          </tr>
          <tr class="">
            <td data-label="Error Text" class="slds-cell-wrap" style="vertical-align:top;" headers="d55921e445 ">We couldn’t import your file. Verify that your Salesforce
              integration is valid and try again.</td>

            <td data-label="Meaning" class="slds-cell-wrap" style="vertical-align:top;" headers="d55921e448 ">Salesforce Objects and Reports couldn’t be imported because the
              Salesforce integration connection wasn’t established.</td>

            <td data-label="Suggested Action" class="slds-cell-wrap" style="vertical-align:top;" headers="d55921e451 ">Verify that your Salesforce integration is functional in the
              Email Studio Admin settings.</td>

          </tr>
          <tr class="">
            <td data-label="Error Text" class="slds-cell-wrap" style="vertical-align:top;" headers="d55921e445 ">We couldn’t import your file because the last import occurred
              less than {{MaxFrequencyHours}} ago.</td>

            <td data-label="Meaning" class="slds-cell-wrap" style="vertical-align:top;" headers="d55921e448 ">The latest import ran too recently for the import to run
              again.</td>

            <td data-label="Suggested Action" class="slds-cell-wrap" style="vertical-align:top;" headers="d55921e451 ">Wait at least the MaxFrequencyHours before running the import
              again or shorten the MaxFrequencyHours.</td>

          </tr>
          <tr class="">
            <td data-label="Error Text" class="slds-cell-wrap" style="vertical-align:top;" headers="d55921e445 ">We couldn’t import your file. Verify that the destination is
              valid and try again.</td>

            <td data-label="Meaning" class="slds-cell-wrap" style="vertical-align:top;" headers="d55921e448 ">The file location for the import doesn’t exist.</td>

            <td data-label="Suggested Action" class="slds-cell-wrap" style="vertical-align:top;" headers="d55921e451 ">Ensure that the file location for the import still exists. Then
              add the file location to the import definition again.</td>

          </tr>
          <tr class="">
            <td data-label="Error Text" class="slds-cell-wrap" style="vertical-align:top;" headers="d55921e445 ">We couldn’t import your file. Verify that the file {{Filename}}
              contains data and try again.</td>

            <td data-label="Meaning" class="slds-cell-wrap" style="vertical-align:top;" headers="d55921e448 ">The file for import contained no data.</td>

            <td data-label="Suggested Action" class="slds-cell-wrap" style="vertical-align:top;" headers="d55921e451 ">Confirm that the file has data.</td>

          </tr>
          <tr class="">
            <td data-label="Error Text" class="slds-cell-wrap" style="vertical-align:top;" headers="d55921e445 ">We couldn’t import your file. Verify that the field mappings are
              valid and try again.</td>

            <td data-label="Meaning" class="slds-cell-wrap" style="vertical-align:top;" headers="d55921e448 ">The import field mapping was invalid. For example, the columns
              are incorrect or the import fields aren’t correctly mapped.</td>

            <td data-label="Suggested Action" class="slds-cell-wrap" style="vertical-align:top;" headers="d55921e451 ">Verify that the file’s columns match the import field
              mapping.</td>

          </tr>
          <tr class="">
            <td data-label="Error Text" class="slds-cell-wrap" style="vertical-align:top;" headers="d55921e445 ">We couldn’t connect to your external FTP. Check your credentials
              and try again.</td>

            <td data-label="Meaning" class="slds-cell-wrap" style="vertical-align:top;" headers="d55921e448 ">The external file location was unavailable due to an
              authentication issue, such as an invalid username or
              password.</td>

            <td data-label="Suggested Action" class="slds-cell-wrap" style="vertical-align:top;" headers="d55921e451 ">Check the credentials for the FTP File Location in Setup and
              validate your configuration.</td>

          </tr>
          <tr class="">
            <td data-label="Error Text" class="slds-cell-wrap" style="vertical-align:top;" headers="d55921e445 ">We couldn’t connect to your external FTP. Try again
              later.</td>

            <td data-label="Meaning" class="slds-cell-wrap" style="vertical-align:top;" headers="d55921e448 ">The external file location was unavailable for connection. For
              example, if the service was offline.</td>

            <td data-label="Suggested Action" class="slds-cell-wrap" style="vertical-align:top;" headers="d55921e451 ">Confirm that your FTP is online.</td>

          </tr>
        </tbody>
      </table>

## Filter Activity Errors

  
| Error Text | Meaning | Suggested Action |
| --- | --- | --- |
| We couldn’t find an expected field in the source data extension. Make sure that the fields used by the filter definition are configured in the data extension and try again. | A field is used by the filter definition but not included in the source data extension. | Confirm that the data extension includes all data required for the filter definition. |
| We couldn’t find the source data extension. Make sure that the filter definition references the correct data extension and try again. | The source data extension that was originally used in the filter definition no longer exists. | Update the filter definition to use a valid source data extension. |
| We couldn’t find the destination data extension. Make sure that the filter definition references the correct data extension and try again. | The destination data extension that was originally used in the filter definition no longer exists. | Update the filter definition to use a valid destination data extension. |
| We couldn't start the filter activity. A Filter Activity Instance Destination not found for DestinationObjectID \[id\]. Please correct the issue and try again. | The destination subscriber list or data extension is invalid or has been deleted. | Ensure the destination is a subscriber list or data extension and is active. If the destination is a deleted data extension, restore it from the Contact Builder recycle bin. |

## Send Email Activity Errors

  
| Error Text | Meaning | Suggested Action |
| --- | --- | --- |
| Stopped because the job is in a terminal status. | A send was canceled via Email Tracking or another method before the STO send was completed. | No action needed. This message is a warning. |

## Data Extract Activity Errors

  
| Error Text | Meaning | Suggested Action |
| --- | --- | --- |
| We couldn’t find a source data extension for the extract. Review the data extract configuration, and try again. | The activity is attempting to extract data from a data extension that no longer exists. | Check the activity and enter a correct data extension. |
| Extracts are currently processing. Wait until processing is complete and try again. | We can't process this many data extracts at the same time. | Wait until one or more data extract activities are complete before starting another one. |
| Extracted files exceeded the storage limit. Adjust parameters and try again. | The extracted files exceeded the allowed disk space. | Try running the extract with a smaller data set—reduce the time range or the number of records extracted. |
| Extract took too long to run. Adjust parameters and try again. | The extract took longer to run than the system allows. | Try running the extract with a smaller data set—reduce the time range or the number of records extracted. |
| The system is experiencing an issue. Wait and try again. | A system issue is preventing the extract from completing. | Wait for 30 minutes, and then retry the extract. |

- **[Automatically Deactivated Automations](https://help.salesforce.com/s/articleView?id=mktg.mc_as_automatically_paused_or_deactivated_automations.htm&release=264.0.0&type=5)**  
    When an automation fails repeatedly over an extended time period, the automation is deactivated to improve system stability and performance. When an automation is deactivated, you receive an email notification to the email address entered in the automation’s Notification Settings > Runtime Error or Skipped Run box. An inactive automation can’t run again until it’s fixed and reactivated. This feature is turned on for all accounts and can’t be turned off.

#### See Also

- [Optimizing a SQL Query Activity](https://help.salesforce.com/s/articleView?id=mktg.mc_as_optimize_the_query_activity.htm&release=264.0.0&type=5 "SQL query activities time out after 30 minutes. You can prevent timeouts and failures by optimizing your SQL query activities. If your query consistently runs longer than 10 minutes, we recommend using a different tool, such as Salesforce Customer Data Platform, to transform your data.")
- [Use Intermediate Tables to Optimize a Query](https://help.salesforce.com/s/articleView?id=mktg.mc_as_use_intermediate_tables_to_optimize_a_query.htm&release=264.0.0&type=5 "Split large queries into smaller components to use with Automation Studio’s query activity.")
- [Validate Your Server-Side JavaScript using WSProxy](https://developer.salesforce.com/docs/marketing/marketing-cloud/guide/ssjs_error_handling)