October 27, 2017
ArcherPoint Dynamics NAV Developer Digest - vol 163
The NAV community, including the ArcherPoint technical staff, is made up of developers, project managers, and consultants who are constantly communicating, with the common goal of sharing helpful information with one another to help customers be more successful. As they run into issues and questions, find the answers, and make new discoveries, they post them on blogs, forums, social media...so everyone can benefit. We in Marketing watch these interactions and never cease to be amazed by the creativity, dedication, and brainpower we’re so fortunate to have in this community—so we thought, wouldn’t it be great to share this great information with everyone who might not have the time to check out the multitude of resources out there? So, the ArcherPoint Microsoft Dynamics NAV Developer Digest was born. Each week, we present a collection of thoughts and findings from NAV experts and devotees around the world. We hope these insights will benefit you, too.
Using NAS to Upload Data Sync Files on Dynamics NAV Version 5Tom H: I've been working with a customer running NAV 5, and they use the NAS to upload data sync files to their web site. They're having a problem with WinSCP not uploading the files correctly. If you run the job manually, everything works fine, but if you run the job via the NAS, it does not complete and it does not give any messages informing you why. Does anyone have any ideas what might be wrong? Suresh: I am hoping you have already restarted the services. Another thing you could try is to debug the NAS from the command prompt. I believe there is an article online on how to debug it. Nitin: If you are using script to run WinSCP, check the log and compare it when it runs manually vs. NAS. I had a similar issue recently. Let me know if you need further help in this area. Kyle: What account is the NAS running under? That account might not have the same security rights as your account (when you run it manually). Is there anything in the Application event log? Can you tell if the problem is that the script isn't starting at all, or is the script starting but just failing to complete? Nitin: Login to server as a NAS user and try to run the script manually. If it still has the same issue, type commands one by one to the command prompt where you have WinSCP program. I had trouble with Network Folder path (e.g., c$ vs c: in script, NAV not recognizing network folder when run using NAS), try changing folder path to something local. Also, during troubleshooting with WinSCP script, I found that if there is any special character in SFTP/FTP password (e.g. '+'), it must be replaced with '%2B' in the script. Tom: Never mind . . . I just switched them over to using a scheduled task. I feel like that will get them by until they upgrade from NAV 5 to something that will do a better job of integrating. Thanks for the advice, everyone.presentation from Microsoft Ignite. Stay abreast of what is new in the Microsoft Dynamics NAV community and at ArcherPoint by subscribing to our monthly newsletter, Better Business, by completing the form in our Resource Center. If you are interested in NAV development, be sure to see our collection of NAV Development Blogs. Read more "How To" blogs from ArcherPoint for practical advice on using Microsoft Dynamics NAV.
- Login Error: Communication protocol mismatch between client and server
- Creating a Date Table in Power BI
- How to Make Measures Total Correctly in Power BI Tables
- The Microsoft Technology Stack – What It Is and Why You Should Care
- The Top Eight KPIs Retailers Should Be Tracking (with Formulas) for Your Retail KPI Dashboard