Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
This article provides solutions to errors that occur when you preview the source query in Integration Manager for Microsoft Dynamics GP 10.0.
Applies to: Microsoft Dynamics GP
Original KB number: 954632
Symptoms
When you run an integration or preview a source query in Integration Manager for Microsoft Dynamics GP 10.0, you receive one of the following error messages:
ERROR: ADO Field is nothing.
The following problem occurred while attempting to open Query 'queryname': ADO Field is nothing.
Resolution
To resolve this problem, follow one of these resolutions:
Resolution 1
Obtain the latest service pack for Integration Manager for Microsoft Dynamics GP 10.0.
Resolution 2
Make sure that the column names in the source data contain no Microsoft Jet reserved words.
Resolution 3
Make sure that your column names in the source data contain no special characters. The column names must only consist of alpha-numeric characters.
Resolution 4
This error can occur if the data type of a column was changed that is used in the Query Relationship window. Open the properties for each source and then select the Refresh Columns button on the Columns tab. After you refresh the columns, verify the mapping of the integration and the Query Relationship window are still correct.
Disclaimer
Microsoft and/or its suppliers make no representations or warranties about the suitability, reliability or accuracy of the information contained in the documents and related graphics published on this website (the "materials") for any purpose. The materials may include technical inaccuracies or typographical errors and may be revised at any time without notice.
To the maximum extent permitted by applicable law, Microsoft and/or its suppliers disclaim and exclude all representations, warranties, and conditions whether express, implied or statutory, including but not limited to representations, warranties, or conditions of title, non infringement, satisfactory condition or quality, merchantability and fitness for a particular purpose, with respect to the materials.
Rapid Publishing Disclaimer
Rapid publishing articles provide information directly from within the Microsoft support organization. The information contained herein is created in response to emerging or unique topics, or is intended supplement other knowledge base information.