Wednesday, 21 August 2019

CRM 365 On Prem - Import CRM 2016 Organization

For the last days working on testing new features of CRM 365 Online, CRM 2016/365 On Prem and few more things.

And again, i had another issue, this one is really annoying, but let me explain what happened.

I have an environment in CRM 2016 with service pack 1.1 (8.1.1.1005) and we need to upgrade to V9 (365 Onprem). 

So, what i did? Backup of the database, restore of the database in the new V9 environment and imported the organization, expecting that the process would run smoothly, WRONG, it didn't, and that i should already expect based on my experience.

The error i got was: "09:24:11|Verbose| Error occured in UpdateRollupFieldStoredProceduresInternal: Microsoft.Crm.Metadata.MetadataAttributeMetadataNotFoundException: 'Attribute' metadata entity doesn't contain metadata attribute with Name = 'autonumberformat'."

I googled it, and nothing. So, in these cases what should we do? And again based on my experience, let's try to import into at least a same environment major version, in this case CRM 2016 (8.1) or CRM 2016 (8.2).

I imported into a VM with the same version of rollup and it worked. Next deleted the database, upgraded to version (8.2.2.0112), restored again the one from V8.1and imported the organization again. Voila, it worked. 


After doing this, imported this org into the V9 environment and it worked. Perfect, i could be happy, but not completely, needed more testing.


Again, deleted the database, upgradeed to version (8.2.9.19), last update in version 8.2, restored again the one from V8.1 and imported the organization again. And guess what, expecting to work, of course it didn't, was expecting a field from the systemuser table.


What can we learn from here, at least Microsoft is consistent, the same happened in CRM 2011, if not mistaken, we couldn't install update rollup 15, without 14, however, having the update rollup 14, we could go to update 21. What this means is, update rollup 14 was a major update release in the product, what it seams happening in here as well.

Hope it helps.

Saturday, 17 August 2019

CRM 365 - Unified Interface - do not see Run Workflows On Demand in forms or views

 Ok, again one more time Microsoft strikes again with the new release, in this case Unified Interface.

I just enabled the Unified Interface in one of the CRM Organizations I am working in (Sandbox) and saw a couple of strange things happening. Being System Administrator and not being able to create new records or even updating records i am the owner (entity account), already sorted, please see my previous post.

So, at the moment i am just uploading the new versions of my Plugins/Workflows with the latest nuget pakages from Microsoft. What was my surprise when just added a process to Run On Demand, and couldn't see the "Process - Run Process" on the form and grid.

What i did next, set to run on Create, created a record, and saw that was still working as expected. After some investigation, i have found that as an extra, we have to enable few things in the Platform Admin Center, and we need to be sure that we have as well the Microsoft Flow license is enabled.

What the hell??!!? The product is not supposed to work as before? At least functionality that was even not said by Microsoft that would be deprecated?

The steps to follow are below:

1. Check if Licence is enabled

Open https://portal.office.com/adminportal#/users and select the user
Click vertical … (skinny burger menu?) and select Manage product licenses
Expand Apps and make sure Flow for Dynamics 365 is selected

2. Enable Microsoft Flow

Enable setting to show Microsoft Flow on the forms and in the sitemap
Open Power platform admin center (https://aka.ms/ppac)
Select Environments
Click … (horizontal one, ugh), select Settings
Select Behavior
Make sure Show Microsoft Flow on forms and in the site map is selected


Hope it helps.

CRM 365 Cloud - Disassociate 2 records using typescript

In case you need to Disassociate 2 records, please find below the code that allows you to do that.      export async function DissociateE...