topic Re: Failed to prepare sqlite statements for CAPTURE MODE & Failed to init cdc table table 1 in Qlik Replicate

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

AXK0121B — Thu, 25 Apr 2024 11:17:21 GMT

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

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

john_wang — Thu, 25 Apr 2024 12:45:46 GMT

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.

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

Heinvandenheuvel — Thu, 25 Apr 2024 16:45:29 GMT

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.

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

SushilKumar — Wed, 01 May 2024 07:38:35 GMT

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/1815056

Regards,

Sushil Kumar