Cannot add UPS as a carrier

For general questions and discussions specific to the AbleCommerce GOLD ASP.Net shopping cart software.
Post Reply
bhill
Lieutenant Commander (LCDR)
Lieutenant Commander (LCDR)
Posts: 84
Joined: Mon Oct 31, 2005 5:06 pm
Location: Institute

Cannot add UPS as a carrier

Post by bhill » Fri Dec 17, 2021 1:09 pm

Maybe someone can help us out. Our UPS methods stopped showing up and I needed to switch it to a different UPS account so I removed the carrier completely. Now I cannot even add UPS back as a carrier.

When I try to add it back by clicking the link ( https://oursite.org/Admin/Shipping/Prov ... fault.ashx ) I'm sent to this page: https://oursite.org/Admin/Shipping/Prov ... cense.aspx and get the notification:
We are sorry, but the page you are trying to access has experienced an error.
Please contact us to report this problem.

The error log is showing the error below. So we have no UPS methods at Christmas, please advise. Release Label: GoldR12 VERSION: 7.0.92.9168

An error has occured at https://oursite.com/Admin/Shipping/Prov ... cense.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 request was aborted: Could not create SSL/TLS secure channel.Inner Exception Stack Trace: at System.Net.HttpWebRequest.GetResponse() at CommerceBuilder.Shipping.Providers.UPS.UPS.SendRequestToProviderWithoutCredentials(XmlDocument request, String url) at CommerceBuilder.Shipping.Providers.UPS.UPS.GetAgreement(String countryCode, String languageCode) 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)

nadeem
Captain (CAPT)
Captain (CAPT)
Posts: 258
Joined: Tue Jul 31, 2012 7:23 pm

Re: Cannot add UPS as a carrier

Post by nadeem » Mon Jan 03, 2022 11:34 am

Hi,

Are you able to figure this out? If not, let me know so that I can look into this for you.

This old forums aren't viewed frequently since we have new forums where you can post your Gold issues/questions here https://ablecommerce.com/forums/topics/ ... sions-only

Thanks!

nadeem
Captain (CAPT)
Captain (CAPT)
Posts: 258
Joined: Tue Jul 31, 2012 7:23 pm

Re: Cannot add UPS as a carrier

Post by nadeem » Fri Jan 07, 2022 6:53 am

Firstly, you need to make sure the TLS is enabled on the server where your site is hosted. If not, you can apply the following code updates/patch to fix the TLS issue http://help.ablecommerce.com/FAQs/AbleC ... LS_1.2.htm

Once the TLS issue is fixed, you will get another error due to the UPS license url change. The error could be something like this:

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)


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:

INSERT INTO ac_ShipGateways (StoreId, Name, ClassId, ConfigData, ReCrypt, Enabled)
VALUES (1, 'UPS OnLine® Tools', 'CommerceBuilder.Shipping.Providers.UPS.UPS, CommerceBuilder.UPS', 'UseDebugMode=True&UserId={VALUE}&Password={VALUE}&AccessKey={VALUE}&ShipperNumber={VALUE}&CustomerType=2&UseInsurance=False&UseTestMode=False&AccountActive=False&EnablePackageBreakup=True&MinPackageWeight=0.10&MaxPackageWeight=150.00&TestModeUrl=https://wwwcie.ups.com/ups.app/xml/&Liv ... ceLiveUrl=', 0, 1)

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.

bhill
Lieutenant Commander (LCDR)
Lieutenant Commander (LCDR)
Posts: 84
Joined: Mon Oct 31, 2005 5:06 pm
Location: Institute

Re: Cannot add UPS as a carrier

Post by bhill » Fri Feb 18, 2022 4:40 pm

Thank you for the reply! The server is setup for TLS 1.2 and the query you posted worked for adding UPS back as a carrier.
However the rates are still not showing in the cart. The registry key for TSL 1.2 was missing in the winhttp folder but 1.2 was showing in the registry. So I applied the MS easyfix. Possibly I need to restart the server. The error is:

Error obtaining rate quote for shipping method 'UPS Ground'.
Exception: The request was aborted: Could not create SSL/TLS secure channel.Stack Trace: at System.Net.HttpWebRequest.GetResponse() at CommerceBuilder.Shipping.Providers.UPS.UPS.SendRequestToProvider(XmlDocument request, String url) at CommerceBuilder.Shipping.Providers.UPS.UPS.GetAllProviderShipRateQuotes(Warehouse origin, Address destination, IList`1 contents) at CommerceBuilder.Shipping.Providers.UPS.UPS.GetShipRateQuote(Warehouse origin, Address destination, IList`1 contents, String serviceCode) at CommerceBuilder.Shipping.Providers.ShippingProviderBase.GetShipRateQuote(IShipment shipment, String serviceCode) at CommerceBuilder.Shipping.ShipMethod.GetShipRateQuote(IShipment shipment)

nadeem
Captain (CAPT)
Captain (CAPT)
Posts: 258
Joined: Tue Jul 31, 2012 7:23 pm

Re: Cannot add UPS as a carrier

Post by nadeem » Mon Feb 21, 2022 5:44 am

Yes, this error is related to the SSL/TLS not enabled. If restarting the server didn't work, you can apply the following workaround to enable the TLS 1.2 for the application http://help.ablecommerce.com/FAQs/AbleC ... LS_1.2.htm

Secondly, please confirm your UPS Rating URL is https://onlinetools.ups.com/ups.app/xml/ instead of https://www.ups.com/ups.app/xml/
Here are more details about this:
http://help.ablecommerce.com/#t=upgrade ... rhsyns=%20

Post Reply