Tuesday, November 29, 2022

Migrate User Query (Personal Views) using Kingswaysoft

 It took us to the UAT stage to be sure the View Migration using XRM tool box - Personal View Migration Tool might now be viable when there are 1000s of saved Views, and the Saved Views referring to deleted fields which needs extreme manual monitoring.

Thanks to friends Harshal and Nilesh, WE figured out a way to do from Kingsway soft

The userquery table doesn't appear in the source Connection's Tables list for Dynamics, we need to use the OLEDB connection, but the Destination can be Dynamics Connection itself.

The Migration will be 3 step

1. Migrate(Insert/Upsert) the Userqueries without the owner mapping.

2. Share the UserQueries with the Users using the Principal Object Access table migration(Insert/Upsert),
with Source Data filter - Entity name = userquery

3. Migrate the Owner of the User query so that they get assigned to the Original Owners (Upsert)

At Step 1 we do not map the Owner because, once the Owner is changed, the Share will not work, even if you have System Administrator role .

Also If we try to Update the changes to the View like the criteria or the columns, will not be able to update unless Package running User is the Owner.

The Object Type Code in the Layout xml will need to be updated to the userquery's entity in the Target.
(Else the View will not render, for the Custom Entities - where the Object Type code at the Source Organization and the Target Organization are different.)

Monday, November 28, 2022

CRM Managed solution import fail - Plugin does not contain required types

This happens as the Plugin Assembly is seen as a different one by CRM.
To resolve this:
1.Increase the version of the Solution and Publish at the source, then import to the destination


Thanks to Friend Seshagiri - For arriving at this Simple yet tricky solution

Import File is too Large to upload (On Premise)

 One of the scenarios this happens is:
The CRM App Server - where the CRM Application folder is present has low space.
(C>Program Files>Microsoft Dynamics)/

Clear the folder to have at least 1 GB free to resolve the issue.

On a side note, other issues that you may face due to Space issue in the App/DB server are- 
CRM stops working

Other Tools that try to connect to CRM will throw - Metadata reference cannot be resolved error.