This section contains the procedure for configuring the retry options for the following inbound database activities: Get Inserted Rows activity, Get Updated Rows activity, Get Deleted Rows activity, and Poll Table activity.
Field | Description |
---|---|
Retry | |
1) Wait ___ second(s) between each retry. | Specifies the amount of time (in seconds) that the Integration Appliance waits before trying to establish a connection to the database. |
2) Try to connect ___ times before failing. | Specifies the retry count - the maximum number
of times the Integration Appliance attempts to establish a connection
to the database before issuing an error.
If an orchestration that starts with an inbound database activity is deployed and the Integration Appliance cannot connect to the specified database, the Integration Appliance logs the connections errors as Warnings in the system log until the retry count value is reached. When the retry count is reached, the Integration Appliance logs an Error in the system log, resets the connection error count to zero, and continues to attempt to establish a connection to the database. For example: the retry count is set to 3. The first, second, and third connection errors are shown in the system log as Warnings. The Integration Appliance logs the fourth connection error as an Error and resets the connection error count to zero. Therefore, the fifth connection error generates a Warning in the system log. The Integration Appliance continues to attempt to establish a connection to the database. |
Activity Timeout | |
3) Time out after ___ seconds when the Endpoint does not respond to a request. | Specifies the amount of time in seconds before a timeout occurs between the activity making a request on an Endpoint and the time it takes the Endpoint to respond. For example, the amount of time the Integration Appliance waits for a response from the database after requesting that database polls for an INSERT trigger event, before the Integration Appliance issues a timeout error. An activity timeout is different from a connection timeout because an activity timeout occurs after the connection to the Endpoint has been established. A connection timeout specifies the amount of time in seconds before a timeout occurs between the Integration Appliance attempting to establish a connection to the Endpoint and the time it takes for the Endpoint to respond to the connection request. Set the connection timeout in Database Endpoint tab. For more information about connection timeouts, see Creating or Editing a Database Activity Endpoint. |