Trying to build a new CDC job. I have a schema in which I am trying to ingest two tables. One of the tables loads just fine. The other doesn't give us any specific errors, but it doesn't load either. We have been troubleshooting it for several days at this point and are unsure how to proceed.
What additional information can I share, or things can I try?
If we can get the Diagnostic package of the task then we can try to analyze and let you know the issue. You can also create a support ticket and provide us the logs so that we can work on to find the issue!!
Please set SOURCE_UNLOAD to Verbose, then recreate the issue. Afterward, review the task log files to identify the cause of the problem.
Additionally, From the Verbose task log files you can check how Qlik Replicate initializes the table by running the same query with the same account. This will help determine whether the query executes successfully in your environment.
Thanks,
John.
Help users find answers! Do not forget to mark a solution that worked for you! If already marked, give it a thumbs up!
When you mentioned, "One of the tables loads just fine. The other doesn't give us any specific errors, but it doesn't load either," do you mean that you're referring to a full load?
If the table is not loading, please consider disabling the CDC feature (apply changes/store changes) to run full load only. As John mentioned above, please set SOURCE_UNLOAD to VERBOSE to help identify the problem.
Regards, Desmond
Help users find answers! Do not forget to mark a solution that worked for you! If already marked, give it a thumbs up!
