Does "advanced run option" for postgres as source and snowflake as target ?

[gkaur]

I am trying to fill-in a data gap using "advanced run option"  with selections as "Tables are already loaded. Start processing changes from" but getting following error -

"Failure in starting (with TXN consistency...)
Unsupported/illegal initial positioning token/method: 'timestamp:2024-02-15T05:00:00'

"

Truncating and reloading is not an option for me as table is huge, plus it is a live table. What are my options ?

[john_wang · Accepted solution]

Hello @gkaur ,

Thanks for reaching out to Qlik Community!

PostgreSQL source endpoint is some special, there is limitation:

• The “Start Process Changes from Timestamp” run option is not supported.

The reason is that Qlik Replicate get changes data from WAL via slot where the snapshot will be created while the slot is created. Seems you are trying to startup the capture from a time older than the slot creation.

If the slot was ever dropped and being re-created again, a full load is needed if task is set to Apply Changes. If task is set to Store Changes then you may try to startup the task CDC from current LSN, or a time newer than slot creation time.

Hope this helps.

John.