# Quickbooks to Sql Server Replication Error **URL:** \ **Category:** CData Sync\ **Tags:** question\ **Created:** [May 24, 2024, 6:40pm UTC](https://community.cdata.com/t/quickbooks-to-sql-server-replication-error/725 "2024-05-24T18:40:37Z")\ **Posts on this page:** 11\ **Page:** 1
**Author:** ![SalD](https://avatars.discourse-cdn.com/v4/letter/s/c5a1d2/32.png) [@SalD](https://community.cdata.com/u/SalD)\ **Post date:** [May 24, 2024, 6:40pm UTC](https://community.cdata.com/t/quickbooks-to-sql-server-replication-error/725/1 "2024-05-24T18:40:37Z")
Hi all, I am receiving an error when I am trying to replicate a table from QuickBooks to a local SQL Server. “[0] Failed to cache row [126934] The iteratorID “{4853b873-e75a-4f1a-a4d6-2c32253237ad}” is not valid.” See the screenshot below. To try and address this I have: 1. Decreased the Pagesize property in my Quickbooks connection to 50 from 500. 2. Enabled Persistent connections and increased the idle timeout in my Quickbooks Remote Connector from 30 to 120. I restarted the services but none of that worked. Any suggestions? ![39ea57f1-1f11-43d2-a468-bec8865a1fe4.jpg](https://us1.discourse-cdn.com/cdata/original/1X/953fc50f8636d0391216b2ede254f76c3c08bcec.jpeg) ---
**Author:** ![DougN\_Nouria](https://avatars.discourse-cdn.com/v4/letter/d/e0b2c6/32.png) [@DougN\_Nouria](https://community.cdata.com/u/DougN_Nouria)\ **Post date:** [May 24, 2024, 7:16pm UTC](https://community.cdata.com/t/quickbooks-to-sql-server-replication-error/725/2 "2024-05-24T19:16:18Z")
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? ---
**Author:** ![SalD](https://avatars.discourse-cdn.com/v4/letter/s/c5a1d2/32.png) [@SalD](https://community.cdata.com/u/SalD)\ **Post date:** [May 24, 2024, 7:20pm UTC](https://community.cdata.com/t/quickbooks-to-sql-server-replication-error/725/3 "2024-05-24T19:20:52Z")
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. ---
**Author:** ![DougN\_Nouria](https://avatars.discourse-cdn.com/v4/letter/d/e0b2c6/32.png) [@DougN\_Nouria](https://community.cdata.com/u/DougN_Nouria)\ **Post date:** [May 24, 2024, 7:24pm UTC](https://community.cdata.com/t/quickbooks-to-sql-server-replication-error/725/4 "2024-05-24T19:24:10Z")
Will it load any other tables from the QB file successfully? Be sure nobody has the file open in QB… ---
**Author:** ![SalD](https://avatars.discourse-cdn.com/v4/letter/s/c5a1d2/32.png) [@SalD](https://community.cdata.com/u/SalD)\ **Post date:** [May 24, 2024, 7:29pm UTC](https://community.cdata.com/t/quickbooks-to-sql-server-replication-error/725/5 "2024-05-24T19:29:44Z")
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. ![3b5fffa8-fee3-4ff8-92f4-0f49ac18f8ac.png](https://us1.discourse-cdn.com/cdata/original/2X/1/15a891d0c55a4d036dd9f5253b8d6b33a461d137.png) ---
**Author:** ![SalD](https://avatars.discourse-cdn.com/v4/letter/s/c5a1d2/32.png) [@SalD](https://community.cdata.com/u/SalD)\ **Post date:** [May 24, 2024, 7:30pm UTC](https://community.cdata.com/t/quickbooks-to-sql-server-replication-error/725/6 "2024-05-24T19:30:31Z")
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. ---
**Author:** ![SalD](https://avatars.discourse-cdn.com/v4/letter/s/c5a1d2/32.png) [@SalD](https://community.cdata.com/u/SalD)\ **Post date:** [May 24, 2024, 7:51pm UTC](https://community.cdata.com/t/quickbooks-to-sql-server-replication-error/725/7 "2024-05-24T19:51:38Z")
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: ![ac5bf7f1-d7a2-48d8-8849-fabb270cb618.png](https://us1.discourse-cdn.com/cdata/original/1X/6780f6183dc653548f5abe56fe4627da4de65bbd.png) ---
**Author:** ![SalD](https://avatars.discourse-cdn.com/v4/letter/s/c5a1d2/32.png) [@SalD](https://community.cdata.com/u/SalD)\ **Post date:** [May 24, 2024, 7:52pm UTC](https://community.cdata.com/t/quickbooks-to-sql-server-replication-error/725/8 "2024-05-24T19:52:41Z")
Hmm it shows as 0 rows affected. We shall see: ![9e158537-8a38-4f3a-9f44-7ec5088d689a.png](https://us1.discourse-cdn.com/cdata/original/2X/0/018d251f79d8a4fbdfb0aff897d52a62ad852c58.png) ---
**Author:** ![SalD](https://avatars.discourse-cdn.com/v4/letter/s/c5a1d2/32.png) [@SalD](https://community.cdata.com/u/SalD)\ **Post date:** [May 24, 2024, 8:12pm UTC](https://community.cdata.com/t/quickbooks-to-sql-server-replication-error/725/9 "2024-05-24T20:12:20Z")
😔 ![74671418-f390-4e10-ac9c-1b9662ab6f60.png](https://us1.discourse-cdn.com/cdata/original/2X/8/801dd3efdc686837655fa9a6bacd887e4a6ef7db.png) ---
**Author:** ![Ankit\_Singh](https://sea3.discourse-cdn.com/cdata/user_avatar/community.cdata.com/ankit_singh/32/1614_2.png) [@Ankit\_Singh](https://community.cdata.com/u/Ankit_Singh)\ **Post date:** [May 27, 2024, 8:22am UTC](https://community.cdata.com/t/quickbooks-to-sql-server-replication-error/725/10 "2024-05-27T08:22:02Z")
Hey @SalD This will require some investigation. Why don’t you raise a Tech Support Case with our support team along with verbose logs and screenshots at [CData - Support Form](https://www.cdata.com/support/submit.aspx)? From the prima facie, maybe reducing the Page Size on your QuickBooks connection will help. ---
**Author:** ![SalD](https://avatars.discourse-cdn.com/v4/letter/s/c5a1d2/32.png) [@SalD](https://community.cdata.com/u/SalD)\ **Post date:** [May 27, 2024, 11:13pm UTC](https://community.cdata.com/t/quickbooks-to-sql-server-replication-error/725/11 "2024-05-27T23:13:31Z")
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.