Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

CDC is not working in scheduling time

Hi all,

 

I have created a CDC tables while it's working fine when ever i used run button in talend.

Same jobs after scheduled these build jobs using task scheduler for every hour am getting ZERO records from these CDC tables.

 

source                     destination 

mssql ----------------->HIVE

 

NOte: From client side the mssql database is dropping  and recreating every night 10 pm.IS this cause any issue am getting zero records in hive by CDC tables.

 

Can anyone help me for this issue to resolve..

Labels (3)
4 Replies
manodwhb
Champion II
Champion II

@saibabu ,what was the scheduled time? is it same time dropping and creating database ? if yes it could be problem.

Anonymous
Not applicable
Author

Scheduled time was started 17-04-2019 4.00.00 am and it will run every one hour as Repeat task and Duration : - INDEFINITELY
vapukov
Master II
Master II

Hi @saibabu ,

 

of course it could be a problem

 

Talend use trigger based CDC, so when you drop the database, it must drop triggers on tables

0683p000009M4kA.png

 

 

 

Anonymous
Not applicable
Author

But they are re-creating triggers every day @10 pm dropping & creating entire db again