This video demonstrates how to Restart a Qlik Replicate task from the Log Sequence Number or LSN for a Postgres source.
Environment
Two methods for finding the LSN:
- Querry
- Search the Replicate Task Log File
The task logs can be found here:
Program Files > Attunity > Replicate > Data > Logs
Find the LSN in the Log File:
- Search the task log for "Final saved task state"
- After the text "Stream Position" is the LSN value
- Copy the LSN value from the log file
Start the Qlik Replicate task using LSN:
- In the drop down menu at the Run button > select Advanced Run Options
-
*Unfortunately, for a postgres source, restart from a date and time is not supported.
- Paste the LSN value in the Source Change Position field
- Click OK
This will trigger the task to run and should replicate any changes since the task was stopped.
Restarting the task using LSN for the postgres source can be a useful method if there are issues or limitations using the Resume processing option.
Using the Advanced Run Options will allow you to go back in time and reprocess records from the past without running a full load.
Related Content
Qlik Help Documentation: Advanced Run Options