When updating encryption key, there is no update status during the process and the last update at the top of the screen does not change. I've cleared cookies and re-checked.

Hi,

Can you please share some of the detail of the error that is coming after the upgrade? Are all the errors related to a common issue?

Thanks

Shari I'm just seeing your response as I did not get a notification via email on a reply from this forum. After performing the upgrade from 9.0.2 to 9.0.3 I realized that the Encryption key had not been updated since 10/15/2019. My estimated records showed: 12 and Encryption Key last update 10/15/2019.

Process as follows.
1. DB backed up
2. Encryption Key backed up
3. Typed 20 plus characters
4. Clicked on Change Encryption Key button
5. Screen updates but during the update there no process showing the records being updated (Like Gold 12)
6. Screen still shows 12 records and shows last update of 10/15/2019

As a note: this is the first time I had performed the Encryption Key maintenance in Able9 since we launched (My Bad). However, I'm wondering if this was already there from the earlier version. Also, after I upgraded I looked back at Upgrade history and it did not post the last upgrade. As of now I'm getting 500 errors on both available and past upgrades area's through admin.

Hope this helps.
Ricky


Edit: Here is a copy of the errors I was getting yesterday but, not seeing any today. It was up to around 800 reccords.

"Exception: query did not return a unique result: 2
Stack Trace: at NHibernate.Impl.AbstractQueryImpl.UniqueElement(IList list)
at NHibernate.Impl.CriteriaImpl.UniqueResult[T]()
at CommerceBuilder.Users.UserRepository.LoadForUserName(String userName, Boolean createMissing)
at CommerceBuilder.Services.Membership.WebUserLocator.Locate()
at CommerceBuilder.Common.AbleContext.get_User()
at AbleCommerce.Code.ValidatePageAttribute.OnActionExecuting(ActionExecutingContext filterContext)
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.InvokeAction(ControllerContext controllerContext, String actionName)
at System.Web.Mvc.Controller.ExecuteCore()
at System.Web.Mvc.ControllerBase.Execute(RequestContext requestContext)
at System.Web.Mvc.Async.AsyncResultWrapper.<.cctor>b__0(IAsyncResult asyncResult, Action action)
at System.Web.Mvc.Controller.EndExecute(IAsyncResult asyncResult)
at System.Web.Mvc.MvcHandler.<BeginProcessRequest>b__5(IAsyncResult asyncResult, ProcessRequestState innerState)
at System.Web.Mvc.Async.AsyncResultWrapper.WrappedAsyncVoid`1.CallEndDelegate(IAsyncResult asyncResult)
at System.Web.Mvc.MvcHandler.EndProcessRequest(IAsyncResult asyncResult)
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)
"

"Exception: query did not return a unique result: 2
Stack Trace: at NHibernate.Impl.AbstractQueryImpl.UniqueElement(IList list)
at NHibernate.Impl.CriteriaImpl.UniqueResult[T]()
at CommerceBuilder.Users.UserRepository.LoadForUserName(String userName, Boolean createMissing)
at CommerceBuilder.Services.Membership.WebUserLocator.Locate()
at CommerceBuilder.Common.AbleContext.get_User()
at CommerceBuilder.Services.PageTracker.a(HttpApplication A_0, HttpContext A_1)
"

Edited by user Tuesday, November 10, 2020 2:23:45 PM(UTC)  | Reason: more inforamtion

So, after following through the earlier instructions regarding Encryption key install or renew from a earlier post after migration I ran the query on the ac_payments table and it came back with 0 records found. I also checked my App_Data/Encryption key config file and there is a key in it. However, checking further I see there is also a encryption_default.config file in the app directory as well, with no key in it. Is this file supposed to be there?

One last note: I don't know if this is a different problem or if it pertains to encryption issue's but all customer completed orders, under the payment tab, shows (Account Details: Account data storage or SSL has been disabled). I have SSL enabled on the whole site. I'm just a little confused?

Please help.

Thanks again!

EDIT: I have resolved the encryption key update for my circumstances. As it turns out when your subscription expires, your production site will be locked down. This can happen 24 hrs prior to a renewal subscription date. (BE AWARE) won't go into details. However, after renewing the subscription your license details in the Admin side panel will indicate that you are up to date for whatever months ahead i.e.. Now I did not realize that I still needed to install the new License key issued as well. After Installing new License Key I was able to update encryption key.All appears OK at this time.

As far as the User payment tab details (Account Details: Account data storage or SSL has been disabled). It turns out it is only happening with PayPal completed orders. I can either start a new post or have Ablecommerce take a look and see if this is a bug or what needs to be done to fix this.

Thanks Again.

Edited by user Sunday, November 22, 2020 9:49:45 PM(UTC)  | Reason: Resolved Problem