R10 Upgrade Error

[egormsen]

We have been working on our R10 upgrade for a few weeks and have run into a problem when testing with a recent copy of our production database.

When we first started we did a full clean install of R10, and we made a copy our production database and everything went smooth.

Now that we are getting ready to go live with it I wanted to test with a recent copy of our production database so I loaded a recent backup into the test environment, but now when I try login into the admin area I get the following error. I was prompted for the login, but as soon

I was able to step into a the code a bit and it looks like I get logged in ok, but eventually I reach a point where I can not step in an further and get get this message.

Any ideas on what went wrong?

Code: Select all

Object reference not set to an instance of an object.

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. 

Exception Details: System.NullReferenceException: Object reference not set to an instance of an object.

Source Error: 

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Stack Trace: 


[NullReferenceException: Object reference not set to an instance of an object.]
   CommerceBuilder.Payments.PaymentRepository.BeforeSave(Object entity) +1078
   CommerceBuilder.DomainModel.SaveOrUpdateEventListener.PerformSaveOrUpdate(SaveOrUpdateEvent event) +241
   NHibernate.Event.Default.DefaultSaveOrUpdateEventListener.OnSaveOrUpdate(SaveOrUpdateEvent event) +381
   NHibernate.Impl.SessionImpl.FireSaveOrUpdate(SaveOrUpdateEvent event) +391
   NHibernate.Impl.SessionImpl.SaveOrUpdate(String entityName, Object obj) +389
   NHibernate.Engine.Cascade.CascadeToOne(Object parent, Object child, IType type, CascadeStyle style, Object anything, Boolean isCascadeDeleteEnabled) +226
   NHibernate.Engine.Cascade.CascadeCollectionElements(Object parent, Object child, CollectionType collectionType, CascadeStyle style, IType elemType, Object anything, Boolean isCascadeDeleteEnabled) +566
   NHibernate.Engine.Cascade.CascadeCollection(Object parent, Object child, CascadeStyle style, Object anything, CollectionType type) +274
   NHibernate.Engine.Cascade.CascadeOn(IEntityPersister persister, Object parent, Object anything) +600
   NHibernate.Event.Default.AbstractFlushingEventListener.CascadeOnFlush(IEventSource session, IEntityPersister persister, Object key, Object anything) +156
   NHibernate.Event.Default.AbstractFlushingEventListener.PrepareEntityFlushes(IEventSource session) +372
   NHibernate.Event.Default.AbstractFlushingEventListener.FlushEverythingToExecutions(FlushEvent event) +249
   NHibernate.Event.Default.DefaultFlushEventListener.OnFlush(FlushEvent event) +160
   NHibernate.Impl.SessionImpl.Flush() +500
   NHibernate.Transaction.AdoTransaction.Commit() +604
   CommerceBuilder.Common.DatabaseSessionManager.CommitTransaction(Boolean ignoreNoTransactionError) +132
   CommerceBuilder.Services.HttpModule.a(Object A_0, EventArgs A_1) +3003
   System.Web.SyncEventExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() +91
   System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) +164

While stepping thru the code I did get to the about info, and there is what is in that string.

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

[Katie]

Hello,

What version are you upgrading from? I have to wonder if the upgrade on the new backup didn't get applied. Can you provide any more details on the error and what page you are trying to access?

Thanks,
Katie

[egormsen]

We are upgrading from R8.

I was trying to access the admin page. It directed me to the login page and

Is there something I can do to check the database to see if the updates were applied?

I do not have any other details, that was all that was displayed. If there is something I could do to get more details let me know.

Eldon

[egormsen]

I went and check the R9 and R10 upgrade docs for the DB changes, all the changes except for one column listed in the R9 docs was not where. I went ahead and added that column, but still getting the same error.

Here is what I checked
The R10 docs show the following DB changes - I verified that they all have been

New field added to ac_OptionChoices table
MsrpModifier DECIMAL(10,2) NULL
VariantName field size changed from 255 to 500 characters in ac_OrderItems table

New field added to ac_OrderShipments table
ShipStationId INT NULL

New field added to ac_Products table
TIC int NULL

VariantName field sized changed from 255 to 500 characters in ac_ProductVariants table

Six new fields added to ac_ProductVariants table
MSRP DECIMAL(12,4) NULL
ModelNumber NVARCHAR(40) NULL
[Length] DECIMAL(12,4) NULL
Width DECIMAL(12,4) NULL
Height DECIMAL(12,4) NULL
HandlingCharges DECIMAL(10,2) NULL

New field added to ac_GatewayPaymentProfiles table
PaymentMethodName nvarchar(255) NULL

The R9 upgrade docs show the following db changes, three of the 4 where already done (UseShopBy had been addded to ac_OrderStatusTriggers
ac_InputFields Table
column added: UseShopBy BIT DEFAULT 0 NOT NULL

ac_OrderStatusTriggers Table
column added: UseShopBy BIT DEFAULT 0 NOT NULL

ac_OrderStatusTriggers Table
primary key column added: OrderStatusTriggerId INT IDENTITY NOT NULL

ac_Payments Table
column added: GatewayPaymentProfileId INT NULL

[egormsen]

I was able to figure it out. I checked the app log file and it had some more details on the error. Currently we are using Web 2 Market plugin for storing the credit card info, but now that is supported in AC Gold we are going to the use that. I had removed all references to it in the code and associated dll's when doing the migration. But now when I tried to test against a current database the Web 2 Market info was still the ac_PaymentGateways table, I deleted that line and everything came up fine.

One question - the DB change from R9 that was missing - once we go live should I make that change in my production database also or is that an error in the docs?

[nadeem]

One question - the DB change from R9 that was missing - once we go live should I make that change in my production database also or is that an error in the docs?

Yes, this seems to be the error in docs. You don't have to be worry about this. Just ignore.