topic Creating Metadata Manager's utility components failed in Qlik Replicate

Creating Metadata Manager's utility components failed

AXK0121B — Thu, 25 Apr 2024 06:45:43 GMT

I am Trying to do CDC Load with ODBC Connection, After selecting the tables when i am trying to run the job it gets failed with below error.

Creating Metadata Manager's utility components failed
Cannot create the source utility component
Failed while preparing stream component 'QAD_PERU'.
Context field(s) are not defined

Attaching the log screenshot.

Re: Creating Metadata Manager's utility components failed

DesmondWOO — Fri, 26 Apr 2024 04:26:04 GMT

Hi @AXK0121B ,

"Using ODBC with CDC as a source" should be enabled through Professional Services and approved by Account Manager. Please find this link: Using ODBC with CDC as a source for details.

Regards,
Desmond

Re: Creating Metadata Manager's utility components failed

RajyaLakshmi — Fri, 26 Apr 2024 07:26:59 GMT

Hi @AXK0121B ,

Thanks for contacting Qlik support.

You might get this error if the values in the context field are not filled out. The ODBC CDC endpoint is designed to work with a context field.

Before you can define the settings in the Change Processing tab, you need to ensure that at least one special "Context" column exists in your source database tables. Context column(s) are basically columns in a table that enable Replicate to determine whether the data has changed. You can add Context columns specifically for the purpose of change processing (either using a script or manually) or you can use existing columns that contain suitable "Context" data.

Please refer the below user guide for details:

https://help.qlik.com/en-US/replicate/November2023/Content/Replicate/Shared/prereq_source_change_processing.htm

However as mentioned by Desmond earlier, unless enabled through Professional Services and approved by your Account Manager, the ODBC with CDC source endpoint should not be used.

Best Regards,
Rajya Lakshmi