During a recent implementation I was using Integration Manager to load data into GP and on one occasion I got the following message in the progress window;
I fiddled around with a few things, closing GP and reporting, closing Integration Manager and reopening it and at one point I got this error message;
It was then that I realised that the file being used for the import was still open in Excel. Closing this file released the lock and allowed the import to run successfully.
It would have been nice if the error message was more explanatory that it was. But I just need to remember that ADO Field is nothing means a locked file.
About Ian Grieve
Ian is a Microsoft Dynamics GP certified consultant specialising in the delivery of Microsoft Dynamics GP projects and currently working for
Perfect Image Ltd., a Microsoft Partner and VAR in the North East of England.
Ian has worked with Microsoft Dynamics GP since 2003 and, over the nine years since, has dealt with all aspects of the product life-cycle from presales, to implementation, to technical and functional training, to post go-live support and subsequent upgrades and process reviews.
In his spare time, Ian runs the azurecurve | Ramblings of a Dynamics GP Consultant blog dedicated to Microsoft Dynamics GP and related products.
Pingback: Interesting Findings & Knowledge Sharing » Integration Manager Error – ADO Field Is Nothing | azurecurve