Fast data management in a limited CDS world
In May 2019 Dynamics 365 CE/CDS enacted some new throttling mechanisms that have caused some headaches for anyone wanting to manage a lot of data in CDS (I will refer to Dynamics 365/CDS as just CDS below). There are several different throttles but the one that has cause me most trouble is the concurrency throttle. Kingswaysoft will release support for handling this in the next release and you can also request a special version from them if you ask nicely. In the meanwhile this post can give you some help on how to work as fast as possible using application user mulitplexing and a loop with a 5 min wait to make sure that the throttles are reset.
TCP Chimney
Today I was working with a customer and we have had some weird SSIS intermittent errors where the Native OLE DB / SQL Client was giving me some trouble with really weird errors. Errors like these: CRM service call returned an error: CRM service call returned an error:...
How to reduce SubscriptionTrackingDeletedObject table in CDS/Dynamics 365 – Updated!
SubscriptionTrackingDeletedObject is a mysterious table that can grow to a large size in CDS/Dynamics 365 CE instances where a lot of deletion is done. This article will tell you how to change install a tool that allows you to change the retention period of the logs in this table to reduce its size. – UPDATED! Based on some new information I have now updated this article!
Azure guest accounts in CDS/Dyn365
Azure Active Directory (AAD) has a feature where it allows users of foreign tennants to be granted access to the current tennant. In other word, if you are running contoso.com and a user of northwind.com would like to have access, you can add this user as a guest account in Azure. However, I have found that giving this user access to Dynamics is not fully straight forward, although, it is far from rocket science. In this article I will show how this is done.
Forms Pro Flow activity set regarding
Using Flow to send a Survey in Forms Pro uses a different syntax than the CDS connector for setting the regarding fields to CDS related data. This is how.
Uninstalling Employee Self Service Portal – step by step
A customer of involontarily gotten a Dynamics 365 Employee portal installed. I had to remove it. It has 21 (!?) solutions which are interdependent. This is how I fixed it.
Gustaf Westerlund
12xMVP, MSc EE
Working as consultant since version 1.2. Involved in between 150-200 projects. Founder and Principal Consultant at CRM-Konsulterna.