Skip to main content

Hi all,

Our team is using CData Sync to extract and load data from SQL Server to Snowflake. The source MSSQL table is CDC-enabled, and we have created a CData Job with Change Data Capture enabled. We started testing the task with smaller tables (containing 100K - 300K records), and the task was successful without any issues. However, when trying with larger tables (containing 10M - 35M records), we faced failures every time.

I have attached the error output for your reference. Has anyone come across this scenario? Any replies or help would be much appreciated. Thanks in advance.

Error output: "2024-11-14T02:25:19.555+0000 2 [32|Q-Id] Failed to cache row [501097] The query was canceled."

We tried running the same task with a few manipulations, like reducing the source table records to 1M over 10M but had no luck. We are not facing any other issues besides "Failed to cache row." What does caching mean in a CData task? Does this have something to do with the AWS AMIs?

 

Thanks heaps,

S.

Hello!

I’m sorry to hear that you’re facing issues using CData Sync. Based off the error message you’re seeing, this sounds like something that we’ll need to review logging information in order to properly assess.

I’d recommend contacting our support team, and sharing the details of your issue with them there, as they’ll be better equipped to analyze that information and work towards a solution.

You can contact them via email using the following link: https://www.cdata.com/support/

CData's Winter 2025 Release
Terms and ConditionsCookie settings