have you tried resetting the rowset after the first iteration - my guess its pointing to the end after the first iteration. So perhaps try closing the rowsetitertor first
Thanks, but it didn't work. Would expect it not to, as for the new row set we are performing executeQuery() which would put the iterator back before the first record. Also, in any case it's a secondary iterator, and so even if it is pointing to the same Query Collection, it should not be affected by the processing on the default iterator.
The following line (#19) has been returning 0 records with/without the change: iter.getEstimatedRangePageCount()