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