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

Need more help?

Expand your skills
Explore Training
Get new features first
Join Microsoft Insiders

Was this information helpful?

Thank you for your feedback!

Thank you for your feedback! It sounds like it might be helpful to connect you to one of our Office support agents.

×