Error message when you run a "SQL Opt Inventory Transaction" integration in Integration Manager: "DOC1 Error: Either BOF or EOF is true or the current record has been deleted. Requested operation requires the current record"


Symptoms


When you run a SQL Opt Inventory Transaction integration in Integration Manager in Microsoft Dynamics GP 9.0, you receive the following error message:
DOC1 Error: Either BOF or EOF is true or the current record has been deleted. Requested operation requires the current record.

Cause


This problem occurs because the following line appears in the IM.ini file.
UseOptimizedFiltering=True
Note The IM.ini file is installed together with Integration Manager. The file is installed in the Integration Manager Code folder.

Resolution


To resolve this problem, modify the line in the IM.ini file as follows.
UseOptimizedFiltering=False