R10 Subscriptions Error

[egormsen]

When testing out R10 build I am getting on error when going into an User Account and clicking on the "Subscriptions" tab.

Here is the error. Any suggestions on what is wrong?

Code: Select all

Server Error in '/' Application.

Compilation Error

Description: An error occurred during the compilation of a resource required to service this request. Please review the following specific error details and modify your source code appropriately. 

Compiler Error Message: CS0246: The type or namespace name 'SubscriptionDetailEventArgs' could not be found (are you missing a using directive or an assembly reference?)

Source Error:


Line 129:        }
Line 130:
Line 131:        void control_OnEditShipAddress(object sender, SubscriptionDetailEventArgs e)
Line 132:        {
Line 133:            Subscription subscription = SubscriptionDataSource.Load(e.SubscriptionId);

Source File: c:\inetpub\wwwroot\newdevstore\Members\MySubscriptions.aspx.cs    Line: 131 

Here are the details from the about page

AbleCommerce for ASP.NET
VERSION: 7.0.90.8302
Release Label: GoldR10
DATABASE: NHibernate.Dialect.MsSql2005Dialect
.NET CLR v4.0.30319.18444
ASP.NET TRUST: Unrestricted

AbleMods.QuickBooks: 1.3.0.0
AblePlugins.FedEx: 7.8.4666.21205
AjaxControlToolkit: 4.1.51116.0
AntiXssLibrary: 4.0.0.0
Castle.Core: 2.5.1.0
Castle.Windsor: 2.5.1.0
CommerceBuilder: 7.90.5653.31460
CommerceBuilder.AcTestProvider: 7.89.5365.28134
CommerceBuilder.Amazon: 7.89.5365.28138
CommerceBuilder.AustraliaPost: 7.89.5365.28134
CommerceBuilder.AuthorizeNet: 7.89.5365.28137
CommerceBuilder.AuthorizeNetCIM: 7.89.5365.28139
CommerceBuilder.AvaTax: 7.89.5365.28137
CommerceBuilder.BankOfCanada: 7.89.5365.28135
CommerceBuilder.CanadaPost: 7.89.5365.28135
CommerceBuilder.CyberSource: 7.89.5365.28137
CommerceBuilder.DHLInternational: 7.89.5365.28135
CommerceBuilder.ECB: 7.89.5365.28135
CommerceBuilder.GoogleCheckout: 7.89.5365.28138
CommerceBuilder.InternetSecure: 7.89.5365.28136
CommerceBuilder.Licensing: 7.90.5553.2248
CommerceBuilder.LinkPoint: 7.89.5365.28136
CommerceBuilder.Paradata: 7.89.5365.28136
CommerceBuilder.PayFlowPro: 7.89.5365.28136
CommerceBuilder.PayJunction: 7.89.5365.28136
CommerceBuilder.PaymentechOrbital: 7.89.5365.28137
CommerceBuilder.PayPal: 7.90.5539.28703
CommerceBuilder.Protx: 7.89.5365.28137
CommerceBuilder.SkipJack: 7.89.5365.28136
CommerceBuilder.TaxCloud: 7.90.5540.28571
CommerceBuilder.UI: 7.90.5553.2248
CommerceBuilder.UPS: 7.89.5365.28138
CommerceBuilder.USPS: 7.90.5539.28688
CommerceBuilder.Utility.Csv: 8.0.0.0
CommerceBuilder.WATax: 7.89.5365.28136
CommerceBuilder.WebApi: 7.89.5553.2249
CuteChat: 5.1.0.0
CuteChat.AppCode: 5.1.0.0
CyberSource.Base: 2.0.0.0
CyberSource.Clients: 5.0.2.0
CyberSource.Clients.XmlSerializers: 5.0.2.0
CyberSource.WSSecurity: 2.0.0.0
CybsWSSecurityIOP: 1.0.0.0
HtmlSanitizationLibrary: 4.0.0.0
ICSharpCode.SharpZipLib: 0.86.0.518
Iesi.Collections: 1.0.1.0
log4net: 1.2.10.0
Lucene.Net: 2.9.4.2
Microsoft.Data.Edm: 5.1.0.0
Microsoft.Data.OData: 5.1.0.0
Microsoft.Data.OData.Contrib: 5.1.0.0
Microsoft.Web.Infrastructure: 1.0.0.0
Microsoft.Web.Mvc: 2.0.0.0
MvcContrib: 2.0.95.0
Newtonsoft.Json: 4.5.0.0
NHibernate: 3.3.1.4000
NHibernate.ByteCode.Castle: 3.1.0.4000
NHibernate.Caches.SysCache: 3.3.3.4000
NHibernate.Search: 2.0.2.4000
NVelocity: 7.2.0.0
PaygatewayNET: 3.0.0.0
paypal_base: 4.2.1.0
PayPalCoreSDK: 1.4.1.0
PayPalMerchantSDK: 2.7.109.0
SanitizerProviders: 1.0.0.0
System.Net.Http: 4.0.0.0
System.Net.Http.Formatting: 4.0.0.0
System.Spatial: 5.1.0.0
System.Web.Http: 4.0.0.0
System.Web.Http.OData: 0.2.0.0
System.Web.Http.WebHost: 4.0.0.0
System.Web.Mvc: 4.0.0.0
System.Web.Razor: 2.0.0.0
System.Web.WebPages: 2.0.0.0
System.Web.WebPages.Deployment: 2.0.0.0
System.Web.WebPages.Razor: 2.0.0.0
TimePicker: 1.0.0.0
VM.xPort.Ds2xl: 3.7.0.0
wwHoverPanel: 1.85.0.0

[nadeem]

Are you using WAP version of Gold R10 and have you made any customisation? If yes, then you need to open the solution in visual studio and compile the project. Fix any compilation errors and then access the page. It looks like a compilation issue.

[egormsen]

It does seem like a compilation problem, but I am not using WAP version, using WSP.

No customizations on this page and we don't have the Commerce Builder source code. It builds fine it builds fine, just getting this runtime error.

[egormsen]

I have a found a workaround.

On my dev site I was able to get some more info and found that there was an error in the aspx code behind page on line 67. For this account there is an inactive subscription it looks the price is empty and therefore was causing the page to error out.

So I updated line 67 MySubscription.aspx.cs to check for a null value like this:

Code: Select all

<asp:Label ID="ItemPrice" runat="server" Text='<%#(Eval("OrderItem.Price")==null ? "0" : ((decimal)Eval("OrderItem.Price")).LSCurrencyFormat("ulc"))%>' CssClass="price"></asp:Label>

Now all is good.

I am not sure if I am working around a system of a earlier problem or this should be considered a permanent fix. Hopefully Able this can fixed for the next release.

[nadeem]

I am wondering how NULL value is entered to a NOT NULL column. We have 'Price' column in ac_OrderItems table which didn't allows NULL. If a free subscription is purchased, the price will be saved as '0.0000' in database. Therefore, I don't think we need to fix this as the price will never be null.

[egormsen]

How can you say nothing needs to be fixed when there is a crash on your page?

Whatever the root of what is causing then problem I do not know since I do nave the CommerceBuilder source, but something is obviously not right.

I did check the ac_Subscription table for user where the page was crashing and in the table it had a subscription where the OrderItemId is null, therefore it will never be getting a record from ac_OrderItems. There are 67 other users that have this same situation.

[nadeem]

I am sorry for the sort of misunderstanding and confusion. As you mentioned previously that the Price is NULL, this make me think the price can't be null as the column doesn't allows null. Now you have pointed out that the OrderItemId is null in ac_Subscription table, I have to dig into this more to see what's going wrong.

Can you please let me know which Ablecommerce version you are upgraded from?