Failed to prepare sqlite statements for CAPTURE MODE & Failed to init cdc table table 1

[AXK0121B]

when we are trying for CDC Load for ODBC connection the job is getting failed with below errors.

Error 1: 

Stream component 'st_0_QAD_PERU' terminated
Cannot initialize subtask
Failed while preparing stream component 'st_0_QAD_PERU'.
Failed to prepare sqlite statements for CAPTURE MODE
Failed to prepare statement - select confirmed_ctx from confirmations where table_id=? -  
SQLite general error. Code <1>, Message <no such table: confirmations>.

Error 2 :

Stream component 'st_0_QAD_PERU' terminated
Stream component failed at subtask 0, component st_0_QAD_PERU
Error executing command
Failed to init cdc table table 1
Unable to get column_def for context Field 0 of table 1

Attaching the logs for both Error

[john_wang]

Hello @AXK0121B ,

Thanks for opening the article.

It seems you are blocked by the 3rd party ODBC provider programs, not sure if you trying to use ODBC Test Tools to verify the DSN works or not.I'd like to suggest PS engaged to move the PoC project forwards smoothly.

Regards,

John.

[Heinvandenheuvel]

First of, THANK you for providing clear errors in TEXT style error logs, not just screenshots.

Secondly... did it ever work? And if so, hat might have changed - like Username, dev to Prod, Tuesday vs Monday, whatever!

[DATA_STRUCTURE  ]E:  SQLite general error. Code <1>, Message <no such table: confirmations>. [1000504]  (at_sqlite.c:326)

This 'feels' like a Replicate internal error, as it comes from [DATA_STRUCTURE] not [SOURCE_CAPTURE] or [SOURCE_UNLOAD]

But I am not aware of a replicate internal table (in RepoGlobal.repo or similar) with the name 'confirmations'. Is that your source table name perhaps? Did it used to be there while designing the taks but was it since dropped/renamed or did it become otherwise inaccessible due to protections perhaps?

Regards,
Hein.

[SushilKumar]

Hello @AXK0121B 

Thanks for reaching out to Qlik via Qlik Community Support page. Such issue requires through analysis of Task Settings, hence request you to reach out to technical Support via a case and provide Diagnostics package.

Please refer to Replicate https://community.qlik.com/t5/Knowledge/How-to-collect-Diagnostics-Package-from-Qlik-Replicate/ta-p/...

Regards,

Sushil Kumar