Tuesday, April 16, 2019

I'm a huge fan of detailed application logs

By Steve Endow

This week, one of my customers suddenly started having severe performance issues with a custom Dynamics GP web API that I developed for them a few years ago.

The customer and their Dynamics GP partner immediately knew about the performance problem because the web API has logic to detect certain performance issues, log the problem, and proactively send an email notification to the customer and GP partner.

This is a sample of the log file that told me everything I needed to know to work on diagnosing the issue.

Full Time Debug Level Logging with Elapsed Time Measurement

Notice that the elapsed time (in parens) jumps from 0.09 seconds to 32.96 seconds when the GetCCCustomerProfileID step completes?  That step normally takes a few milliseconds, but was suddenly taking 20-40 seconds to complete.  No bueno.  That step calls an on-premises web service for a credit card management system, and that system was experiencing a problem.  Fortunately, my code is setup to log a warning and send an email whenever an operation takes more than 20 seconds, so admins were notified as soon as the problem started.

Measuring Latency in Complex PowerApps

By Steve Endow

I have created a PowerApp that has several dependencies, and I am concerned about latency, and how that will affect the delay that a user experiences when they use the PowerApp.

In order to understand the latency, I have designed my PowerApp-based solution to measure and display elapsed times for key operations that are performed when a user clicks a button.

Here's a video demonstrating the design and the underlying code:



When I say "Complex" PowerApp, I am referring to an application or solution that has multiple dependencies or performs complex operations that may result in a noticeable delay for the user.

Wednesday, April 10, 2019

Dynamics GP: Deleting all document attachments for Payables Transactions

By Steve Endow

TOPIC:  Microsoft Dynamics GP


I'm working with a customer to automate the import of Document Attachments into Dynamics GP.

As part of the testing process, we are having to clear out all of the test attachments that have been imported so that we can re-import them again.

In case it's of interest to anyone, here are some SQL scripts I created to delete out ALL document attachments for ALL payables transactions.  You can modify the scripts to remove attachments for other record types.

Make sure to backup your company database before running any of these scripts.

If you find any mistakes or problems with these scripts, please let me know.

Monday, April 1, 2019

Microsoft Dynamics 365 Business Central: Links to Information and Resources

By Steve Endow

Last updated 13 September 2019

There is so much information being published about Dynamics 365 Business Central that I find it difficult to keep track of everything.  I am going to collect links to information and resources here for my reference.  I will update this list regularly as I find new resources.

You can use this short URL to reference this post:  http://bit.ly/bcresources

Please feel free to send me additional resources!

https://twitter.com/steveendow  or   steveendow {at} gmail.


The most common eConnect error: The source was not found, but some or all event logs could not be searched

By Steve Endow

This is one of the most common eConnect errors that I continue to see with Dynamics GP customers.  It occurs when a new server is setup with eConnect, or when an integration is migrated to a new server where eConnect was just installed.

It is very simple to fix, but requires Local Admin rights on the machine running eConnect.


eConnect error:

Exception: The source was not found, but some or all event logs could not be searched.  To create the source, you need permission to read all event logs to make sure that the new source name is unique.  Inaccessible logs: Security.


Thursday, March 28, 2019

Dynamics 365 Business Central April Upgrade Scheduling - Important Notes!

By Steve Endow

If you haven't read the post on the Business Central for Partners blog about "Scheduling your April 2019 Upgrade for Business Central", I recommend reading it thoroughly.

https://community.dynamics.com/business/b/businesscentraldevitpro/archive/2019/03/27/scheduling-your-spring-2019-upgrade-for-business-central


It has several very valuable points about enhancements to the Business Central version upgrade process.


Some of the key points are:

Beginning with the April '19 release, we will also send notifications for preview version availability, upgrade scheduling, extension validation, and upgrade failures.

Saturday, March 16, 2019

Troubleshooting a Dynamics GP SQL Posting Error

By Steve Endow

I recently had a call with my friend Windi Epperson to troubleshoot an odd SQL error that was occurring when posting a Dynamics GP batch.



Here is a video discussing the error and our journey to identify the cause and resolve the issue.


Dynamics GP: Does GL batch size affect posting performance? Yes, it does.

By Steve Endow If you need to post 50,000 journal entries in Dynamics GP, should you create one batch with 50,000 JEs?  Or should you crea...