andrewbutenko / personalviewchartdbtransfertool Goto Github PK

I was copying from an on-premise, v8.1 environment to a v9 cloud environment. The Object Type Codes for the custom entities are different in the on-premise vs the cloud environment based on how solutions were loaded. When using this tool, various columns in the view (layoutxml specifically) retain the object type code from on-premise. This leads to it giving an error in the cloud environment.

I queried the userquery table and could see that a view created in the cloud has object type code that is correct with the entity metadata but the migrated had the on-premise object type code

Unhandled exception:
Exception type: System.ServiceModel.FaultException`1[Microsoft.Xrm.Sdk.OrganizationServiceFault]
Message: System.Xml.XmlException: Microsoft.Crm.Metadata.EntityMetadataNotFoundException: The entity with ObjectTypeCode = 10190 was not found in the MetadataCache. MetadataCacheDetails: ProviderType=Dynamic, StandardCache=True, IsLoadedInStagedContext = False, Timestamp=20563985, MinActiveRowVersion=20563985
at Microsoft.Crm.Metadata.DynamicMetadataCache.GetEntity(Int32 entityCode)
at Microsoft.Crm.Application.Controls.AppGrid.set_ViewId(String value)
at Microsoft.Crm.Core.Application.WebServices.AppGridWebServiceHandler.FillNewGrid(AppGrid appGrid, XmlDocument gridXml, String id)
at Microsoft.Crm.Core.Application.WebServices.AppGridWebServiceHandler.Reset(String gridXml, String id, StringBuilder sbXml, StringBuilder sbHtml)
at Microsoft.Crm.Core.Application.WebServices.AppGridWebServiceHandler.ProcessRequestInternal(HttpContext context) ---> Microsoft.Crm.Metadata.EntityMetadataNotFoundException: The entity with ObjectTypeCode = 10190 was not found in the MetadataCache. MetadataCacheDetails: ProviderType=Dynamic, StandardCache=True, IsLoadedInStagedContext = False, Timestamp=20563985, MinActiveRowVersion=20563985
at Microsoft.Crm.Metadata.DynamicMetadataCache.GetEntity(Int32 entityCode)
at Microsoft.Crm.Application.Controls.AppGrid.set_ViewId(String value)
at Microsoft.Crm.Core.Application.WebServices.AppGridWebServiceHandler.FillNewGrid(AppGrid appGrid, XmlDocument gridXml, String id)
at Microsoft.Crm.Core.Application.WebServices.AppGridWebServiceHandler.Reset(String gridXml, String id, StringBuilder sbXml, StringBuilder sbHtml)
at Microsoft.Crm.Core.Application.WebServices.AppGridWebServiceHandler.ProcessRequestInternal(HttpContext context)
--- End of inner exception stack trace ---
at Microsoft.Crm.Core.Application.WebServices.AppGridWebServiceHandler.ProcessRequestInternal(HttpContext context)
at System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()
at System.Web.HttpApplication.ExecuteStepImpl(IExecutionStep step)
at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously): Microsoft Dynamics CRM has experienced an error. Reference number for administrators or support: #59BF0C75Detail:

38dac9fd-b2f5-4197-9218-865c5bb9fd90
-2147220970

System.Xml.XmlException: Microsoft.Crm.Metadata.EntityMetadataNotFoundException: The entity with ObjectTypeCode = 10190 was not found in the MetadataCache. MetadataCacheDetails: ProviderType=Dynamic, StandardCache=True, IsLoadedInStagedContext = False, Timestamp=20563985, MinActiveRowVersion=20563985
at Microsoft.Crm.Metadata.DynamicMetadataCache.GetEntity(Int32 entityCode)
at Microsoft.Crm.Application.Controls.AppGrid.set_ViewId(String value)
at Microsoft.Crm.Core.Application.WebServices.AppGridWebServiceHandler.FillNewGrid(AppGrid appGrid, XmlDocument gridXml, String id)
at Microsoft.Crm.Core.Application.WebServices.AppGridWebServiceHandler.Reset(String gridXml, String id, StringBuilder sbXml, StringBuilder sbHtml)
at Microsoft.Crm.Core.Application.WebServices.AppGridWebServiceHandler.ProcessRequestInternal(HttpContext context) ---> Microsoft.Crm.Metadata.EntityMetadataNotFoundException: The entity with ObjectTypeCode = 10190 was not found in the MetadataCache. MetadataCacheDetails: ProviderType=Dynamic, StandardCache=True, IsLoadedInStagedContext = False, Timestamp=20563985, MinActiveRowVersion=20563985
at Microsoft.Crm.Metadata.DynamicMetadataCache.GetEntity(Int32 entityCode)
at Microsoft.Crm.Application.Controls.AppGrid.set_ViewId(String value)
at Microsoft.Crm.Core.Application.WebServices.AppGridWebServiceHandler.FillNewGrid(AppGrid appGrid, XmlDocument gridXml, String id)
at Microsoft.Crm.Core.Application.WebServices.AppGridWebServiceHandler.Reset(String gridXml, String id, StringBuilder sbXml, StringBuilder sbHtml)
at Microsoft.Crm.Core.Application.WebServices.AppGridWebServiceHandler.ProcessRequestInternal(HttpContext context)
--- End of inner exception stack trace ---
at Microsoft.Crm.Core.Application.WebServices.AppGridWebServiceHandler.ProcessRequestInternal(HttpContext context)
at System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()
at System.Web.HttpApplication.ExecuteStepImpl(IExecutionStep step)
at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously): Microsoft Dynamics CRM has experienced an error. Reference number for administrators or support: #59BF0C75
2019-06-16T18:57:53.8743417Z
false


38dac9fd-b2f5-4197-9218-865c5bb9fd90
-2147217150

The entity with ObjectTypeCode = 10190 was not found in the MetadataCache. MetadataCacheDetails: ProviderType=Dynamic, StandardCache=True, IsLoadedInStagedContext = False, Timestamp=20563985, MinActiveRowVersion=20563985
2019-06-16T18:57:53.8743417Z
false

I updated XRMToolBox recently and now your excellent tool appears not to load users or teams at all:

Scenario uses two tenants with different authentication. Both tenants' connections are valid.

Tenant A: Set up with Connection Wizard
Tenant B: Set up with SDK Login Control

If Tenant A is the source and Tenant B is the destination, operation load users and teams fails with message: unable to read user password.
If Tenant B is the source and Tenant A is the destination, operation load users and teams completes successfully.

System.Exception: Unable to read user password
at McTools.Xrm.Connection.ConnectionDetail.ConnectOnline()
at McTools.Xrm.Connection.ConnectionDetail.GetCrmServiceClient(Boolean forceNewService)
at AButenko.PersonalViewsDashboardsTransferTool.PvdbTransferToolPluginControl.RetrieveUsers(BackgroundWorker worked, DoWorkEventArgs args)
at System.ComponentModel.BackgroundWorker.OnDoWork(DoWorkEventArgs e)
at System.ComponentModel.BackgroundWorker.WorkerThreadStart(Object argument)

Hi Andrew,

When trying to Migrate Personal Dashboards. Even when I choose one dashboard and hit migrate Personal Dashboards button, all user's dashboards are transferred to the destination instead of one dashboard I have selected.

Another thing I noticed is when I hit load personal dashboards a couple of times to refresh but it keeps duplicating the list with users.

Transferring Personal views work fine only one thing is even though choose "Migrate views and share". Share permissions are not migrating.

Thanks

When I click on the button "Load personal views", nothing happens. I am Connected to both environments. The source and the destination instance. I use version 1.0.0.8 of the tool. I tried to install version 1.0.2, but it remains 1.0.0.8

I hope this can be solved.

Kind regards,
Martin.

After view migration of views from custom entities (onprem2013 to 365Online), the advanced find is not working on the views properly. [Showing the filter criteria, but the resulting is not working (Unexpected error)]. The GUI view is working fine.
Maybe related to the entitytype codes. Is it possibe to implement some kind of lookup functionality?

Hello, I get the error above - do I have to configure the plugin somewhere else?
Thanks.

Hi,

We migrated views with the help of tool and after deployment views are getting wiped out.

we are using pipeline for solution deployments.

Regards
Pragati

There seems to be an issue with transferring personal views, charts and dashboards from instances that have version 9.x installed to destination instances with versions less than V9. In my case, the Source Instance has Version 9.1.0.1117 and the Destination instance has Version 8.2.2.2464.

I've successfully used your plugin to transfer from V9.1 to V9.1 environments, so I think this is a versioning problem. Please advise. Thanks!

I am able to connect to source and target environments. Also, loading Users and Teams works fine. But I get the following error when trying to load personal Charts, Views or Dashboards.

Plugin version

XrmToolBox version

I've found this an excellent and very useful tool in the past but it's becoming increasingly hard to use nowadays because it doesn't seem to support the new AAD Group Teams.

Please allow AAD Group Teams to be mapped and used just like Owner Teams.

Regards

--
Simon

Hello, until a few days ago everything was working fine

But now the following message is received

Unable to cast object of type 'Microsoft.Xrm.Sdk.WebServiceClient.OrganizationWebProxyClient' to type 'Microsoft.Xrm.Sdk.Client.OrganizationServiceProxy

thanx:)

It would be good to be able to see Views/Charts/Dashboards for disabled Users/Teams as well as enabled ones.

Here is the Error

Unable to cast object of type 'Microsoft.Xrm.Sdk.WebServiceClient.OrganizationWebProxyClient' to type 'Microsoft.Xrm.Sdk.Client.OrganizationServiceProxy

If you select a Team that has Personal Views assigend to them, when you click on the Load Personal Views button, no views shows up.

On the "Load User/Team Mapping" tab, if you try to map a user to a team, the migration fails with an error that it cannot find the guid in the SystemUsers entity. I'm guessing it is not looking for the Team in the Teams entity.

Opening the tool in the latest version v1.2.022.5.56 of XrmToolBox is failing with the following error.

When trying to load users and teams after connecting to 2 organisations that are 2011
i get the error
'Team' entity doesn't contain attribute with Name = 'teamtype'.
and am unable to use the tool