Error recovery can be configured for errors encountered during a changed data transformation. During a changed data transformation, there is constant communication between different Data Exchange components. For example, the Agent continuously monitors the audit trail to capture any new change in the transformation source. Similarly, the Runtime Service updates the target database as soon as a data record is successfully processed. The changed data transformation stops if this communication fails.
You can configure the components to make a specified number of attempts at a specified interval to recover from the error.
By default, the Data Exchange environment tries to recover every 30 seconds. For known errors the total number of recovery attempts is three. For unknown errors, no recovery is attempted.
Notes:
Changes in the recovery settings take effect immediately. Restarting the Administrative Service, the Runtime Service, or the Agent is not required.
Similar kinds of errors within a period of 30 minutes are considered as errors within the same failure session. So, the recovery counter continues from the previous successful recovery attempt. For example, if the recovery value for "On Transformation Target Connection Failure" is set to 10 and it successfully recovers on attempt 6 but faces the same problem within a short while, the recovery starts from attempt 7 and not attempt 1.
The connection failure errors always result in stopping or starting a transformation and hence are logged in the Windows Events.
To configure recovery settings
Click Manage.
Under Source Database Hosts, select the source database.
In the Transformations Source pane, click the Settings tab, and then click Recovery.
The Recovery page displays the default values for the recovery setting fields.
To edit the recovery settings, click Edit at the bottom right of the Data Source pane.
In the Edit Recovery Settings dialog box, configure the values relating to the recovery settings.
On Agent Connection Failure: The Administrative Service is unable to establish a connection with the Agent.
On Agent Process Failure: The Agent is either unable to send messages or is stopped. You can see the specific error on Events.
On Runtime Service Connection Failure: The Administrative Service is unable to establish a connection with the Runtime Service.
On Runtime Service Process Failure: The Runtime Service is either unable to read messages or is stopped.
On Transformation Target Connection Failure: The Runtime Service is unable to establish a connection with the target database.
On Tracking Database Connection Failure: The Runtime Service is unable to establish a connection with the tracking database (UnisysDExchTrackingDB).
On Read Audit Failure: The Agent is unable to read the audit file.
On Other Failure: A changed data transformation is stopped upon detection of fatal failures, such as Unknown Error, Agent Application Error, or Audit Error.
Retry Interval (20–3600s): The frequency at which the retry attempt happens.
Send Email Alert: You will receive an email alert if there are errors during a changed data transformation. Select Yes to receive the alert.
Emails to Alert: Enter the email ID to which you want to send the failure alerts. If you want to send an alert to multiple email IDs, enter the email IDs each separated by a comma.
Note: You must configure simple mail transfer protocol (SMTP) server settings in order to receive failure alerts to the configured email IDs.
To configure the SMTP server settings, click Edit SMTP Server.
In the Edit SMTP Server Settings dialog box
Enter the following SMTP server details:
SMTP Host: Host name or IP address of the SMTP server
SMTP Port: Port number that the SMTP server uses
Sender Email Address: Email ID of the person from whom an alert notification is to be sent. For example, Data Exchangeadministrator@unisys.com.
Sender Alias: Alias name to identify the sender. The alias name is suffixed with the sender’s email ID. For example, if the sender’s email ID is DataExchangeadministrator@unisys.com and the sender’s alias name is Ashton, then the recipient receives a recovery alert from Ashton<DataExchangeadministrator@unisys.com>.
Sender Email Password: Password corresponding to the sender’s email ID.
Select Test SMTP Settings to test the SMTP server.
Upon successful testing, a confirmation email is sent to the configured email IDs.
Select Save to save the SMTP server settings.
Notes:
The Edit SMTP Server Settings dialog box appears only if you have specified “Yes” in the Send E-mail Alert box.
Although the SMTP settings are configured correctly, at times an email alert is not sent if your company firewall or network policy blocks the SMTP server requests.
If you are using SSL to access the SMTP server, you must update the configuration files “Web.config” in DataExchange\Runtime Administration\Administration Site and “Data Exchange Admin Service.exe.config” in DataExchange\Runtime Administration\Administrative Service. In these files, add <mailsettings> node to the <configuration> node as follows:
<configuration>
<other configs/>
<system.net>
<mailSettings>
<smtp deliveryMethod="Network">
<network enableSsl="true"/>
</smtp>
</mailSettings>
</system.net>
</configuration> The default port number of SMTP server using SSL connection is 143.
Select Save to save the failure recovery settings.
Select Reset to Default to retain the default recovery settings.