True
False
error.aspx

Technical Problems

Error Details:

  • -1: System.Exception: Error retrieving cart: System.Data.SqlClient.SqlException (0x80131904): A connection was successfully established with the server, but then an error occurred during the login process. (provider: SSL Provider, error: 0 - An existing connection was forcibly closed by the remote host.) ---> System.ComponentModel.Win32Exception (0x80004005): An existing connection was forcibly closed by the remote host at System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, UInt32 waitForMultipleObjectsTimeout, Boolean allowCreate, Boolean onlyOneCheckConnection, DbConnectionOptions userOptions, DbConnectionInternal& connection) at System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal& connection) at System.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection) at System.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions) at System.Data.ProviderBase.DbConnectionClosed.TryOpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions) at System.Data.SqlClient.SqlConnection.TryOpenInner(TaskCompletionSource`1 retry) at System.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource`1 retry) at System.Data.SqlClient.SqlConnection.Open() at ShopVisible.Core.HelperClasses.cFunctions.getRS(String sql, String& ErrorDesc) in D:\working\ShopVisible.v2\Ver\Shoplogic\20150629\ShopVisible.Shoplogic\ShopVisible.Core.HelperClasses\cFunctions.vb:line 487 ClientConnectionId:b8938579-540c-4182-962d-4b96c26022dc Error Number:10054,State:0,Class:20, sql: EXECUTE dbo.sp_executesql N'select distinct cart.ReserveInventory, d.dept_alt, d.dept_alias, files.original_url,brand.brand + '' '' + product.product_code as Product, product.product_id, cartCreateDate,isnull(AllowedCartQty,0) as MaxCartQty,Product.EditorsChoice,Product.Recycled,Product.NextPurchaseOn, Product.NextPurchaseOnPeriod, Product.next_SelectList, product.part_no,Product.FreeShipping, Product.xtra1,Product.xtra2,Product.xtra3,Product.xtra4,Product.xtra5,Product.xtra6,Product.xtra7,Product.xtra8,Product.xtra9,Product.xtra10,brand.brand,product.product_code as [Product Name], product.alternate_part_no, product.DisallowGiftWrap ,cart.*, sale, sale_special, wholesale,cart.total as unitPrice,(cart.quantity * cart.total) as TotalWithQuantity, replace(replace(replace(isnull(cart.option1,''''),''='','': ''),''
    '',''
    ''),'' '',''
    '') as ProductOptions, price.domesticShippingOverride, product.imagepath as productImage, islimited, product.customText, case when isnull(cart.option2, '''') = '''' then product.imagepath else case isnull(optionInformation.product_option_image, '''') when '''' then product.imagepath else optionInformation.product_option_image end end as imagepath, optionInformation.product_option_value Option_Part_No, optionInformation.alternate_part_no Option_Alternate_Part_No, ((case when isnull(cart.option2, '''') = '''' then Product.Quantity else optionInformation.product_option_quantity end) + (case when cart.ReserveInventory=1 then cart.Quantity else 0 end)) as AvailableQuantity, (select subbrand_name from dbo.brand_subbrand where subbrand_id = product.subbrand_id) as SubBrand_Name, stockstatus.StockStatus_Desc as ProductStatus, price.MSRP, price.salestartdatetime, price.saleenddatetime, (select stockstatus_desc from dbo.stockstatus where stockstatus_id in (optionInformation.InventoryStatus_ID)) as OptionStatus, Price.wholesaleOnSale, Price.wholesaleOnSaleStartDate, Price.wholesaleOnSaleEndDate from dbo.cart with (nolock) inner join dbo.product on product.Product_ID=cart.Product_ID inner join dbo.price with (nolock) on product.product_id=price.product_id inner join dbo.brand with (nolock) on brand.Brand_ID=product.Brand_ID inner join dbo.departments d with (nolock) on d.dept_id=product.dept_id inner join dbo.Files with (nolock) on Files.Product_ID=product.product_id and files.dept_id = product.dept_id left join dbo.stockstatus with (nolock) on product.stockstatus_id = stockstatus.StockStatus_ID left join (select product_option_value, alternate_part_no, product_option_image, InventoryStatus_ID, product_option_quantity, product_option.product_option_id as id from dbo.product_option with (nolock)) as optionInformation on optionInformation.id = cart.OptionId where Session_ID=@Session_ID and FileType_ID in (1,11,21) and filetype_id=1 OPTION (KEEPFIXED PLAN)', N'@Session_ID varchar(50)', @Session_ID = 'gf3he4s3pavnwfndq05d1nqa'; at ShopVisible.Core.ParsingEngine.cartFunctions.getCart(String sessionID, String sortOrder, String& errorResponse, Boolean wasAGroupProductCouponApplied) in d:\working\ShopVisible.v2\Ver\Shoplogic\20150629\ShopVisible.Shoplogic\ShopVisible.Core.ParsingEngine\cartFunctions.cs:line 1052 at ShopVisible.Core.ParsingEngine.cartFunctions.getCart(String sessionID, String sortOrder, String& errorResponse) in d:\working\ShopVisible.v2\Ver\Shoplogic\20150629\ShopVisible.Shoplogic\ShopVisible.Core.ParsingEngine\cartFunctions.cs:line 905 at ShopVisible.Core.ParsingEngine.baseParser.buildPage(String templateToParse) in d:\working\ShopVisible.v2\Ver\Shoplogic\20150629\ShopVisible.Shoplogic\ShopVisible.Core.ParsingEngine\baseParser.cs:line 569
DETAILED ERROR INFORMATION

Server Variables
ALL_HTTPHTTP_CONNECTION:Keep-Alive HTTP_HOST:abbottstore.com
ALL_RAWConnection: Keep-Alive Host: abbottstore.com
APPL_MD_PATH/LM/W3SVC/3/ROOT
APPL_PHYSICAL_PATH\\hostway.shopvisible.com\shopvisible\sites\Abbott\
AUTH_TYPE
AUTH_USER
AUTH_PASSWORD
LOGON_USER
REMOTE_USER
CERT_COOKIE
CERT_FLAGS
CERT_ISSUER
CERT_KEYSIZE
CERT_SECRETKEYSIZE
CERT_SERIALNUMBER
CERT_SERVER_ISSUER
CERT_SERVER_SUBJECT
CERT_SUBJECT
CONTENT_LENGTH0
CONTENT_TYPE
GATEWAY_INTERFACECGI/1.1
HTTPSoff
HTTPS_KEYSIZE
HTTPS_SECRETKEYSIZE
HTTPS_SERVER_ISSUER
HTTPS_SERVER_SUBJECT
INSTANCE_ID3
INSTANCE_META_PATH/LM/W3SVC/3
LOCAL_ADDR172.17.121.186
PATH_INFO/error.aspx
PATH_TRANSLATED\\hostway.shopvisible.com\shopvisible\sites\Abbott\error.aspx
QUERY_STRING
REMOTE_ADDR172.17.13.177
REMOTE_HOST172.17.13.177
REMOTE_PORT53522
REQUEST_METHODGET
SCRIPT_NAME/error.aspx
SERVER_NAMEabbottstore.com
SERVER_PORT80
SERVER_PORT_SECURE0
SERVER_PROTOCOLHTTP/1.1
SERVER_SOFTWAREMicrosoft-IIS/7.5
URL/error.aspx
HTTP_CONNECTIONKeep-Alive
HTTP_HOSTabbottstore.com
IIS_UrlRewriteModule7.1.0761.0

Session Variables
A technical problem has occurred - http 500 error

Technical Problems

We are currently experiencing technical difficulties on the page you have requested. We apologize for this inconvenience.


If you would like immediate assistance, please contact us at 1-800-258-7677. Thank you.


Click here to return to our home page.

Error Details:

Error is not known
DETAILED ERROR INFORMATION

Server Variables
ALL_HTTPHTTP_CONTENT_LENGTH:0 HTTP_ACCEPT:text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8 HTTP_ACCEPT_ENCODING:x-gzip, gzip, deflate HTTP_ACCEPT_LANGUAGE:en-us,en-gb,en;q=0.7,*;q=0.3 HTTP_HOST:abbottstore.com HTTP_USER_AGENT:CCBot/2.0 (http://commoncrawl.org/faq/)
ALL_RAWContent-Length: 0 Accept: text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8 Accept-Encoding: x-gzip, gzip, deflate Accept-Language: en-us,en-gb,en;q=0.7,*;q=0.3 Host: abbottstore.com User-Agent: CCBot/2.0 (http://commoncrawl.org/faq/)
APPL_MD_PATH/LM/W3SVC/3/ROOT
APPL_PHYSICAL_PATH\\hostway.shopvisible.com\shopvisible\sites\Abbott\
AUTH_TYPE
AUTH_USER
AUTH_PASSWORD
LOGON_USER
REMOTE_USER
CERT_COOKIE
CERT_FLAGS
CERT_ISSUER
CERT_KEYSIZE
CERT_SECRETKEYSIZE
CERT_SERIALNUMBER
CERT_SERVER_ISSUER
CERT_SERVER_SUBJECT
CERT_SUBJECT
CONTENT_LENGTH0
CONTENT_TYPE
GATEWAY_INTERFACECGI/1.1
HTTPSoff
HTTPS_KEYSIZE
HTTPS_SECRETKEYSIZE
HTTPS_SERVER_ISSUER
HTTPS_SERVER_SUBJECT
INSTANCE_ID3
INSTANCE_META_PATH/LM/W3SVC/3
LOCAL_ADDR172.17.125.186
PATH_INFO/500.aspx
PATH_TRANSLATED\\hostway.shopvisible.com\shopvisible\sites\Abbott\500.aspx
QUERY_STRING500;http://abbottstore.com:80/core/product.aspx?prod=530&dept=90
REMOTE_ADDR54.234.129.215
REMOTE_HOST54.234.129.215
REMOTE_PORT42916
REQUEST_METHODGET
SCRIPT_NAME/500.aspx
SERVER_NAMEabbottstore.com
SERVER_PORT80
SERVER_PORT_SECURE0
SERVER_PROTOCOLHTTP/1.0
SERVER_SOFTWAREMicrosoft-IIS/7.5
URL/500.aspx
HTTP_CONTENT_LENGTH0
HTTP_ACCEPTtext/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8
HTTP_ACCEPT_ENCODINGx-gzip, gzip, deflate
HTTP_ACCEPT_LANGUAGEen-us,en-gb,en;q=0.7,*;q=0.3
HTTP_HOSTabbottstore.com
HTTP_USER_AGENTCCBot/2.0 (http://commoncrawl.org/faq/)
IIS_UrlRewriteModule7.1.0761.0

Session Variables