topic Re: ODBC CDC Qlik replicate task is falling in Qlik Replicate

ODBC CDC Qlik replicate task is falling

NXP0701B — Tue, 10 Sep 2024 10:59:07 GMT

Qlik replicate task is failing due to ' Failed to get 'GenericWithoutSchema' syntax' reason.I have attached the failure log and diagnostics package.

Re: ODBC CDC Qlik replicate task is falling

sureshkumar — Tue, 10 Sep 2024 11:11:52 GMT

Hello @NXP0701B

The Task is not failing, just its mentioning that it dint find the right syntax so its using the default.

2024-09-10T06:36:11 [METADATA_MANAGE ]I: Failed to get 'GenericWithoutSchema' syntax, working with the default (odbc_endpoint_imp.c:5061)
00000920: 2024-09-10T06:36:11 [METADATA_MANAGE ]I: Source endpoint 'OdbcWithCdc' is using provider syntax '<default>' (provider_syntax_manager.c:888)

You can try adding internal parameter called "syntax" and give the current value at the source endpoint.

Regards,

Suresh

Re: ODBC CDC Qlik replicate task is falling

kng — Tue, 10 Sep 2024 11:18:07 GMT

Hello Team,
Good Day

Thanks for reaching Qlik Community portal!!

Please can you try adding the below internal parameter and check if that helps:

afterConnectScript

with a value of:

ALTER SESSION SET CLIENT_METADATA_REQUEST_USE_CONNECTION_CTX=TRUE

FYI: We always suggest not to upload Diagnostic package & logs to the public portal as logs may contain sensitive info!!

Regards,
shivananda

Re: ODBC CDC Qlik replicate task is falling

NXP0701B — Tue, 10 Sep 2024 12:31:35 GMT

Issue not resolved after applying afterConnectScript internal parameter

Re: ODBC CDC Qlik replicate task is falling

NXP0701B — Tue, 10 Sep 2024 12:37:12 GMT

Issue not resolved after applying "syntax" internal parameter

Re: ODBC CDC Qlik replicate task is falling

john_wang — Wed, 11 Sep 2024 13:29:43 GMT

Hello @NXP0701B ,

Welcome to Qlik Community forum and thanks for reaching out here!

Looks to me there are many issues in this task including:

1. Qlik Replicate 2022.5 is out of support, please upgrade to supported versions. The recommended version is 2023.11.

2. The task is running an uncertified MySQL ODBC Driver version '05.01.0013'. The certified MySQL ODBC Driver version can be found in the User Guide (for example Replicate 2023.11 requires MySQL ODBC Driver 8.0.32).

3. The task is Using ODBC with CDC as a source , the pre-defined MySQL ODBC CDC Source endpoint should be used instead of ODBC DSN. If you need use ODBC, PS should be engaged.

4. The above line information of using provider syntax '<default>' is expected behavior. It's OK.

5. However this task in unhealthy status, it crashed:

In summary, the entire task should be re-designed with appropriate endpoints. At least, the task should not crashed.

If you need any additional assistance, please open support ticket in Salesforce Support Portal and attach necessary information and Diagnostics Packages. Our support team will be more than happy to assist you.

Hope this helps.

John.