Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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:
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
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
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:
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