Quickbooks to Sql Server Replication Error

Is this a local Quickbooks database/file, or is it Quickbooks Online?

The fact that it ran for 22 minutes before failing would seem to suggest that it was partially complete before failing.  Do any rows at all get loaded?

If it’s Quickbooks Online, does QB give you any control over (or describe) the timeout period on their end?

Hi DougN, thank you for the quick response. It is the QuickBooks desktop. The QB, SQL Server, and CData Sync are all on the same virtual machine. The table is empty after the error. I am rerunning it once again with verbose messaging to see if I can provide a better idea of what is going on.

Will it load any other tables from the QB file successfully?

Be sure nobody has the file open in QB…

Yes, one of the tables was successfully loaded. The Accounts table with 479 rows was loaded, then the next 3 with 80k to 200k rows failed with the same iteratorID error for each table.

As you can see replication attempt managed to create the tables in SQL Server, but other than Accounts, the others are empty.

The file is not opened by anyone else.

I made one more change when I turned on verbose. It allowed me to turn on parallel processing with 2 worker pool. So far it has not errored out. Still going… I hope I haven’t jinxed myself. I’ll update with results: 

Hmm it shows as 0 rows affected. We shall see: 

😔

Hi Ankit, I did reduce the page size, that was the first troubleshooting step I took. It is in my first post above. Should I reduce it lower than 50?

I have submitted a support ticket and am waiting for support to respond. Thanks.