The following steps describe how to create an error profile that you can associate with a routing rule.
- In the Unity Setup portlet, click the Session Routing tab.
- Click the Error Profiles tab.
- Click .
- Next to Error Profiles, click .
- In Error Profile, enter a new name or leave the default name in the Error profile field. The Error Profile name is pre-filled with the name NewErrorProfile<number>. You can enter a new name.
- Next to Error Codes, click add error codes.
-
In Add Error Code, complete the following fields:
Fields 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 field is blank. User Comments [Optional] Additional information about the error code. -
Select an the action for Unity to perform if the specified errors occur.
- Retry Error Action
- 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.
- Resubmit
- Resubmit means trying the query on another system.
- Retry then Resubmit
- Combination of Retry Error Action and Resubmit.
- Exit
- This action terminates the session.
- Click Save.
- Verify the error code is added to the Error Profile list. You can now associate this error profile with a routing rule.
- Click Close.