Hello -

About a month ago, I migrated an AC Gold R10 site to a new web server, but the database server remained the same. I somehow forgot to restore the encryption key, so I ended up manually re-adding the Payment settings for PayPal and everything seems to be working great since then. Today, the client requested we re-enable UPS 3-day shipping (it was set to Admins only) however it seems as though the UPS User/Key information gets stored in the encryption key and so I'm unable to use that service.

1) Tried deleting UPS as a carrier and re-adding, however, the page errors out when trying to open the License page at https://www.site.com/adm...viders/UPS/License.aspx. The error is:

An error has occured at https://www.site.com/Adm...oviders/UPS/License.aspx
Exception: Exception of type 'System.Web.HttpUnhandledException' was thrown.Stack Trace: at System.Web.UI.Page.HandleError(Exception e) at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) at System.Web.UI.Page.ProcessRequest(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) at System.Web.UI.Page.ProcessRequest() at System.Web.UI.Page.ProcessRequest(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) Inner Exception: The 'br' start tag on line 9 position 31 does not match the end tag of 'H2'. Line 10, position 3.Inner Exception Stack Trace: at System.Xml.XmlTextReaderImpl.Throw(Exception e) at System.Xml.XmlTextReaderImpl.ThrowTagMismatch(NodeData startTag) at System.Xml.XmlTextReaderImpl.ParseEndElement() at System.Xml.XmlTextReaderImpl.ParseElementContent() at System.Xml.XmlLoader.LoadNode(Boolean skipOverWhitespace) at System.Xml.XmlLoader.LoadDocSequence(XmlDocument parentDoc) at System.Xml.XmlDocument.Load(XmlReader reader) at System.Xml.XmlDocument.LoadXml(String xml) at CommerceBuilder.Shipping.Providers.UPS.UPS.SendRequestToProviderWithoutCredentials(XmlDocument request, String url) at CommerceBuilder.Shipping.Providers.UPS.UPS.GetAgreement(String countryCode, String languageCode) at CommerceBuilder.Shipping.Providers.UPS.UPS.GetAgreement() at AbleCommerce.Admin.Shipping.Providers._UPS.License.Page_Load(Object sender, EventArgs e) at System.EventHandler.Invoke(Object sender, EventArgs e) at System.Web.UI.Control.OnLoad(EventArgs e) at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)

2) When searching for this error, I see two forum posts relating to a hot patch for R9/R10 to fix a similar issue (http://forums.ablecommerce.com/viewtopic.php?t=19365), as well as an updated URL for UPS rates (http://forums.ablecommerce.com/viewtopic.php?t=19373). Both changes have been implemented and the error persists. I would figure, at the least, I could remove UPS and start from scratch, but this error is preventing that.

3) The old web server is online, so I used my hosts file to point back to it. I can see the UPS account information when I view the Carrier setup page, so that is good. I also have a backup (or can create a new one) of the encryption key on that server. Is it safe to then restore that encryption key to the new server? I haven't made any other payment/shipping related changes on the new box - simply restored what was already setup on the former server. We do capture payments immeidately from PayPal, but not sure if this restore would affect our ability to refund/adjust payments since the move. The only reason I'm considering a restore of the key is that the UPS setup page is erroring out and I need to get some new shipping services implemented.

Thank you for any assistance you can provide.

Greg

Hi Greg,

On further inspection, we have found that the error you are getting is because of the outdated URL being used in the License Agreement page that appears on a new setup of UPS provider.

In this case, an appropriate solution would be to use the encryption key backup to restore the config data for the UPS provider. It will skip the license agreement page and you would be able to visit the config page.

Otherwise, you would have to update the URL in your GOLD R10 sourcecode. To fix this, please follow the steps:


1- Open file \IntegratedProviders\UPS\UPS.cs

2-Search for line # 265


3- Replace with

Also, if the core source code is required and I need to go the restore encryption key route, should I back up the current working version so I can restore if needed? The site is busy this time of year and I’m a bit worried about changing encryption having not done it.

If you've deleted UPS on the new server, there won't be any setup information to decrypt there now, even with the old key, correct? And if you restore the old key on the new system which has already been using a different key, won't that mess up the info encrypted with the new key? The text in the Restore Encryption Key section says "When moving an installation to a different server, you will need to restore your encryption key by providing the backup file below. If you have a newer encryption key already set, then the key currently being used will be replaced with the backup resulting in loss of data. Always use the latest key backup when performing a restore."

EDIT: I'm a bit confused, because you said the database server stayed the same and you deleted UPS, but you also say when you go to the old web server you can still see the UPS info. Those two things seem to contradict each other.

Edited by user Thursday, December 16, 2021 11:04:09 AM(UTC)  | Reason: Not specified

Katie, that would only work if the OP is not using an encryption key on the new server, or removed encryption before updating, correct?

EDIT: changed "inserting" to "updating".

Edited by user Thursday, December 16, 2021 11:40:56 AM(UTC)  | Reason: Not specified

Hi Greg,

If you have already deleted the UPS gateway from the database, then you have to insert new gateway instead of updating. To do so, you have to execute the following query on your database:



Make sure to replace the {VALUE} in the query with correct values for UserId, Password, AccessKey and ShipperNumber respectively. This will bypass license agreement page and you will be able to access the UPS configuration page in admin without any issues.

Hope this helps!

Let me know if you have any question(s).

Thank you!

Hi all -

Thank you very much for the assistance. Using the scripts provided, we're now back in business with UPS and I'll be working with our client to plan an upgrade for early next year so we can avoid issues like this. Happy Holidays!

Greg