hvrretryfailed
Usage
hvrretryfailed [-options]... hub chn loc
Description
Command hvrretryfailed retries integration of changes that are saved in fail tables or directory due to integration errors. It reattempts integration of changes which gave an error during integration into location loc.
For integration into a database, these changes are written to fail tables in the target database. For file integration, these are unsuccessful files which are moved into the file location's state directory. Integration jobs save changes in the fail tables or directory if parameter OnErrorSaveFailed is defined. The integration is retried immediately, instead of being delayed until the next integrate job runs.
Options
This section describes the options available for command hvrretryfailed.
| Parameter | Description |
|---|---|
| -d | Only delete rows, do not retry them. If the -w option is not supplied, then the fail table is also dropped. This is only allowed for database locations. |
| -ttbl | Only failed rows from table tbl. If this option is not supplied, rows from all fail tables will be processed.
|
| -v | Verbose output. |
| -wsqlrestr | Where clause. Only failed rows where sqlrestr is true will be processed. For example, to only retry recent changes for a certain column, the SQL restriction would be -w "hvr_cap_tstamp >= '25/5/2007' and col1=22". This is only allowed for database locations. |
Examples
Example 1. Delete rows for certain columns
The following command deletes only rows with the changes older than May 5, 2007, and where column col1 has value 22.
hvrretryfailed -d -w"hvr_cap_tstamp >= '25/5/2007' and col1=22" myhub mychn myloc
Example 2. Retry integration for certain tables
The following command retries integration only for table customer.
hvrretryfailed -tcustomer myhub mychn myloc