ERROR: Unable to open source queries because Query ‘XXX’ is not found in the database. – ADO Field is nothing
The ADO field is nothing error is caused when a user still has the data source file open. Whether it is a text file or csv in Excel you want to ensure that the data file is closed before running the integration as this will resolve this error.
Below articles for repairing integrations
Integration Manager is a great tool for getting information into Microsoft DYynamics GP, but it can also be infuriating at times with the error messages it produces when there are problems.
I recently received an error message when trying to integrate some debtors:
I then tried to do a preview of the file and received the same error:
Integration Manager - The following problem occurred while attempting to open Query 'Debtors': - ADO Field is nothingAfter investigating I identified the cause pf the problem and it was not one of the three ADO Field is nothing problems I have posted in the past (1, 2 and 3). Instead this time, the problem was that there was a column in the source which had no heading; I had missed this when configuring the Source initially, but one I entered a heading the integration ran without further problems.