Iterator ID is not valid

  • 13 December 2023
  • 0 replies
  • 15 views

Userlevel 1
Badge

The ‘Iterator ID is not valid’ error occurs when Quickbooks takes too long to fetch a single page of data. When this happens, the iterator id can be invalidated before the complete data is returned. 

You can solve this in two ways: 

  1. Decrease the PageSize connection property in your QuickBooks connection 

  1. Increase the idle timeout and enable persistent connections in your QuickBooks Desktop Gateway (previously known as the Remote Connector). You can find documentation for this here https://cdn.cdata.com/help/RQJ/odbc/pg_rcadvanced.htm 


This topic has been closed for comments