ODBC CDC Qlik replicate task is falling

[NXP0701B]

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

[sureshkumar]

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

[kng]

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

[NXP0701B]

Issue not resolved after applying afterConnectScript internal parameter

[NXP0701B]

Issue not resolved after applying "syntax" internal parameter

[john_wang]

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.