Posts in Category: dynamics 365

Using the Solution Checker

When building new solutions with PowerApps (and now that Microsoft is strongly encouraging people to push solution infrastructure and usage to the new PowerApps model) you can now take advantage of the Solution Checker.

The Solution Checker is available from the main solution window and allows an administrator to validate a solution before exporting it and avoiding the whole conversations of “but you told me it was done?” that can sometimes happen with Dynamics.

sol.png

After you run the checker against your solution you are then able to view the results and identify what needs to be fixed (if anything) before

Read More


Dynamics365 is Not a Database

Yes, it has a database, more than one to be correct and it has this very cool and fancy thing called CDS which is equally awesome.

But it’s not a database.

Which right now is reminding me of this…

Image result for its not a tumour

As you embark on your next DTS (Digital Transformation Services) project and you decide to move to this new platform, it’s important to remember this concept.

It’s Not a Database.

Even though you can configure it with entities (that look an awful lot like tables) and you can create relationships (that look an awful lot like foreign keys) that have attributes (that look an awful lot like columns).

It’s Not a Database.

Hiring a Database Architect to develop a schema for you in Dynamics will not be as efficient

Read More


Geocoding with Dynamics

I’ve been working on a few projects the last little while that has involved leveraging Geocoding services to augment address data stored in Dynamics.  Where I previously thought that all Geocoding services are created equal, I was quick to learn that they are not and you should definitely do your due diligence in looking into what service you use.

This is an important piece as well, we were focused on using services only and not buying data that needed to be updated every quarter.  Many of the services out there give you a free stack of geocoding requests (based on what you’re doing) that you can most likely throttle down your daily limits and/or take the hit on.

What I found most interesting was to see which platforms had access to which

Read More


Database Errors on Restore into v9

If you’re getting ready to perform an on-premise update by importing new organizations into your existing tenant you might start to get some cryptic database errors on constraints.

The constraints themselves vary, mine was in reference to cndx_PrimaryKey_DiscountType, others I’ve seen were in relation to opportunities.

Whatever the error, you will need to install the 0.3 update to address and fix the issue so you can import the tenant.

When you install the server, this update is not applied by “Getting updates”.

The link to the patch is located here – https://support.microsoft.com/en-us/help/4490599/service-update-0-3-for-microsoft-dynamics-365-9-0 – once done, your upgrade and import will succeed.

Read More


Ribbon Work Bench and the Async Service

I ran into an interesting problem this past week in trying to publish some customizations via the RibbonWorkBench to an on-premise Dynamics tenant.

Here is the message we were receiving.

image

This led me down a road of checking permissions and seeing what forms I had in the solution I was working, connections being closed, security around using IFD deployments and on and on.

After a day or so, we realized the problem was that the Async Service Account could not write to the CustomizationImport folder on this server.  When we granted the appropriate permissions, the problem was solved.

(One more subtle reason to consider the cloud).

Read More