Activation Run Statuses

An Activation synchronizes data from your Warehouse with the Target object. Each run of the Activation progresses through the following three stages in which it identifies, transforms, and loads data:

  1. Ingestion: The Activation run starts in the Ingestion stage as a part of which, the Activation SQL query is performed. The records to be synchronized with the Target object are also identified and fetched in this stage.

  2. Transformation: In the Transformation stage, the records from the Warehouse that are to be synchronized are transformed as per the Target object schema. This stage is marked as complete when it triggers the Loading stage.

  3. Loading: In the Loading stage, the transformed records are uploaded to the staging location and then synchronized with the Target object. The end of the Loading stage marks the completion of the Activation run.

Hevo uses the following statuses to inform you about the progress or failure of the Activation run over the three stages:

  • QUEUED: The Activation has just been created and is scheduled to start.

  • TRANSFORMATION RUNNING: The Activation SQL query is performed and the records to be synchronized are fetched. The records are being transformed to the Target object schema according to the defined field mapping.

  • TRANSFORMATION FAILED: The Activation run has failed due to an error in the transformation, and the current run is terminated. The next run starts as per the Activation schedule.

  • SHELVED: The Activation run has been shelved or skipped as the SQL query did not return any new records to be synchronized with the Target object.

  • TRIGGER LOAD FAILED: The Activation run has failed as the Transformation stage failed to trigger the Loading stage.

  • TRANSFORMATION COMPLETED: The records to be synchronized have been transformed as per the Target object schema.

  • LOADING: The transformed records are synchronized with the Target object.

  • TARGET FAILED: The Activation run has failed as Hevo was unable to connect to the Target after several tries.

  • LOADING FAILED: The Activation run has failed due to an error while loading the transformed records to the Target or the staging location.

  • COMPLETED: The records have been synchronized with the Target object and loading has been completed. The Activation run is successful.

  • DEFERRED: The Activation run has been deferred for some time due to a constraint enforced by Target. This usually happens when your API limits are exceeded while calling an API provided by Target.

  • CANCELLED: The Activation run is terminated or canceled by Hevo Support.

The current Activation run is stopped and marked with one of the FAILED statuses whenever a failure is encountered at any stage. A failed run also marks the Activation as FAILED. The next run, however, starts as per the Activation schedule unless the previous run was marked as DEFERRED.

You can view the status of your Activation run from the Sync History tab in the Activations Detailed View. To view the activity log for a particular Activation run, click VIEW DETAILS in its sync details row. Read View Activation Run Details.

Activation Run Statuses


View Activation Run Details

If records are not synchronized with the Target object due to a failure in the Activation run, they are marked as Failed and are added to the failure count displayed in the Sync History page. You can view the details of the failed records as well as the activity log for any Activation from the Activations Detailed View.

View Failed Records

To view the failed records for an Activation:

  1. Click anywhere in the Activations Summary row in the list view to open the Activation in its detailed view.

  2. Click the Sync History icon in the Tools Bar.

  3. Click on the Records Failed count in the desired sync details row. The number of records that failed, the failure stage, and the failure reason is displayed.

    View Failed Records

  4. Click REPORT to download the report of all the failed records in CSV format, or click SAMPLE to view the data of a failed sample record.


View Activity Log

To view the Activity Log of an Activation run:

  1. Click anywhere in the Activations Summary row in the list view to open the Activation in its detailed view.

  2. Click VIEW DETAILS in the desired sync details row.

    View Details

  3. In the ACTIVITY LOG pop-up dialog that is displayed, click on any row to view its details.

    Activity Log Details


Revision History

Refer to the following table for the list of key updates made to this page:

Date Release Description of Change
Dec-20-2021 1.78 New document.
Last updated on 15 Dec 2021