Sitecore Commerce 8.1 after reference storefront user registration giving error as Failed to retrieve profile

I have installed sitecore commerce 8.1 and reference storefront by following http://commercesdn.sitecore.net/SCpbCS81/SCpbCSRefSfGuide/en-us/index.html#SA_Deployment_SCpbCSRefStorefront.html#concept_yjx_5pl_bt

Installation successful and website showing products but when am trying to register a user it is giving error as Failed to retrieve profile.

Exception: CommerceServer.Core.Runtime.Profiles.CommerceProfileSystemException
Message: Failed to retrieve profile.
Source: CommerceServer.Core.Runtime
at CommerceServer.Core.Runtime.Profiles.Profile..ctor(ProfileContext profileService, String keyName, String keyValue, String profileType)
at CommerceServer.Core.Runtime.Profiles.ProfileContext.GetProfile(String keyName, String keyValue, String profileType)
at Sitecore.Commerce.Connect.CommerceServer.Profiles.CommerceProfileRepository.GetProfile(String type, String value, String field)
at Sitecore.Commerce.Connect.CommerceServer.Profiles.Pipelines.GetProfileProcessor.Process(GetProfileArgs args)
at (Object , Object[] )
at Sitecore.Pipelines.CorePipeline.Run(PipelineArgs args)
at Sitecore.Commerce.Connect.CommerceServer.Profiles.CommerceServerProfileProvider.GetPropertyValues(SettingsContext context, SettingsPropertyCollection collection)
at Sitecore.Security.SwitchingProfileProvider.GetPropertyValues(SettingsContext context, SettingsPropertyCollection collection)
at System.Configuration.SettingsBase.GetPropertiesFromProvider(SettingsProvider provider)
at System.Configuration.SettingsBase.SetPropertyValueByName(String propertyName, Object propertyValue)
at System.Configuration.SettingsBase.set_Item(String propertyName, Object value)
at System.Web.Profile.ProfileBase.SetInternal(String propertyName, Object value)
at System.Web.Profile.ProfileBase.set_Item(String propertyName, Object value)
at Sitecore.Data.DataProviders.NullRetryer.ExecuteNoResult(Action action, Action recover)
at Sitecore.Security.UserProfile.SetPropertyValueCore(String propertyName, Object value)
at Sitecore.Security.UserProfile.get_CustomProperties()
at Sitecore.Security.UserProfile.GetCustomProperty(String propertyName)
at Sitecore.Security.SecurityUtil.GetUserDigestCredentials(User user, Boolean withoutDomain)
at Sitecore.Security.SecurityUtil.UpdateDigestCredentials(String username, String password)
at Sitecore.Security.SitecoreMembershipProvider.ValidateUser(String username, String password)
at Sitecore.Security.Authentication.AuthenticationHelper.ValidateUser(String userName, String password)
at Sitecore.Security.Authentication.MembershipAuthenticationProvider.Login(String userName, String password, Boolean persistent)
at Sitecore.Reference.Storefront.Managers.AccountManager.Login(CommerceStorefront storefront, VisitorContext visitorContext, String anonymousVisitorId, String userName, String password, Boolean persistent)
at Sitecore.Reference.Storefront.Controllers.AccountController.Login(LoginModel model)
at lambda_method(Closure , ControllerBase , Object[] )
at System.Web.Mvc.ReflectedActionDescriptor.Execute(ControllerContext controllerContext, IDictionary`2 parameters)
at System.Web.Mvc.ControllerActionInvoker.InvokeActionMethod(ControllerContext controllerContext, ActionDescriptor actionDescriptor, IDictionary`2 parameters)
at System.Web.Mvc.ControllerActionInvoker.<>c__DisplayClass15.<InvokeActionMethodWithFilters>b__12()
at System.Web.Mvc.ControllerActionInvoker.InvokeActionMethodFilter(IActionFilter filter, ActionExecutingContext preContext, Func`1 continuation)
at System.Web.Mvc.ControllerActionInvoker.InvokeActionMethodFilter(IActionFilter filter, ActionExecutingContext preContext, Func`1 continuation)
at System.Web.Mvc.ControllerActionInvoker.InvokeActionMethodFilter(IActionFilter filter, ActionExecutingContext preContext, Func`1 continuation)
at System.Web.Mvc.ControllerActionInvoker.InvokeActionMethodWithFilters(ControllerContext controllerContext, IList`1 filters, ActionDescriptor actionDescriptor, IDictionary`2 parameters)
at System.Web.Mvc.ControllerActionInvoker.InvokeAction(ControllerContext controllerContext, String actionName)

Nested Exception

Exception: System.Runtime.InteropServices.COMException
Message: Exception from HRESULT: 0x80040E14
Source: CommerceServer.Core.Interop
at CommerceServer.Core.Interop.Profiles.ProfileServiceClass.GetProfileByKey(String bstrKeyMemberName, Object sValue, String bstrType, Boolean bReturnError)
at CommerceServer.Core.Runtime.Profiles.Profile..ctor(ProfileContext profileService, String keyName, String keyValue, String profileType)

  • did you run step 5 and 6?

    1. Configure Profile System Encryption. For more information, go to Generating Profile Encryption Keys
    2. Deploy the \Database\Profiles\Commerce.Storefront.ProfileDatabase.dacpac against the profiles database with the following command. If you are using SQL Server 2012, you will need to change the 120 in the path to be 110. "C:\Program Files (x86)\Microsoft SQL Server\120\DAC\bin\SqlPackage.exe" /Action:Publish /SourceFile:".\Database\Profiles\Commerce.Storefront.ProfileDatabase.dacpac" /TargetDatabaseName:CSSolutionStorefrontSite_profiles /TargetServerName:"127.0.0.1"