Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Recent Documents
-
Qlik Fix: How to Restart a Qlik Replicate Task from LSN for a PostgreSQL Source
This video is part of the Qlik Fix Video series. If you found this video useful, check out the other Qlik Fix Videos. Environment Qlik Replicate T... Show MoreThis video is part of the Qlik Fix Video series. If you found this video useful, check out the other Qlik Fix Videos.
Environment
- Qlik Replicate
This video demonstrates how to Restart a Qlik Replicate task from the Log Sequence Number or LSN for a Postgres source.
Attached is a downloadable .mp4 video file for those who cannot view YouTube videos.
Transcript
Hi and Welcome to Qlik Fix
This video will demonstrate how to Restart a Replicate task from the Log Sequence Number or LSN for a Postgres source.
Here we have sample task with one table which has Full load and Change Data Capture enabled.
We have a postgres source and a file target.
We’re replicating once table called C-sub test.
The task is currently stopped and has already gone through a full load.Here’s how the table looks via PGadmin on the source side.
The UserID field currently runs up to 1433.
These inserts here will bump those values up once run
However those changes are not replicating to our target file because the task is not running.
Now to demonstrate how to restart the task using LSN for the postgres source.
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.
Under advanced options, we want the second choice.
Unfortunately, for a postgres source, restart from a date and time is not supported.
So, we will specify the LSN start position in the source database log
where you would like to resume change processing.
There are two ways to find this position value
Query
From Replicate log
Under Advanced Run Option in the Qlik Help documentation, there are some example queries to run to get the current LSN value in the source Database.
The second option is to get that value from the Replicate log file.
The logs can be found here under Program Files > Attunity > Replicate > Data > Logs
Ours is the most recent.
In the log file for the task, search for “Final saved task state"
After the words Stream Position is the LSN value that we’re looking for. Starting the replicate task from this position will pick up the changes that have occurred since the task was stopped.
Copy that.
Paste that value from the log in the Source Change position, then click okay
That task starts running again and it picked up those 2 inserts that were made after the task was stopped.
Those changes can even be confirmed in new change data capture log
Additionally, the task log confirms that the change data capture was initiated at the specified position, without performing a full load.
If you'd like more information
Take advantage of the expertise of peers, product experts, Community MVPs and technical support engineers
by asking a question in a Qlik Product Forum.
Hiding in plain sight is the Search tool.
This engine allows you to search Qlik Knowledge Base Articles,
Qlik Community forums,
Help dot Qlik dot com, Qlik Gallery,
multiple Qlik YouTube channels and more, all from one place.
There’s also the Support space.
We recommend you subscribe to the Support Updates Blog,
And learn from Qlik experts via a webinar, like Techspert Talks or Q&A with Qlik.
Thanks for watching.Nailed it!
-
Qlik Fix: How to Fix Connection Lost Error
This video is part of the Qlik Fix Video series. If you found this video useful, check out the other Qlik Fix Videos. This video explain how to con... Show MoreThis video is part of the Qlik Fix Video series. If you found this video useful, check out the other Qlik Fix Videos.
This video explain how to configure a Web Socket Ping Interval setting on Qlik Sense to help resolve Connection Lost errors in the hub or script editor.
Here is a link to more information in the Support Knowledge Base:
https://qliksupport.force.com/articles/000055708Attached is a downloadable .mp4 video file for those who cannot view YouTube videos.
-
Qlik Fix: How to Collect Windows Event Logs
This video is part of the Qlik Fix Video series. If you found this video useful, check out the other Qlik Fix Videos. This video will demonstrate how... Show MoreThis video is part of the Qlik Fix Video series. If you found this video useful, check out the other Qlik Fix Videos.
This video will demonstrate how to manually collect Windows Event log files. You will need to be on the Windows
machine where the issue took place, and know the time frame of the incident being investigated.Here is a link to more information in the Support Knowledge Base:
https://support.qlik.com/articles/000007495
Attached is a downloadable .mp4 video file for those who cannot view YouTube videos.
#QlikSupport
-
Qlik Fix: How to reset postgreSQL password in Qlik Sense
This video is part of the Qlik Fix Video series. If you found this video useful, check out the other Qlik Fix Videos. This video demonstrates the ste... Show MoreThis video is part of the Qlik Fix Video series. If you found this video useful, check out the other Qlik Fix Videos.
This video demonstrates the steps needed to reset a forgotten password for the PostgreSQL database in Qlik Sense.
During the installation of Qlik Sense, it’s necessary to provide a password for the PostgreSQL database. Should this password become lost or forgotten, unfortunately there is no way to retrieve it.
It is possible to reset the password by following these steps.
Here is a link to more information in the Support Knowledge Base:https://support.qlik.com/articles/000005425
Here is where you can find more about downloading and using PGAdmin 4:
https://support.qlik.com/articles/000042413
Attached is a downloadable .mp4 video file for those who cannot view YouTube videos.
#QlikSupport
-
Qlik Fix: How to Load a File from Cloud-Hosted Services Like Box.com
This video is part of the Qlik Fix Video series. If you found this video useful, check out the other Qlik Fix Videos. This video shows how to load da... Show MoreThis video is part of the Qlik Fix Video series. If you found this video useful, check out the other Qlik Fix Videos.
This video shows how to load data files hosted in an online file storage service into QlikView and Qlik Sense using Qlik Web Connectors.
In the video, an Excel file hosted in Box.net is loaded into QlikView.
The process is similar for other storage services supported by Qlik Web Connectors and Qlik Sense:
Like DropBox, Google Drive or OneDrive are some other examples.Here is a link to more information in the Support Knowledge Base:
https://support.qlik.com/articles/000071088For more information about the CanAuthenticate query:
https://qliksupport.force.com/apex/QS_CoveoSearch#q=canauthenticate%20web%20connector&t=All&sort=relevancyAttached is a downloadable .mp4 video file for those who cannot view YouTube videos.
#QlikSupport
-
Qlik Fix: How to Transfer a QlikView Desktop License
This video is part of the Qlik Fix Video series. If you found this video useful, check out the other Qlik Fix Videos. This video demonstrates how t... Show MoreThis video is part of the Qlik Fix Video series. If you found this video useful, check out the other Qlik Fix Videos.
This video demonstrates how to transfer a QlikView Desktop license from one installation to another.
Here is a link to more information in the Support Knowledge Base:
https://support.qlik.com/articles/000026418
Attached is a downloadable .mp4 video file for those who cannot view YouTube videos.
#QlikSupport
-
Qlik Fix: Using Qlik APIs with PowerShell
This video is part of the Qlik Fix Video series. If you found this video useful, check out the other Qlik Fix Videos. This video explains how to call... Show MoreThis video is part of the Qlik Fix Video series. If you found this video useful, check out the other Qlik Fix Videos.
This video explains how to call the Qlik Sense Repository API using PowerShell.
Here is a link to more information in the Support Knowledge Base:
https://support.qlik.com/articles/000067703
Attached is a downloadable .mp4 video file for those who cannot view YouTube videos.
#QlikSupport
-
Qlik Fix: How to Recover Missing Document CALs
This video demonstrates how to recover missing Document CALs on QlikView Server/Publisher. For more information, please visit:https://support-cdn.q... Show MoreThis video demonstrates how to recover missing Document CALs on QlikView Server/Publisher.
For more information, please visit:
https://support-cdn.qlik.com/articles/000003271If you're unable to watch the video above, the MP4 file is attached and can be downloaded.
