You receive error messages when you upgrade the workflow rules from Microsoft Dynamics CRM 3.0 to Microsoft Dynamics CRM 4.0

Article translations Article translations
Article ID: 959246 - View products that this article applies to.
Expand all | Collapse all

On This Page

SYMPTOMS

A user has custom picklist attributes or Boolean fields in the SystemUser entity in Microsoft Dynamics CRM 3.0. When you upgrade the workflow rules that are owned by this user from Microsoft Dynamics CRM 3.0 to Microsoft Dynamics CRM 4.0, you receive error messages that resemble the following:
Platform Error
=====================================
[2008-10-15 12:21:49.2] Process:Microsoft.Crm.Setup.Server |Organization:8dd66f84-b62d-46a8-b289-8824f9896752 |Thread: 1 |Category: Platform.Sql |User: 00000000-0000-0000-0000-000000000000 |Level: Error | BusinessProcessObject.DoRetrieve
at BusinessProcessObject.DoRetrieve(BusinessEntity entity, EntityExpression entityExpression, ExecutionContext context, Int32 languageCode)
at BusinessProcessObject.Retrieve(BusinessEntityMoniker moniker, EntityExpression entityExpression, ExecutionContext context, Int32[] deletionCodes, Int32 languageCode) at BusinessProcessObject.Retrieve(BusinessEntityMoniker moniker, EntityExpression entityExpression, ExecutionContext context, Int32[] deletionCodes)
at BusinessProcessObject.Retrieve(BusinessEntityMoniker moniker, EntityExpression entityExpression, ExecutionContext context)
at UserDataCacheLoader.LoadCacheData(Guid key, ExecutionContext context)
at ObjectModelCacheLoader`2.LoadCacheData(TKey key, IOrganizationContext context)
at BasicCrmCache`2.CreateEntry(TKey key, IOrganizationContext context)
at BasicCrmCache`2.LookupEntry(TKey key, IOrganizationContext context) at SecurityLibrary.GetUserBusinessId(Guid user, IOrganizationContext context) at InjectDefaultsExtension.PreCreateHandler(Object sender, ExtensionEventArgs e)
at PreCreateEventHandler.Invoke(Object sender, ExtensionEventArgs e)
at BusinessProcessObject.Create(IBusinessEntity entity, ExecutionContext context)
at AttachmentServiceBase.Create(IBusinessEntity entity, ExecutionContext context)
at AnnotationServiceInternal`1.Create(IBusinessEntity entity, ExecutionContext context)
at WorkflowServiceInternal`1.CopyAttachment(Guid activationId, Guid definitionId, ExecutionContext context)
at WorkflowServiceInternal`1.CompletePublishing(WorkflowEntity definition, List`1 dependencies, List`1 customActivityIds, ExecutionContext context) at WorkflowServiceInternal`1.PublishInPlace(WorkflowEntity definition, ExecutionContext context) at SdkCommand.PublishWorkflow(DynamicEntity definition, Guid parentId, Guid activationId, IUpgradeContext upgradeContext, Boolean isInstance, Boolean isInactiveActivation)
at WorkflowAdapter.Publish(Guid parentId, Guid activationId, IUpgradeContext context, Boolean isInstance, Boolean isInactiveActivation)
at WorkflowUpgradeOrchestration.UpgradeDefinitions(IUpgradeContext upgradeContext, IDataProvider`1 dataProvider)
at WorkflowUpgradeOrchestration.Upgrade(IDataProvider`1 wfProcessDataProvider, IDataProvider`1 wfProcessInstanceDataProvider)
at WorkflowUpgradeOrchestration.Upgrade() at WorkflowUpgradeAction.Do(IDictionary parameters) at Action.ExecuteAction(Action action, IDictionary parameters, Boolean undo)
at Action.DoAction(Action action, IDictionary parameters) at Installer.Install(IDictionary stateSaver)
at ComposedInstaller.InternalInstall(IDictionary stateSaver)
at ComposedInstaller.Install(IDictionary stateSaver) at ServerSetup.Upgrade(IDictionary data) at ServerSetup.Run() at ServerSetup.InternalMain(String[] args) at ServerSetup.Main(String[] args) >Exception when executing query: select systemuser0.Address1_City as 'address1_city', systemuser0.TimeZoneRuleVersionNumber as 'timezoneruleversionnumber', systemuser0.Address2_City as 'address2_city', systemuser0.Address1_Latitude as 'address1_latitude', systemuser0.Address2_Telephone1 as 'address2_telephone1', systemuser0.MobilePhone as 'mobilephone', systemuser0.InviteStatusCode as 'invitestatuscode', systemuser0.MiddleName as 'middlename', systemuser0.HomePhone as 'homephone', systemuser0.Address2_Longitude as 'address2_longitude', systemuser0.Address2_Line3 as 'address2_line3', systemuser0.Address2_ShippingMethodCode as 'address2_shippingmethodcode', systemuser0.UTCConversionTimeZoneCode as 'utcconversiontimezonecode', systemuser0.Address2_UTCOffset as 'address2_utcoffset', systemuser0.PreferredAddressCode as 'preferredaddresscode', systemuser0.Address2_Line2 as 'address2_line2', systemuser0.SystemUserId as 'systemuserid', systemuser0.Address2_Telephone3 as 'address2_telephone3', systemuser0.Address2_UPSZone as 'address2_upszone', systemuser0.PreferredEmailCode as 'preferredemailcode', systemuser0.Address2_PostalCode as 'address2_postalcode', systemuser0.WindowsLiveID as 'windowsliveid', systemuser0.YomiMiddleName as 'yomimiddlename', systemuser0.IHS_LaptopClient as 'ihs_laptopclient', systemuser0.FirstName as 'firstname', systemuser0.FullName as 'fullname', systemuser0.Address2_AddressTypeCode as 'address2_addresstypecode', systemuser0.ModifiedOn as 'modifiedon', systemuser0.Address1_UTCOffset as 'address1_utcoffset', systemuser0.Address2_PostOfficeBox as 'address2_postofficebox', systemuser0.Address2_Latitude as 'address2_latitude', systemuser0.SiteId as 'siteid', systemuser0.CreatedBy as 'createdby', systemuser0.ParentSystemUserId as 'parentsystemuserid', systemuser0.Address1_Line3 as 'address1_line3', systemuser0.Address2_StateOrProvince as 'address2_stateorprovince', systemuser0.OverriddenCreatedOn as 'overriddencreatedon', systemuser0.YomiFullName as 'yomifullname', systemuser0.EmployeeId as 'employeeid', systemuser0.PreferredPhoneCode as 'preferredphonecode', systemuser0.MobileAlertEMail as 'mobilealertemail', systemuser0.Address1_Name as 'address1_name', systemuser0.NickName as 'nickname', systemuser0.GovernmentId as 'governmentid', systemuser0.IHS_DesktopClient as 'ihs_desktopclient', systemuser0.Address1_Line1 as 'address1_line1', systemuser0.Address1_AddressTypeCode as 'address1_addresstypecode', systemuser0.Address1_PostOfficeBox as 'address1_postofficebox', systemuser0.Address1_Longitude as 'address1_longitude', systemuser0.Address1_ShippingMethodCode as 'address1_shippingmethodcode', systemuser0.Address2_County as 'address2_county', systemuser0.Address2_Name as 'address2_name', systemuser0.Address1_Telephone2 as 'address1_telephone2', systemuser0.DisplayInServiceViews as 'displayinserviceviews', systemuser0.LastName as 'lastname', systemuser0.Salutation as 'salutation', systemuser0.Address1_Telephone1 as 'address1_telephone1', systemuser0.Title as 'title', systemuser0.ModifiedBy as 'modifiedby', systemuser0.SetupUser as 'setupuser', systemuser0.IHS_DefaultCaseType as 'ihs_defaultcasetype', systemuser0.YomiFirstName as 'yomifirstname', systemuser0.Address2_Telephone2 as 'address2_telephone2', systemuser0.AccessMode as 'accessmode', systemuser0.Address1_AddressId as 'address1_addressid', systemuser0.IHS_Initials as 'ihs_initials', systemuser0.Address2_Country as 'address2_country', systemuser0.Skills as 'skills', systemuser0.TerritoryId as 'territoryid', systemuser0.BusinessUnitId as 'businessunitid', systemuser0.OutgoingEmailDeliveryMethod as 'outgoingemaildeliverymethod', systemuser0.CalendarId as 'calendarid', systemuser0.Address1_Fax as 'address1_fax', systemuser0.PersonalEMailAddress as 'personalemailaddress', systemuser0.IsDisabled as 'isdisabled', systemuser0.YomiLastName as 'yomilastname', systemuser0.Address1_UPSZone as 'address1_upszone', systemuser0.PassportLo as 'passportlo', systemuser0.Address1_StateOrProvince as 'address1_stateorprovince', systemuser0.CreatedOn as 'createdon', systemuser0.DisabledReason as 'disabledreason', systemuser0.IncomingEmailDeliveryMethod as 'incomingemaildeliverymethod', systemuser0.Address2_Line1 as 'address2_line1', systemuser0.ImportSequenceNumber as 'importsequencenumber', systemuser0.DomainName as 'domainname', systemuser0.Address1_Country as 'address1_country', systemuser0.InternalEMailAddress as 'internalemailaddress', systemuser0.Address2_Fax as 'address2_fax', systemuser0.PhotoUrl as 'photourl', systemuser0.Address1_PostalCode as 'address1_postalcode', systemuser0.PassportHi as 'passporthi', systemuser0.IHS_Location as 'ihs_location', systemuser0.OrganizationId as 'organizationid', systemuser0.Address1_County as 'address1_county', systemuser0.IHS_notes as 'ihs_notes', systemuser0.Address1_Telephone3 as 'address1_telephone3', systemuser0.Address2_AddressId as 'address2_addressid', systemuser0.Address1_Line2 as 'address1_line2', systemuser0.JobTitle as 'jobtitle', systemuser0.ActiveDirectoryGuid as 'activedirectoryguid', systemuser0.SiteIdDsc as 'siteiddsc', systemuser0.SiteIdName as 'siteidname', systemuser0.CreatedByYomiName as 'createdbyyominame', systemuser0.CreatedByName as 'createdbyname', systemuser0.CreatedByDsc as 'createdbydsc', systemuser0.ParentSystemUserIdYomiName as 'parentsystemuseridyominame', systemuser0.ParentSystemUserIdName as 'parentsystemuseridname', systemuser0.ParentSystemUserIdDsc as 'parentsystemuseriddsc', systemuser0.ModifiedByYomiName as 'modifiedbyyominame', systemuser0.ModifiedByDsc as 'modifiedbydsc', systemuser0.ModifiedByName as 'modifiedbyname', systemuser0.TerritoryIdName as 'territoryidname', systemuser0.TerritoryIdDsc as 'territoryiddsc', systemuser0.BusinessUnitIdDsc as 'businessunitiddsc', systemuser0.BusinessUnitIdName as 'businessunitidname', systemuser0.OrganizationIdDsc as 'organizationiddsc', systemuser0.OrganizationIdName as 'organizationidname' from SystemUser as systemuser0 where (systemuser0.SystemUserId = 'a7dc947b-6ac3-4292-a9d8-e8ff032dc8d8') Exception: System.NullReferenceException: Object reference not set to an instance of an object.
at Microsoft.Crm.BusinessEntities.BusinessProcessObject.SetChildEnumAttributesOnBusinessEntity(BusinessEntity entity, Int32 languageCode, ExecutionContext context)
at Microsoft.Crm.BusinessEntities.BusinessProcessObject.DoRetrieve(BusinessEntity entity, EntityExpression entityExpression, ExecutionContext context, Int32 languageCode)
User Error
=====================================
Microsoft Dynamics CRM Server Setup did not complete successfully. Action Microsoft.Crm.Setup.Server.WorkflowUpgradeAction failed. There were errors during workflow upgrade

RESOLUTION

Update information

A setup update is available from Microsoft. When you install Microsoft Dynamics CRM 4.0, or when you upgrade to Microsoft Dynamics CRM 4.0, you can check for setup updates. If you select the option to check for setup updates, the application downloads any new setup updates and applies the setup updates to the installation while the setup process is running.

Installation information

To obtain this fix, use the Update Installation Files option during Microsoft Dynamics CRM 4.0 setup. For more information about how to use the Update Installation Files option or how to manually download the setup update, click the following article number to view the article in the Microsoft Knowledge Base:
948917 How to obtain the setup updates for Microsoft Dynamics CRM 4.0

Prerequisites

No prerequisites are required.

Removal information

The setup update cannot be removed.

STATUS

Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.

MORE INFORMATION

For more information about software update terminology, click the following article number to view the article in the Microsoft Knowledge Base:
824684 Description of the standard terminology that is used to describe Microsoft software updates

Properties

Article ID: 959246 - Last Review: January 30, 2009 - Revision: 1.0
APPLIES TO
  • Microsoft Dynamics CRM 4.0
Keywords: 
kberrmsg kbmbsupgrade kbfix kbsurveynew kbmbsmigrate kbqfe kbexpertiseinter KB959246

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com