This procedure assumes the capture job has stopped because of a capture problem on a specific table.
The recommended procedure for the first target location:
Open the Refresh dialog
Select source and a single target location
Select the table that need to be refreshed
The Online Refresh options need to be checked, and the option needs to be set to “Skip Previous Capture and Integrate”. This option is chosen because we are using it to step over the capture problem
Check the Schedule box and chose a sensible name for the Refresh Task
Click Schedule
Suspend capture and integrate jobs
Optionally - Go on to the HVR Scheduler, select the refresh job that has just been created and chose “New Attribute”. Create a retry_max attribute and set this to the desired value. 0 means no retry.
Right mouse click the refresh job and chose start to kick off the job
After the refresh has finished start the capture and integrate jobs again
For the second target location, the recommended procedure is:
Open the refresh dialog
Select source and the 2nd target location
Select the tables that need to be refreshed
The Online Refresh options need to be checked, and the option needs to be set to “Skip
Previous Integrate”. This is because we assume two or more integrate locations
Check the Schedule box and chose a sensible name for the Refresh Task
Click Schedule
Suspend integrate jobs, but capture jobs can be left running
Optionally - Go on to the HVR Scheduler, select the refresh job that has just been
created and chose “New Attribute”. Create a retry_max attribute and set this to the desired value. 0 means no retry
Right mouse click the refresh job and chose start to kick off the job