Top Table Usage in PPAC
Top Ten Table usage is back from being lost when Organizational Insights was discontinued. A bit tricky to find so check out the video.
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!
API per user limits – The good, the bad and the ugly
Microsoft recently release some throttling that have been causing some stir in the community, especially since the latest throttle, the concurrency throttling, was not very openly announced, some partners and customers were hit rather hard by it as it affected their abilities to manage large dataloads in the system.
Now Microsoft have announce another API based limitation which is based on the users and the type of licenses the have. You can read some about it here if you like. This article will discuss what this means and my personal view of the good, the bad and the ugly of it.
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.
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:...
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.