AC7 to Gold upgrade error.

[Clueless]

Hello All
I am trying to upgrade a AC 7.0.7 site to Gold. The site was originally AC 7.0.5 and upgraded to AC 7.0.7 without any issues. Now when I am trying to upgrade the site to AC Gold I can get to the agreement page and then fill in all the license key select the AC 7.0.7 database and then click on the "This is an existing AC 7 Database". The process runs for a little bit but then throws this error.

Anyone with any idea as to what is throwing this error would be my hero.

Thanks

Server Error in '/' Application.
________________________________________
null id in CommerceBuilder.Catalog.Webpage entry (don't flush the Session after an exception occurs)
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: NHibernate.AssertionFailure: null id in CommerceBuilder.Catalog.Webpage entry (don't flush the Session after an exception occurs)

Stack Trace:

[AssertionFailure: null id in CommerceBuilder.Catalog.Webpage entry (don't flush the Session after an exception occurs)]
NHibernate.Event.Default.DefaultFlushEntityEventListener.CheckId(Object obj, IEntityPersister persister, Object id, EntityMode entityMode) +193
NHibernate.Event.Default.DefaultFlushEntityEventListener.GetValues(Object entity, EntityEntry entry, EntityMode entityMode, Boolean mightBeDirty, ISessionImplementor session) +80
NHibernate.Event.Default.DefaultFlushEntityEventListener.OnFlushEntity(FlushEntityEvent event) +96
NHibernate.Event.Default.AbstractFlushingEventListener.FlushEntities(FlushEvent event) +294
NHibernate.Event.Default.AbstractFlushingEventListener.FlushEverythingToExecutions(FlushEvent event) +175
NHibernate.Event.Default.DefaultFlushEventListener.OnFlush(FlushEvent event) +80
NHibernate.Impl.SessionImpl.Flush() +211
CommerceBuilder.Common.DatabaseSessionManager.BeginTransaction(IsolationLevel isolationLevel) +56
CommerceBuilder.Common.DatabaseSessionManager.BeginTransaction() +8
CommerceBuilder.Stores.StoreSettingsManager.Save() +686
Install_Upgrade.UpgradeButton_Click(Object sender, EventArgs e) +1098
System.Web.UI.WebControls.Button.OnClick(EventArgs e) +118
System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument) +112
System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +10
System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +13
System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +36
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +5563

[Katie]

Hi there,

I've asked someone from our dev team to look into this error. In the meantime, can you confirm that you are upgrading from 7.0.7 to AbleCommerce Gold R6?

Thanks
Katie

[Clueless]

Hi Katie
Yes I was going from AbleCommerce 7.0.7 to AC Gold R6.

Thanks

[Katie]

I wanted to let you know that we are still looking into this. The dev team re-tested the upgrade from 7.0.5 to 7.0.7 to Gold, and we didn't have any trouble. So, we are looking more closely at the error that you are getting. This must have something to do with webpages. Did you have a lot of them, and do you by chance know if they are assigned to categories, multiple categories, or no category at all?

Thanks for your patience. I'm sure we'll figure this out, we just need a little more time.

[jmestep]

I just got a don't flush the session error upgrading from Gold R4 to R6, but I went to the admin and store anyway and everything seems to be OK.
Mine as null id in CommerceBuilder.Catalog.CustomUrl entry (don't flush the Session after an exception occurs).

[Katie]

Strange. Maybe it has nothing to do with Webpages after all. The"don't flush session" error seems like the problem now. I will update and let our dev team know.

[Clueless]

Hmmmm I did not try to go to the admin screen after I go the error, I was unsure of what it meant. I am setting up a test site to play around with this some more.

Thanks ladies.

[jmestep]

I have learned from upgrades that an error message doesn't automatically mean the upgrade didn't work, so I always go to the admin and start checking the site for things I know changed to see if they are working. In this case, we had done an R4 to R6 upgrade of a copy of the database to get a dev site set up so I knew the dev site had been OK.
Katie, a few times in the past I have got an error like that only with different items. I think one was in adding something to the wishlist in an older Gold site and when I put a try/catch around it, I got around it. I think the product was getting added OK, but something wasn't happening after that. This was a live site, so that is why I put the try/catch in when I found out it really was working OK. I think I reported the bug, but this has been a long time ago.

[mazhar]

We did some inspection and this seems to be just a side effect of the real exception. According to stack trace CommerceBuilder.Stores.StoreSettingsManager.Save() +686
it started from StoreSettingsManager.Save method. What we are seeing in posted exception happens when some unhandled exception occur and application continue with nhibernate flush. This may leads to something similar posted in this thread. We were not able to reproduce the case in our tests and it seems something very random. We made some updates to upgrade.aspx code where we have some doubt about few store settings being handled. I think your install should be good and you should be able to access your store as Judy mentioned her case. Alternativly you can try to apply following change to your upgrade page and try it again.

Edit Website/Install/Upgrade.aspx.cs file and locate following lines of code

Code: Select all

store.StoreUrl = GetStoreUrl();
store.Settings.Save();

and update it like

Code: Select all

string storeUrl = GetStoreUrl();
                store.StoreUrl = storeUrl;
                string storeUrlKey = "Store_StoreUrl";
                StoreSetting storeUrlSt = settings.Find<StoreSetting>(delegate(StoreSetting s) { return s.FieldName == storeUrlKey; });
                if (storeUrlSt == null)
                {
                    storeUrlSt = new StoreSetting(AbleContext.Current.Store, storeUrlKey, storeUrl);
                    store.Settings.Add(storeUrlSt);
                }
                else
                {
                    storeUrlSt.FieldValue = storeUrl;
                }
                storeUrlSt.Save();

                //store.Settings.Save();

save the file and try to upgrade again.

[Clueless]

Hello Everyone
Thanks for all the information and the help. I tried your suggestions but I still got the same error. Looking in the App.log I see errors like these.

2013-10-27 14:18:11,382 ERROR oNet.AbstractBatcher Could not execute query: INSERT INTO ac_Webpages (StoreId, Name, Summary, Description, ThumbnailUrl, ThumbnailAltText, Layout, Theme, VisibilityId, WebpageTypeId, Title, MetaDescription, MetaKeywords, HtmlHead) VALUES (@p0, @p1, @p2, @p3, @p4, @p5, @p6, @p7, @p8, @p9, @p10, @p11, @p12, @p13); select SCOPE_IDENTITY()
System.Data.SqlClient.SqlException (0x80131904): Invalid column name 'Layout'.
Invalid column name 'WebpageTypeId'.
Invalid column name 'Title'.
Invalid column name 'MetaDescription'.
Invalid column name 'MetaKeywords'.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning()
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlDataReader.ConsumeMetaData()
at System.Data.SqlClient.SqlDataReader.get_MetaData()
at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
at System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior)
at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader()
at NHibernate.AdoNet.AbstractBatcher.ExecuteReader(IDbCommand cmd)



If you want I can send you the App.log

[compunerdy]

I got the same error as the first post 7.0.7 > R6. I tried to view the website after and I am getting this error..

Code: Select all

Server Error in '/' Application.

Invalid column name 'TaxExemptionType'.
Invalid column name 'TaxExemptionReference'.

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.Data.SqlClient.SqlException: Invalid column name 'TaxExemptionType'.
Invalid column name 'TaxExemptionReference'.

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: 


[SqlException (0x80131904): Invalid column name 'TaxExemptionType'.
Invalid column name 'TaxExemptionReference'.]
   System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) +404
   System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning() +412
   System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) +1363
   System.Data.SqlClient.SqlDataReader.ConsumeMetaData() +59
   System.Data.SqlClient.SqlDataReader.get_MetaData() +118
   System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) +6387937
   System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) +6389506
   System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) +538
   System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) +28
   System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) +256
   System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior) +19
   System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader() +23
   NHibernate.AdoNet.AbstractBatcher.ExecuteReader(IDbCommand cmd) +845
   NHibernate.Loader.Loader.GetResultSet(IDbCommand st, Boolean autoDiscoverTypes, Boolean callable, RowSelection selection, ISessionImplementor session) +580
   NHibernate.Loader.Loader.DoQuery(ISessionImplementor session, QueryParameters queryParameters, Boolean returnProxies) +275
   NHibernate.Loader.Loader.DoQueryAndInitializeNonLazyCollections(ISessionImplementor session, QueryParameters queryParameters, Boolean returnProxies) +205
   NHibernate.Loader.Loader.DoList(ISessionImplementor session, QueryParameters queryParameters) +195

[GenericADOException: could not execute query
[ SELECT this_.UserId as UserId118_0_, this_.StoreId as StoreId118_0_, this_.UserName as UserName118_0_, this_.LoweredUserName as LoweredU4_118_0_, this_.Email as Email118_0_, this_.LoweredEmail as LoweredE6_118_0_, this_.AffiliateId as Affiliat7_118_0_, this_.AffiliateReferralDate as Affiliat8_118_0_, this_.PrimaryWishlistId as PrimaryW9_118_0_, this_.PayPalId as PayPalId118_0_, this_.PasswordQuestion as Passwor11_118_0_, this_.PasswordAnswer as Passwor12_118_0_, this_.IsApproved as IsApproved118_0_, this_.IsAnonymous as IsAnony14_118_0_, this_.IsLockedOut as IsLocke15_118_0_, this_.CreateDate as CreateDate118_0_, this_.LastActivityDate as LastAct17_118_0_, this_.LastLoginDate as LastLog18_118_0_, this_.LastPasswordChangedDate as LastPas19_118_0_, this_.LastLockoutDate as LastLoc20_118_0_, this_.FailedPasswordAttemptCount as FailedP21_118_0_, this_.FailedPasswordAttemptWindowStart as FailedP22_118_0_, this_.FailedPasswordAnswerAttemptCount as FailedP23_118_0_, this_.FailedPasswordAnswerAttemptWindowStart as FailedP24_118_0_, this_.TaxExemptionType as TaxExem25_118_0_, this_.TaxExemptionReference as TaxExem26_118_0_, this_.Comment as Comment118_0_ FROM ac_Users this_ WHERE this_.LoweredUserName = @p0 ]
  Name:cp0 - Value:29ee4925-93ca-4dd8-a196-9188e846ea05
[SQL: SELECT this_.UserId as UserId118_0_, this_.StoreId as StoreId118_0_, this_.UserName as UserName118_0_, this_.LoweredUserName as LoweredU4_118_0_, this_.Email as Email118_0_, this_.LoweredEmail as LoweredE6_118_0_, this_.AffiliateId as Affiliat7_118_0_, this_.AffiliateReferralDate as Affiliat8_118_0_, this_.PrimaryWishlistId as PrimaryW9_118_0_, this_.PayPalId as PayPalId118_0_, this_.PasswordQuestion as Passwor11_118_0_, this_.PasswordAnswer as Passwor12_118_0_, this_.IsApproved as IsApproved118_0_, this_.IsAnonymous as IsAnony14_118_0_, this_.IsLockedOut as IsLocke15_118_0_, this_.CreateDate as CreateDate118_0_, this_.LastActivityDate as LastAct17_118_0_, this_.LastLoginDate as LastLog18_118_0_, this_.LastPasswordChangedDate as LastPas19_118_0_, this_.LastLockoutDate as LastLoc20_118_0_, this_.FailedPasswordAttemptCount as FailedP21_118_0_, this_.FailedPasswordAttemptWindowStart as FailedP22_118_0_, this_.FailedPasswordAnswerAttemptCount as FailedP23_118_0_, this_.FailedPasswordAnswerAttemptWindowStart as FailedP24_118_0_, this_.TaxExemptionType as TaxExem25_118_0_, this_.TaxExemptionReference as TaxExem26_118_0_, this_.Comment as Comment118_0_ FROM ac_Users this_ WHERE this_.LoweredUserName = @p0]]
   NHibernate.Loader.Loader.DoList(ISessionImplementor session, QueryParameters queryParameters) +637
   NHibernate.Loader.Loader.ListIgnoreQueryCache(ISessionImplementor session, QueryParameters queryParameters) +23
   NHibernate.Loader.Criteria.CriteriaLoader.List(ISessionImplementor session) +60
   NHibernate.Impl.SessionImpl.List(CriteriaImpl criteria, IList results) +1025
   NHibernate.Impl.CriteriaImpl.List(IList results) +63
   NHibernate.Impl.CriteriaImpl.UniqueResult() +69
   CommerceBuilder.Users.UserRepository.LoadForUserName(String userName, Boolean createMissing) +135
   CommerceBuilder.Services.Membership.WebUserLocator.Locate() +832
   CommerceBuilder.Common.AbleContext.get_User() +95
   CommerceBuilder.Services.PageTracker.Track(HttpApplication application, HttpContext context) +359
   CommerceBuilder.Services.HttpModule.a(Object A_0, EventArgs A_1) +1621
   System.Web.SyncEventExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() +80
   System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) +270

Version Information: Microsoft .NET Framework Version:4.0.30319; ASP.NET Version:4.0.30319.272

[compunerdy]

I did the fix that Mazhar posted and then ran the upgrade again and although there was a few errors it is working now and I can get into admin.. Here are the errors it listed

Code: Select all

Database Upgrade Complete
As part of the upgrade process, a rebuild of your search indexes was started. If you have upgraded a database with lots of data, this could take a few minutes, and the process needs to complete before searches of your store data will be fully functional. You can check on and monitor the progress of the index rebuild by going to the Website > Indexes menu of your merchant administration.

The errors listed below occurred while upgrading the database:

SQL: ALTER TABLE "ac_CatalogNodes" DROP CONSTRAINT "ac_CatalogNodes_PK" 

Error: 'ac_CatalogNodes_PK' is not a constraint. Could not drop constraint. See previous errors.

SQL: ALTER TABLE [ac_Products] ADD PublishFeedAsVariants BIT DEFAULT 0 NOT NULL 

Error: Column names in each table must be unique. Column name 'PublishFeedAsVariants' in table 'ac_Products' is specified more than once.

SQL: ALTER TABLE [ac_ProductVariants] ADD GTIN NVARCHAR(30) NULL 

Error: Column names in each table must be unique. Column name 'GTIN' in table 'ac_ProductVariants' is specified more than once.

SQL: ALTER TABLE [ac_ProductVariants] ADD ImageUrl VARCHAR(255) NULL 

Error: Column names in each table must be unique. Column name 'ImageUrl' in table 'ac_ProductVariants' is specified more than once.

SQL: ALTER TABLE [ac_ProductVariants] ADD ThumbnailUrl VARCHAR(255) NULL 

Error: Column names in each table must be unique. Column name 'ThumbnailUrl' in table 'ac_ProductVariants' is specified more than once.

SQL: ALTER TABLE [ac_ProductVariants] ADD IconUrl VARCHAR(255) NULL 

Error: Column names in each table must be unique. Column name 'IconUrl' in table 'ac_ProductVariants' is specified more than once.

SQL: UPDATE ac_ReviewerProfiles SET Email = 'sara@sample.xyz', DisplayName = 'Sara' WHERE ReviewerProfileId = 1 AND Email = ''; UPDATE ac_ReviewerProfiles SET Email = 'katie@sample.xyz', DisplayName = 'Katie' WHERE ReviewerProfileId = 2 AND Email = 'katie@ablecommerce.com'; UPDATE ac_ReviewerProfiles SET Email = 'joe@sample.xyz', DisplayName = 'Joe' WHERE ReviewerProfileId = 3 AND Email = 'joe@ablecommerce.com'; UPDATE ac_ReviewerProfiles SET Email = 'katy@sample.xyz', DisplayName = 'Katy' WHERE ReviewerProfileId = 4 AND Email = 'katie@ablecommerce.com'; UPDATE ac_ReviewerProfiles SET Email = 'jim@sample.xyz', DisplayName = 'James' WHERE ReviewerProfileId = 5 AND Email = 'jim@ablecommerce.com'; CREATE UNIQUE INDEX ac_ReviewerProfiles_IX1 ON ac_ReviewerProfiles (Email) 

Error: The CREATE UNIQUE INDEX statement terminated because a duplicate key was found for the object name 'dbo.ac_ReviewerProfiles' and the index name 'ac_ReviewerProfiles_IX1'. The duplicate key value is (). The statement has been terminated.
The database has been upgraded.

[jmestep]

It looks like your errors were from running the upgrade twice- the changes were already made to the database so they couldn't be made again. I got those in the past when running one twice because I wasn't sure whether it "took" the first time because of different error messages. I just learned to check the site in spite of the error messages before I ran it again.

[compunerdy]

The first post I made is from running it the first time and it was not working afterwards. When I reran it I then got the second errors I posted but it seems to work fine now.

[Clueless]

Doing some more testing I decided to run the database upgrade script manually on a copy of the database. The script took 8 minutes to run and completed successfully. One glaring thing I saw was that the query has at several times updated 4 million plus records. Looking through the database I can see that the Users table has 4408476, This is exceedingly large by any standards.

Looking at there Admin settings they are not removing any Anonymous users so their users table is huge. When I ran the upgrade through the normal method using the install interface it would time out after a few minutes and then throw the error. Since it took 8 minutes to run the script manually I think that the AbleCommerce install and upgrade routine is getting ahead of itself. It tries to install data before the fields a are created and the reason the fields are not created is because the data to update is so large. This would explain why we are getting the SQL error message that I posted earlier.

This is what I am going to try next. I already have the database manually upgrade. I am going to install with a fresh database and then change the database settings to point to the manually upgraded database and see how that works.

[Katie]

This might help -

http://help.ablecommerce.com/upgrades/a ... enance.htm

[Clueless]

OK I was able to finally able to get it to work. I ran some simple script to remove all of the anonymous users. After that I reindex and shrank that database.

With that done I was able to go through the upgrade steps to get the database from AC 7.0.7 to AC Gold.

To the folks at AbleCommerce I am sure that I can not be the only one with a large database so you may want to look at your upgrade routine and take that into consideration.

Thanks

[Katie]

To the folks at AbleCommerce I am sure that I can not be the only one with a large database so you may want to look at your upgrade routine and take that into consideration.

I added some text to the upgrade document that explains the potential issue with past maintenance routines. I point to a separate document that we have describing the process of applying a patch, manually cleaning the database, or both. I think it is better to take care of this before upgrading since the issue with maintenance should have been corrected in version 7.0.7, and would only be a problem for customers using versions before that.

In any case, it's a good idea to mention this and make sure the database is as clean as possible before moving to Gold. Thanks for bringing this to our attention.

Katie

[Clueless]

Hi Katie
Good advice. I have to admit that the client (and me for not noticing first off) is partly to blame here. In the maintenance settings they and left everything blank so they were not removing anonymous users.

For those of you that get this error message check the App.log in the \App_Data\Logs directory. It can give you better information on what is really going on.

[rmaweb]

Hello All, I am having this problem too doing an upgrade on a dev site using Hostgators windows shared account.

I have made the change mazhar suggested to the upgrade file.


Here is the error output

Code: Select all

Server Error in '/' Application.

null id in CommerceBuilder.Catalog.CustomUrl entry (don't flush the Session after an exception occurs)

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: NHibernate.AssertionFailure: null id in CommerceBuilder.Catalog.CustomUrl entry (don't flush the Session after an exception occurs)

Source Error: 


Line 95:                     storeUrlSt.FieldValue = storeUrl;
Line 96:                 }
Line 97:                 storeUrlSt.Save();
Line 98: 
Line 99:                 //store.Settings.Save();

Source File: \Install\Upgrade.aspx.cs    Line: 97 

Stack Trace: 


[AssertionFailure: null id in CommerceBuilder.Catalog.CustomUrl entry (don't flush the Session after an exception occurs)]
   NHibernate.Event.Default.DefaultFlushEntityEventListener.CheckId(Object obj, IEntityPersister persister, Object id, EntityMode entityMode) +267
   NHibernate.Event.Default.DefaultFlushEntityEventListener.GetValues(Object entity, EntityEntry entry, EntityMode entityMode, Boolean mightBeDirty, ISessionImplementor session) +95
   NHibernate.Event.Default.DefaultFlushEntityEventListener.OnFlushEntity(FlushEntityEvent event) +139
   NHibernate.Event.Default.AbstractFlushingEventListener.FlushEntities(FlushEvent event) +448
   NHibernate.Event.Default.AbstractFlushingEventListener.FlushEverythingToExecutions(FlushEvent event) +303
   NHibernate.Event.Default.DefaultFlushEventListener.OnFlush(FlushEvent event) +161
   NHibernate.Impl.SessionImpl.Flush() +500
   CommerceBuilder.DomainModel.RepositoryWithTypedId`2.Save(TEntity item) +228

[TargetInvocationException: Exception has been thrown by the target of an invocation.]
   System.RuntimeMethodHandle.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor) +0
   System.Reflection.RuntimeMethodInfo.UnsafeInvokeInternal(Object obj, Object[] parameters, Object[] arguments) +76
   System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture) +193
   System.Reflection.MethodBase.Invoke(Object obj, Object[] parameters) +35
   CommerceBuilder.DomainModel.EntityWithTypedId`1.Save() +415
   Install_Upgrade.UpgradeButton_Click(Object sender, EventArgs e) in d:\inetpub\vhosts\catalogdev.scottsbt.com\httpdocs\Install\Upgrade.aspx.cs:97
   System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument) +155
   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +3804

Version Information: Microsoft .NET Framework Version:4.0.30319; ASP.NET Version:4.0.30319.17929

[Katie]

We think that the problem might be due to the SQL version of the original database. If you are using SQL 2000 and want to upgrade to Gold, then you will first need to upgrade the database to SQL 2005 or higher. Then try running the install/upgrade to Gold. We were successful in doing this without having to make the changes in the script that Mazhar provided.

[crockettdunn]

Hi everyone,

I'm experiencing the same failure. Running SQL Server 2008 R2.

The upgrade script fails with

Code: Select all

Server Error in '/' Application.

null id in CommerceBuilder.Catalog.Webpage entry (don't flush the Session after an exception occurs)

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: NHibernate.AssertionFailure: null id in CommerceBuilder.Catalog.Webpage entry (don't flush the Session after an exception occurs)

Source Error: 

The source code that generated this unhandled exception can only be shown when compiled in debug mode. To enable this, please follow one of the below steps, then request the URL:

1. Add a "Debug=true" directive at the top of the file that generated the error. Example:

  <%@ Page Language="C#" Debug="true" %>

or:

2) Add the following section to the configuration file of your application:

<configuration>
   <system.web>
       <compilation debug="true"/>
   </system.web>
</configuration>

Note that this second technique will cause all files within a given application to be compiled in debug mode. The first technique will cause only that particular file to be compiled in debug mode.

Important: Running applications in debug mode does incur a memory/performance overhead. You should make sure that an application has debugging disabled before deploying into production scenario.

Stack Trace: 


[AssertionFailure: null id in CommerceBuilder.Catalog.Webpage entry (don't flush the Session after an exception occurs)]
   NHibernate.Event.Default.DefaultFlushEntityEventListener.CheckId(Object obj, IEntityPersister persister, Object id, EntityMode entityMode) +267
   NHibernate.Event.Default.DefaultFlushEntityEventListener.GetValues(Object entity, EntityEntry entry, EntityMode entityMode, Boolean mightBeDirty, ISessionImplementor session) +95
   NHibernate.Event.Default.DefaultFlushEntityEventListener.OnFlushEntity(FlushEntityEvent event) +139
   NHibernate.Event.Default.AbstractFlushingEventListener.FlushEntities(FlushEvent event) +448
   NHibernate.Event.Default.AbstractFlushingEventListener.FlushEverythingToExecutions(FlushEvent event) +292
   NHibernate.Event.Default.DefaultFlushEventListener.OnFlush(FlushEvent event) +161
   NHibernate.Impl.SessionImpl.Flush() +509
   CommerceBuilder.DomainModel.RepositoryWithTypedId`2.Save(TEntity item) +243

[TargetInvocationException: Exception has been thrown by the target of an invocation.]
   System.RuntimeMethodHandle._InvokeMethodFast(IRuntimeMethodInfo method, Object target, Object[] arguments, SignatureStruct& sig, MethodAttributes methodAttributes, RuntimeType typeOwner) +0
   System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture, Boolean skipVisibilityChecks) +640
   System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture) +38
   System.Reflection.MethodBase.Invoke(Object obj, Object[] parameters) +35
   Install_Upgrade.UpgradeButton_Click(Object sender, EventArgs e) +1750
   System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument) +154
   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +3707

Version Information: Microsoft .NET Framework Version:4.0.30319; ASP.NET Version:4.0.30319.1025

If I try to hit the admin or store, I get the following:

Code: Select all

Server Error in '/' Application.

Invalid column name 'TaxExemptionType'.
Invalid column name 'TaxExemptionReference'.

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.Data.SqlClient.SqlException: Invalid column name 'TaxExemptionType'.
Invalid column name 'TaxExemptionReference'.

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: 


[SqlException (0x80131904): Invalid column name 'TaxExemptionType'.
Invalid column name 'TaxExemptionReference'.]
   System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) +404
   System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning() +412
   System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) +1363
   System.Data.SqlClient.SqlDataReader.ConsumeMetaData() +59
   System.Data.SqlClient.SqlDataReader.get_MetaData() +118
   System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) +6384609
   System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) +6386178
   System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) +538
   System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) +28
   System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) +256
   System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior) +19
   System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader() +23
   NHibernate.AdoNet.AbstractBatcher.ExecuteReader(IDbCommand cmd) +845
   NHibernate.Loader.Loader.GetResultSet(IDbCommand st, Boolean autoDiscoverTypes, Boolean callable, RowSelection selection, ISessionImplementor session) +580
   NHibernate.Loader.Loader.DoQuery(ISessionImplementor session, QueryParameters queryParameters, Boolean returnProxies) +275
   NHibernate.Loader.Loader.DoQueryAndInitializeNonLazyCollections(ISessionImplementor session, QueryParameters queryParameters, Boolean returnProxies) +205
   NHibernate.Loader.Loader.DoList(ISessionImplementor session, QueryParameters queryParameters) +195

[GenericADOException: could not execute query
[ SELECT this_.UserId as UserId121_0_, this_.StoreId as StoreId121_0_, this_.UserName as UserName121_0_, this_.LoweredUserName as LoweredU4_121_0_, this_.Email as Email121_0_, this_.LoweredEmail as LoweredE6_121_0_, this_.AffiliateId as Affiliat7_121_0_, this_.AffiliateReferralDate as Affiliat8_121_0_, this_.PrimaryWishlistId as PrimaryW9_121_0_, this_.PayPalId as PayPalId121_0_, this_.PasswordQuestion as Passwor11_121_0_, this_.PasswordAnswer as Passwor12_121_0_, this_.IsApproved as IsApproved121_0_, this_.IsAnonymous as IsAnony14_121_0_, this_.IsLockedOut as IsLocke15_121_0_, this_.CreateDate as CreateDate121_0_, this_.LastActivityDate as LastAct17_121_0_, this_.LastLoginDate as LastLog18_121_0_, this_.LastPasswordChangedDate as LastPas19_121_0_, this_.LastLockoutDate as LastLoc20_121_0_, this_.FailedPasswordAttemptCount as FailedP21_121_0_, this_.FailedPasswordAttemptWindowStart as FailedP22_121_0_, this_.FailedPasswordAnswerAttemptCount as FailedP23_121_0_, this_.FailedPasswordAnswerAttemptWindowStart as FailedP24_121_0_, this_.TaxExemptionType as TaxExem25_121_0_, this_.TaxExemptionReference as TaxExem26_121_0_, this_.Comment as Comment121_0_ FROM ac_Users this_ WHERE this_.LoweredUserName = @p0 ]
  Name:cp0 - Value:0b31ff3e-bbfe-4d90-9b6c-e1043d9adf00
[SQL: SELECT this_.UserId as UserId121_0_, this_.StoreId as StoreId121_0_, this_.UserName as UserName121_0_, this_.LoweredUserName as LoweredU4_121_0_, this_.Email as Email121_0_, this_.LoweredEmail as LoweredE6_121_0_, this_.AffiliateId as Affiliat7_121_0_, this_.AffiliateReferralDate as Affiliat8_121_0_, this_.PrimaryWishlistId as PrimaryW9_121_0_, this_.PayPalId as PayPalId121_0_, this_.PasswordQuestion as Passwor11_121_0_, this_.PasswordAnswer as Passwor12_121_0_, this_.IsApproved as IsApproved121_0_, this_.IsAnonymous as IsAnony14_121_0_, this_.IsLockedOut as IsLocke15_121_0_, this_.CreateDate as CreateDate121_0_, this_.LastActivityDate as LastAct17_121_0_, this_.LastLoginDate as LastLog18_121_0_, this_.LastPasswordChangedDate as LastPas19_121_0_, this_.LastLockoutDate as LastLoc20_121_0_, this_.FailedPasswordAttemptCount as FailedP21_121_0_, this_.FailedPasswordAttemptWindowStart as FailedP22_121_0_, this_.FailedPasswordAnswerAttemptCount as FailedP23_121_0_, this_.FailedPasswordAnswerAttemptWindowStart as FailedP24_121_0_, this_.TaxExemptionType as TaxExem25_121_0_, this_.TaxExemptionReference as TaxExem26_121_0_, this_.Comment as Comment121_0_ FROM ac_Users this_ WHERE this_.LoweredUserName = @p0]]
   NHibernate.Loader.Loader.DoList(ISessionImplementor session, QueryParameters queryParameters) +637
   NHibernate.Loader.Loader.ListIgnoreQueryCache(ISessionImplementor session, QueryParameters queryParameters) +23
   NHibernate.Loader.Criteria.CriteriaLoader.List(ISessionImplementor session) +60
   NHibernate.Impl.SessionImpl.List(CriteriaImpl criteria, IList results) +1025
   NHibernate.Impl.CriteriaImpl.List(IList results) +63
   NHibernate.Impl.CriteriaImpl.UniqueResult() +69
   CommerceBuilder.Users.UserRepository.LoadForUserName(String userName, Boolean createMissing) +171
   CommerceBuilder.Services.Membership.WebUserLocator.Locate() +1129
   CommerceBuilder.Common.AbleContext.get_User() +103
   CommerceBuilder.Services.PageTracker.Track(HttpApplication application, HttpContext context) +423
   CommerceBuilder.Services.HttpModule.a(Object A_0, EventArgs A_1) +1706
   System.Web.SyncEventExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() +80
   System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) +270

Version Information: Microsoft .NET Framework Version:4.0.30319; ASP.NET Version:4.0.30319.1025

I cleaned up my anonymous users before running the upgrade.

Can you help me troubleshoot?

[crockettdunn]

I found the sql script in the update folder and ran it (the part labeled for 707) on a copy of my site 707, and now there is a different failure. I think I've seen this before and fixed it last year, but don't remember the details. Can anyone help me get unstuck?

Code: Select all

Server Error in '/' Application.

Cannot insert the value NULL into column 'UserId', table 'gold.hgmforkliftparts.com.dbo.ac_Users'; column does not allow nulls. INSERT fails.
The statement has been terminated.

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.Data.SqlClient.SqlException: Cannot insert the value NULL into column 'UserId', table 'gold.hgmforkliftparts.com.dbo.ac_Users'; column does not allow nulls. INSERT fails.
The statement has been terminated.

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: 


[SqlException (0x80131904): Cannot insert the value NULL into column 'UserId', table 'gold.hgmforkliftparts.com.dbo.ac_Users'; column does not allow nulls. INSERT fails.
The statement has been terminated.]
   System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) +404
   System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning() +412
   System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) +1363
   System.Data.SqlClient.SqlDataReader.ConsumeMetaData() +59
   System.Data.SqlClient.SqlDataReader.get_MetaData() +118
   System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) +6384609
   System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) +6386178
   System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) +538
   System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) +28
   System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) +256
   System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior) +19
   System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader() +23
   NHibernate.AdoNet.AbstractBatcher.ExecuteReader(IDbCommand cmd) +845
   NHibernate.Id.InsertSelectDelegate.ExecuteAndExtract(IDbCommand insert, ISessionImplementor session) +83
   NHibernate.Id.Insert.AbstractReturningDelegate.PerformInsert(SqlCommandInfo insertSQL, ISessionImplementor session, IBinder binder) +129

[GenericADOException: could not insert: [CommerceBuilder.Users.User][SQL: INSERT INTO ac_Users (StoreId, UserName, LoweredUserName, Email, LoweredEmail, AffiliateId, AffiliateReferralDate, PrimaryWishlistId, PayPalId, PasswordQuestion, PasswordAnswer, IsApproved, IsAnonymous, IsLockedOut, CreateDate, LastActivityDate, LastLoginDate, LastPasswordChangedDate, LastLockoutDate, FailedPasswordAttemptCount, FailedPasswordAttemptWindowStart, FailedPasswordAnswerAttemptCount, FailedPasswordAnswerAttemptWindowStart, TaxExemptionType, TaxExemptionReference, Comment) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?); select SCOPE_IDENTITY()]]
   NHibernate.Id.Insert.AbstractReturningDelegate.PerformInsert(SqlCommandInfo insertSQL, ISessionImplementor session, IBinder binder) +388
   NHibernate.Persister.Entity.AbstractEntityPersister.Insert(Object[] fields, Object obj, ISessionImplementor session) +277
   NHibernate.Action.EntityIdentityInsertAction.Execute() +208
   NHibernate.Engine.ActionQueue.Execute(IExecutable executable) +46
   NHibernate.Event.Default.AbstractSaveEventListener.PerformSaveOrReplicate(Object entity, EntityKey key, IEntityPersister persister, Boolean useIdentityColumn, Object anything, IEventSource source, Boolean requiresImmediateIdAccess) +850
   NHibernate.Event.Default.AbstractSaveEventListener.SaveWithGeneratedId(Object entity, String entityName, Object anything, IEventSource source, Boolean requiresImmediateIdAccess) +261
   NHibernate.Event.Default.DefaultSaveOrUpdateEventListener.SaveWithGeneratedOrRequestedId(SaveOrUpdateEvent event) +49
   NHibernate.Event.Default.DefaultSaveOrUpdateEventListener.EntityIsTransient(SaveOrUpdateEvent event) +113
   CommerceBuilder.DomainModel.SaveOrUpdateEventListener.PerformSaveOrUpdate(SaveOrUpdateEvent event) +289
   NHibernate.Event.Default.DefaultSaveOrUpdateEventListener.OnSaveOrUpdate(SaveOrUpdateEvent event) +365
   NHibernate.Impl.SessionImpl.FireSaveOrUpdate(SaveOrUpdateEvent event) +395
   NHibernate.Impl.SessionImpl.SaveOrUpdate(Object obj) +383
   CommerceBuilder.DomainModel.RepositoryWithTypedId`2.Save(TEntity item) +101

[TargetInvocationException: Exception has been thrown by the target of an invocation.]
   System.RuntimeMethodHandle._InvokeMethodFast(IRuntimeMethodInfo method, Object target, Object[] arguments, SignatureStruct& sig, MethodAttributes methodAttributes, RuntimeType typeOwner) +0
   System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture, Boolean skipVisibilityChecks) +640
   System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture) +38
   System.Reflection.MethodBase.Invoke(Object obj, Object[] parameters) +35
   CommerceBuilder.Users.UserRepository.a(String A_0) +242
   CommerceBuilder.Services.Membership.WebUserLocator.Locate() +1129
   CommerceBuilder.Common.AbleContext.get_User() +103
   CommerceBuilder.Services.PageTracker.Track(HttpApplication application, HttpContext context) +423
   CommerceBuilder.Services.HttpModule.a(Object A_0, EventArgs A_1) +1706
   System.Web.SyncEventExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() +80
   System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) +270

Any guidance would be greatly appreciated.

--Crockett

[crockettdunn]

oh and running the script in SQL returns some info:

Code: Select all

(222975 row(s) affected)

(630 row(s) affected)
Msg 1776, Level 16, State 0, Line 5
There are no primary or candidate keys in the referenced table 'ac_Addresses' that match the referencing column list in the foreign key 'ac_Addresses_ac_BasketShipments_FK1'.
Msg 1750, Level 16, State 0, Line 5
Could not create constraint. See previous errors.
Msg 1776, Level 16, State 0, Line 6
There are no primary or candidate keys in the referenced table 'ac_Webpages' that match the referencing column list in the foreign key 'ac_Webpages_ac_Categories_FK1'.
Msg 1750, Level 16, State 0, Line 6
Could not create constraint. See previous errors.
Msg 3728, Level 16, State 1, Line 11
'ac_CategoryParents_PK' is not a constraint.
Msg 3727, Level 16, State 0, Line 11
Could not drop constraint. See previous errors.

(0 row(s) affected)

(0 row(s) affected)
Msg 1776, Level 16, State 0, Line 5
There are no primary or candidate keys in the referenced table 'ac_Categories' that match the referencing column list in the foreign key 'ac_Categories_ac_CategoryParents_FK1'.
Msg 1750, Level 16, State 0, Line 5
Could not create constraint. See previous errors.

(1582210 row(s) affected)

(0 row(s) affected)
Msg 1776, Level 16, State 0, Line 5
There are no primary or candidate keys in the referenced table 'ac_Vendors' that match the referencing column list in the foreign key 'ac_Vendors_ac_Products_FK1'.
Msg 1750, Level 16, State 0, Line 5
Could not create constraint. See previous errors.

(223364 row(s) affected)

(7743 row(s) affected)

(43 row(s) affected)

(86 row(s) affected)
Msg 1776, Level 16, State 0, Line 4
There are no primary or candidate keys in the referenced table 'ac_Users' that match the referencing column list in the foreign key 'ac_Users_ac_SearchHistory_FK1'.
Msg 1750, Level 16, State 0, Line 4
Could not create constraint. See previous errors.

(0 row(s) affected)

(0 row(s) affected)

(0 row(s) affected)

(0 row(s) affected)

(0 row(s) affected)

(1 row(s) affected)
Msg 3728, Level 16, State 1, Line 7
'ac_Paths_ac_UserPersonalization_FK1' is not a constraint.
Msg 3727, Level 16, State 0, Line 7
Could not drop constraint. See previous errors.
Msg 3728, Level 16, State 1, Line 2
'ac_Paths_ac_SharedPersonalization_FK1' is not a constraint.
Msg 3727, Level 16, State 0, Line 2
Could not drop constraint. See previous errors.
Msg 3728, Level 16, State 1, Line 2
'ac_PersonalizationPaths_PK' is not a constraint.
Msg 3727, Level 16, State 0, Line 2
Could not drop constraint. See previous errors.
Msg 3728, Level 16, State 1, Line 2
'ac_Stores_ac_Paths_FK1' is not a constraint.
Msg 3727, Level 16, State 0, Line 2
Could not drop constraint. See previous errors.

(0 row(s) affected)

(0 row(s) affected)

(0 row(s) affected)

(0 row(s) affected)

(0 row(s) affected)

(1 row(s) affected)

[jmestep]

It looks like your database might be botched up. For the user id error, make sure that the id field is an identity field. It looks like some of your other tables might have lost keys.