Adding an Error Profile - Teradata Unity

Teradata Unity User Guide

Product
Teradata Unity
Release Number
16.10
Published
January 2018
Language
English (United States)
Last Update
2018-03-29
dita:mapPath
anz1496162519675.ditamap
dita:ditavalPath
ft:empty
dita:id
B035-2520
lifecycle
previous
Product Category
Analytical Ecosystem
The following steps describe how to create an error profile that you can associate with a routing rule.
  1. In the Unity Setup portlet, click the Session Routing tab.
  2. Click the Error Profiles tab.
  3. Click .
  4. Next to Error Profiles, click .
  5. In Error Profile, enter a new name or leave the default name in the box.
  6. Next to Error Codes, click add error codes.
  7. In Add Error Code, complete the following:
    Option Description
    Error Code Error identification code number.
    Description Description displays if the error code matches a Teradata error code.

    If there is no match, this box is blank.

    User Comments [Optional] Additional information about the error code.
  8. Select an the action for Unity to perform if the specified errors occur:
    Action Description
    Retry (same system) For both managed and passive session routing, the Retry Error Action retries the request on the same system where it was originally executed. The query is retried up to three times by default.

    For managed sessions (sessions associated with a managed routing rule), only Read requests are retried, and only if it is an implicit transaction, or if the Read request is the very first request in an explicit transaction. For passive sessions, all Read/Write requests are retried (if the error code or action matches), and the type of transaction (implicit or explicit) does not affect the decision.

    Resubmit (other system) Resubmit means trying the query on another system.

    For managed sessions: if an error code indicates resubmit, the query is submitted to another system per the Read routing rule associated with the routing rule. For passive sessions, a resubmit closes the session on the current system, opens the session on the new system (chosen per routing rule), and then the query is attempted on the new system.

    Retry then Resubmit Combination of Retry Error Action and Resubmit.
    Exit Terminates the session.
  9. Click Save.
  10. Verify the error code is added to the Error Profile list. You can now associate this error profile with a routing rule.
  11. Click Close.