Contents x
    Retry
      • Dark
        Light
      Contents

      Retry

        • Dark
          Light
        Article Summary

        Retry Component

        The Retry component lets you repeatedly try to run a connected component until it succeeds (or a maximum number of attempts is reached). This component is used like an iterator component, where it is attached to an existing component.

        During the wait time between retries, nothing is shown in the task panel, and it may appear that although the job run hasn't completed yet, it isn't working on anything either. Once the current wait time is reached, the task will be added to the run for its next attempt and the job will continue.

        Take care when using the Retry component inside a transaction block (between the Begin and Commit components). If an error occurs on the machine, or the platform Matillion ETL is running on, retrying will also fail because the transaction has not yet been rolled back. It is more sensible to attach the Retry component to a Run Orchestration component where that job contains its own transaction logic.

        Properties

        PropertySettingDescription
        NameTextA human-readable name for the component.
        Number of RetriesIntegerThe maximum number of attempts to retry the connected component. The total number of times the attached component could be run is one more than the number of retries—the original run is not a retry. If the final retry fails, the failure link is followed. The first time the component succeeds, the success link is followed.
        Retry DelayDropdownCertain kinds of transient failures may benefit from a delay before retrying. The Retry Delay setting provides strategies for retrying quickly or slowly, with the ability to leave longer and longer pauses between attempts (known as backoff).
        Custom: Specify a custom delay value of hours, minutes, or seconds.
        Long delay: Waits approximately 15 seconds between retries.
        Long delay with backoff: Waits longer between each failure, at approximately 15, 30, 60, 120, 240... seconds.
        Retry immediately: Will immediately retry up to the maximum number of retries. This is the default setting.
        Short delay: Waits approximately 2 seconds between retries.
        Short delay with backoff: Waits longer between each failure, at approximately 1, 2, 5, 10, 20, 40... seconds.
        Retry IntervalIntegerAn integer value of the unit specified below. The default value is 1.
        An error will occur if the value is below 0 or above 3600. An error will also occur if the value is not an integer.
        Only available when Retry Delay is set to Custom.
        Retry Time UnitDropdownSelect the time unit. Choose Hour, Minute, or Second. The default setting is Second.
        Only available when Retry Delay is set to Custom.

        Variable Exports

        This component makes the following values available to export into variables:

        SourceDescription
        Iterations AttemptedThe number of iterations that this component attempts. This is akin to its successes plus its failures.
        Iterations GeneratedThe number of iterations that have been initiated. Iterations are generated when the component runs and so this will always be the maximum requested iterations (number of allowed retries + 1)
        Iterations SuccessfulThe number of iterations successfully performed. This will either be 0 or 1 since the Retry component is escaped when an iteration succeeds.
        What's Next