Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

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.

↑ Back to the top


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.

↑ Back to the top


Resolution

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

↑ Back to the top


Keywords: kbnosurvey, kbtshoot, kbexpertiseadvanced, kbexpertiseinter, kbexpertisebeginner, kbmbspartner, kberrmsg, kbmbsmigrate, kbprb, kb

↑ Back to the top

Article Info
Article ID : 921345
Revision : 1
Created on : 3/3/2017
Published on : 11/2/2013
Exists online : False
Views : 108