Qlik replicate not applying the changes in realtime

[swaroopchippada]

Hi,

We are using qlik replicate with

Source - Sybase

Target - Kafka

and we have selected the below settings while creating the task,

Replication profile: unidirectional

Task options - Full load, Apply changes

After starting the task,  Full load is successful. But after that, any new transaction in the DB is not replicated. 

if I stop and restart the task by selecting reload target, all the new data is replicated.

Kindly help to resolve this.

Also, one more thing to note, I haven't faced this issue in local. only facing this in our dev environment. 

[john_wang · Accepted solution]

Hello @swaroopchippada ,

Thanks for the feedback.

The header column AR_H_USER works for SAP Sybase ASE for sure, however please take note the Replicate AR_H_USER header column is not supported for database changes performed in auto-commit mode. You need to use the explicit transactions.

I've confirmed that in my labs (Replicate 2023.11 + Sybase ASE 16.0):

1. Turn off auto-commit in "Interactive SQL"

    

2. Make changes by explicit transactions in "Interactive SQL"

    

    The sample code as below:

begin transaction
insert into moon.dbo.testtime values (16,'abc','23:59:59','23:59:59')
commit

3. Got the transaction owner, "sa" in target DB:

    

    Comparision to the previous line, id=12, which was made by auto-commit, the AR_H_USER is null value. It should work for Kafka target as well.

Hope this helps.

John.

[swaroopchippada]

@John Thank you so much. its working now

[john_wang]

Glad to hear that, @swaroopchippada , thank you so much for your great support!