Er treden fouten op bij het werken met SystemUser-records na de migratie van Microsoft Dynamics CRM Online naar on-premises

  • Artikel

Dit artikel biedt een oplossing voor het probleem dat u mogelijk enkele foutberichten ontvangt wanneer u met SystemUser-records werkt na de migratie naar Microsoft Dynamics CRM on-premises.

Van toepassing op: Microsoft Dynamics CRM 2011
Origineel KB-nummer: 2830704

Symptomen

Na het importeren van een Microsoft Dynamics CRM Online organisatie in een Microsoft Dynamics CRM on-premises implementatie, treden er verschillende problemen op met records van systeemgebruikers. Specifieke symptomen zijn:

  1. Wanneer u probeert de beveiligingsrol Systeembeheerder toe te wijzen aan een Microsoft Dynamics CRM gebruiker, treedt de volgende fout op:

    System.Web.HttpUnhandledException: Microsoft Dynamics CRM heeft een fout opgetreden. Referentienummer voor beheerders of ondersteuning: #009FAAB1 2013-03-14T14:48:07.871872Z

    Foutdetails:

    Niet-verwerkte uitzondering: System.ServiceModel.FaultException'1[[Microsoft.Xrm.Sdk.OrganizationServiceFault, Microsoft.Xrm.Sdk, Version=5.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35]]: System.Web.HttpUnhandledException: Microsoft Dynamics CRM heeft een fout opgetreden. Referentienummer voor beheerders of ondersteuning: #009FAAB1Detail:

  2. Wanneer u probeert een record van een systeemgebruiker te wijzigen in Microsoft Dynamics CRM, treedt de volgende fout op:

    Er is een fout opgetreden.

    Foutdetails:

    Niet-verwerkte uitzondering: System.ServiceModel.FaultException'1[[Microsoft.Xrm.Sdk.OrganizationServiceFault, Microsoft.Xrm.Sdk, Version=5.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35]]: Assembly Microsoft.Crm.Yammer, Version=5.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35 kan niet worden geladen vanuit GAC. Detail:
    <OrganizationServiceFault xmlns:i="https://www.w3.org/2001/XMLSchema-instance" xmlns="https://schemas.microsoft.com/xrm/2011/Contracts">
    <ErrorCode-2147204719></ErrorCode>
    <ErrorDetails xmlns:d2p1="https://schemas.datacontract.org/2004/07/System.Collections.Generic" />
    <Message>Assembly Microsoft.Crm.Yammer, Version=5.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35 kan niet worden geladen vanuit GAC.</Bericht>
    <Timestamp>Timestamp</Timestamp>
    <InnerFault i:nil="true" />
    <TraceText i:nil="true" />
    </OrganizationServiceFault>

Oorzaak

Microsoft Dynamics CRM Online is bijgewerkt met de mogelijkheid om te integreren met Yammer. Deze update is momenteel niet beschikbaar voor Microsoft Dynamics CRM on-premises.

Oplossing

Om dit probleem op te lossen, moet de Yammer-integratie worden verwijderd uit de database. Dit kan worden gedaan met de volgende scripts:

--Remove UpdateYammerProperties SDK Message from the database  
delete from SdkMessageResponseFieldBase where SdkMessageResponseId='1c4e947e-79f0-4e35-b2a8-000959ef93f4'  
delete from SdkMessageResponseBase where SdkMessageResponseId='1c4e947e-79f0-4e35-b2a8-000959ef93f4'  
delete from SdkMessageRequestFieldBase where SdkMessageRequestId='a951346f-b39e-44a3-8cfa-9e1d596573d9'  
delete from SdkMessageRequestBase where SdkMessageRequestId='a951346f-b39e-44a3-8cfa-9e1d596573d9'  
delete from SdkMessageProcessingStepBase where SdkMessageProcessingStepId = 'ea822b51-e812-4cf0-938b-2fb9baebf4c5'  
delete from SdkMessageFilterBase where SdkMessageFilterId = 'fec3b044-425a-4dfa-ad49-b7cb150be9f0'  
delete from SdkMessagePairBase where SdkMessagePairId = '190a01bb-7d20-4d08-a862-91f538bb0756'  
delete from SdkMessageBase where SdkMessageId = 'fdc7ffae-6c75-48f0-890a-b9cb96d43de3'  
--Remove references from the BaseIds table (note: there are no ids table for SdkMessageResponseField and SdkMessageRequestField entities)  
delete from SdkMessageResponseBaseIds where SdkMessageResponseId='1c4e947e-79f0-4e35-b2a8-000959ef93f4'  
delete from SdkMessageRequestBaseIds where SdkMessageRequestId='a951346f-b39e-44a3-8cfa-9e1d596573d9'  
delete from SdkMessageProcessingStepBaseIds where SdkMessageProcessingStepId = 'ea822b51-e812-4cf0-938b-2fb9baebf4c5'  
delete from SdkMessageFilterBaseIds where SdkMessageFilterId = 'fec3b044-425a-4dfa-ad49-b7cb150be9f0'  
delete from SdkMessagePairBaseIds where SdkMessagePairId = '190a01bb-7d20-4d08-a862-91f538bb0756'  
delete from SdkMessageBaseIds where SdkMessageId = 'fdc7ffae-6c75-48f0-890a-b9cb96d43de3'

--Remove FollowInYammer SDK Message and its' pluginType from the database  
delete from SdkMessageResponseFieldBase where SdkMessageResponseId='0BF5D7C1-345A-4B13-80C4-A7C2727B20F2'  
delete from SdkMessageResponseBase where SdkMessageResponseId='0BF5D7C1-345A-4B13-80C4-A7C2727B20F2'  
delete from SdkMessageRequestFieldBase where SdkMessageRequestId='83CC2E86-631F-498A-8300-A5AC2547AB3E'  
delete from SdkMessageRequestBase where SdkMessageRequestId='83CC2E86-631F-498A-8300-A5AC2547AB3E'  
delete from SdkMessageProcessingStepBase where SdkMessageProcessingStepId = '1B1B9068-E700-40C1-8C9F-9FC7A473A2C1'  
delete from SdkMessageFilterBase where SdkMessageFilterId = 'A43CE9F5-2698-4F1D-82D9-6FA179AB51D9'  
delete from SdkMessagePairBase where SdkMessagePairId = '00F48FF1-DF35-48BC-B846-9DEB63A3DACB'  
delete from SdkMessageBase where SdkMessageId = '5E4361F9-B294-4884-A186-6AB7B9F5FEA1'  
delete from PluginTypeBase where PluginTypeId = 'EDEF9169-DBC7-49D9-BE83-FCCB9C692B48'

--Remove references from the BaseIds table (note: there are no ids table for SdkMessageResponseField and SdkMessageRequestField entities)  
delete from SdkMessageResponseBaseIds where SdkMessageResponseId='0BF5D7C1-345A-4B13-80C4-A7C2727B20F2'  
delete from SdkMessageRequestBaseIds where SdkMessageRequestId='83CC2E86-631F-498A-8300-A5AC2547AB3E'  
delete from SdkMessageProcessingStepBaseIds where SdkMessageProcessingStepId = '1B1B9068-E700-40C1-8C9F-9FC7A473A2C1'  
delete from SdkMessageFilterBaseIds where SdkMessageFilterId = 'A43CE9F5-2698-4F1D-82D9-6FA179AB51D9'  
delete from SdkMessagePairBaseIds where SdkMessagePairId = '00F48FF1-DF35-48BC-B846-9DEB63A3DACB'  
delete from SdkMessageBaseIds where SdkMessageId = '5E4361F9-B294-4884-A186-6AB7B9F5FEA1'  
delete from PluginTypeBaseIds where PluginTypeId = 'EDEF9169-DBC7-49D9-BE83-FCCB9C692B48'

--Remove PostFollow.Create plugin  
delete from SdkMessageProcessingStepBase where SdkMessageProcessingStepId = 'D87006BC-3423-461d-8821-EA4120995C16'  
delete from PluginTypeBase where PluginTypeId = '2CEFE901-742F-48e1-8741-FA862274F30B'  
delete from SdkMessageProcessingStepBaseIds where SdkMessageProcessingStepId = 'D87006BC-3423-461d-8821-EA4120995C16'  
delete from PluginTypeBaseIds where PluginTypeId = '2CEFE901-742F-48e1-8741-FA862274F30B'

--Remove SystemUser.Update plugin  
delete from SdkMessageProcessingStepBase where SdkMessageProcessingStepId = 'AA12BB05-EAE1-4fbc-A2BE-E21CE11F7386'  
delete from PluginTypeBase where PluginTypeId = '09F61DB5-F673-4401-8C64-109BF7D38416'  
delete from SdkMessageProcessingStepBaseIds where SdkMessageProcessingStepId = 'AA12BB05-EAE1-4fbc-A2BE-E21CE11F7386'  
delete from PluginTypeBaseIds where PluginTypeId = '09F61DB5-F673-4401-8C64-109BF7D38416'

--Remove the Plugin Assembly Microsoft.Crm.Yammer  
delete from PluginAssemblyBase where PluginAssemblyId = '0B887035-5406-44e5-9EE1-0ABCBF980849'  
delete from PluginAssemblyBaseIds where PluginAssemblyId = '0B887035-5406-44e5-9EE1-0ABCBF980849'

--Remove the PostJsonPlugin and its assembly Microsoft.Crm.ExternalProxy.dll  
delete from PluginTypeBase where PluginTypeId = 'A4D7EAAF-9D37-4AC2-98A3-CCB372156479'  
delete from PluginTypeBaseIds where PluginTypeId = 'A4D7EAAF-9D37-4AC2-98A3-CCB372156479'  
delete from PluginAssemblyBase where PluginAssemblyId = 'E220F237-7DBE-4F0C-BE6D-18B08DD78271'  
delete from PluginAssemblyBaseIds where PluginAssemblyId = 'E220F237-7DBE-4F0C-BE6D-18B08DD78271'

--Remove Yammer's Async Operation Job  
DELETE FROM [dbo].[AsyncOperationBase] where [AsyncOperationId]='6EF45A82-1AAB-48ab-8301-CD753F265214'

--Deletes prvConfigureYammer privilege  
Declare @privilegeId as uniqueidentifier

Select @privilegeId =PrivilegeId From Privilege  
Where Name = 'prvConfigureYammer'

Select * From RolePrivileges  
Where PrivilegeId = @privilegeId

Select * From RoleTemplatePrivileges  
Where PrivilegeId = @privilegeId

Select * From PrivilegeObjectTypeCodes  
Where PrivilegeId = @privilegeId

--Starts deleting the Privilege entries  
Delete RolePrivileges  
Where PrivilegeId = @privilegeId

Delete RoleTemplatePrivileges  
Where PrivilegeId = @privilegeId

Delete PrivilegeObjectTypeCodes  
Where PrivilegeId = @privilegeId

Delete Privilege  
Where PrivilegeId = @privilegeId

Meer informatie

Dit script is niet vereist nadat updatepakket 13 is uitgebracht voor Microsoft Dynamics CRM on-premises.