Upgrading database from Gold R2 to Gold R7

[KenPalmer]

We need to upgrade our AbleCommerce instance from R2 to R7, and hit some roadblocks upgrading the database. At this point I've got the R7 WAP solution loaded into TFS, and building successfully on my workstation in Visual Studio 2012. And I'm able to launch the site in Visual Studio to get to the installation wizard. But the database upgrade from R2 to R7 is failing.

These are steps that I've taken:
1. Back up our original AbleCommerce Gold R2 database.
2. Launch the website to view the AbleCommerce installation wizard.
3. Enter the license key for my environment.
4. Enter the database connection information to target that AbleCommerce Gold R2 database.
5. Submit

My understanding, based on other posts, was that the install wizard will execute scripts to upgrade the database from any of the AbleCommerce Gold versions to Gold R7. On the installation screen, after I enter the license key for my local environment and database connection info, the page processes then displays an error, "Database Configuration Failed: The specified database is not a valid database version. The upgrade only works on AC7.0.6 or higher databases."

We are upgrading from AbleCommerce Gold R2 to Gold R7, not from the old AbleCommerce 7.

I looked in the ac_StoreSettings table to see if there was an entry for the database version, but didn't see any entries that appeared related to the database version there. There is an AbleCommerce.sql script in the zip file for the full install, in this directory, but it's coded to create a new database. (AbleCommerceGold-GoldR7-b7118-WAP\Website\Install\AbleCommerce.sql)

How can I successfully upgrade the AbleCommerce database from Gold R2 to Gold R7?

Thanks for your help.

[jmestep]

Are you sure you entered a Gold license key?

[KenPalmer]

Yes. In fact, I just had the new keys emailed to me from support. To give some back-story, in 2012 we upgraded from AbleCommerce 7 to AbleCommerce Gold. Then we upgraded to Gold R2 at the beginning of 2013. My client reported some coupon-related errors, which prompted an investigation. AbleCommerce fixed several coupon bugs in previous releases, if memory serves R5 had several.

Consequently we are upgrading from R2 to R7, with the expectation that this will fix the order coupon problem, and any other issues that were corrected since R2.

[ForumsAdmin]

You are not supposed to go to Install wizard when upgrading within gold.

All you needed to do to upgrade from R2 to R7 is to simply update your R2 installation with new files from R7, restart the application and then access AC Gold. On first access to the site after restart the upgrade will happen automatically.

[KenPalmer]

Thanks. Since the site should bypass the install wizard, I set the Default.aspx file in the root directory as the start page. Now when I launch the site, the following message appears:

We are sorry, but the page you are trying to access has experienced an error.
Please contact us to report this problem.

The stack trace in the application log shows NHibernate errors. This is pasted below. A couple that stand out are missing columns:
Invalid column name 'Title'.
Invalid column name 'HtmlHead'.

Thanks for helping me out.

Error from the Application Log
Event code: 3005
Event message: An unhandled exception has occurred.
Event time: 4/15/2014 8:23:50 AM
Event time (UTC): 4/15/2014 1:23:50 PM
Event ID: 790f3b54bcc748e69aeeae6a0c4d428b
Event sequence: 58
Event occurrence: 2
Event detail code: 0

Application information:
Application domain: /LM/W3SVC/6/ROOT-2-130420415278859445
Trust level: Full
Application Virtual Path: /
Application Path: C:\SourceCode\1.DEV-SW.Team\SW\PublicRelations\Web\AlumniStore\
Machine name: PC2147

Process information:
Process ID: 2000
Process name: w3wp.exe
Account name: IIS APPPOOL\local.alumnistore.com

Exception information:
Exception type: GenericADOException
Exception message: could not load an entity: [CommerceBuilder.Catalog.Webpage#9][SQL: SELECT webpage0_.WebpageId as WebpageId6_0_, webpage0_.StoreId as StoreId6_0_, webpage0_.Name as Name6_0_, webpage0_.Summary as Summary6_0_, webpage0_.Description as Descript5_6_0_, webpage0_.ThumbnailUrl as Thumbnai6_6_0_, webpage0_.ThumbnailAltText as Thumbnai7_6_0_, webpage0_.Layout as Layout6_0_, webpage0_.Theme as Theme6_0_, webpage0_.VisibilityId as Visibil10_6_0_, webpage0_.WebpageTypeId as Webpage11_6_0_, webpage0_.Title as Title6_0_, webpage0_.MetaDescription as MetaDes13_6_0_, webpage0_.MetaKeywords as MetaKey14_6_0_, webpage0_.HtmlHead as HtmlHead6_0_ FROM ac_Webpages webpage0_ WHERE webpage0_.WebpageId=?]
at NHibernate.Loader.Loader.LoadEntity(ISessionImplementor session, Object id, IType identifierType, Object optionalObject, String optionalEntityName, Object optionalIdentifier, IEntityPersister persister)
at NHibernate.Loader.Entity.AbstractEntityLoader.Load(ISessionImplementor session, Object id, Object optionalObject, Object optionalId)
at NHibernate.Loader.Entity.AbstractEntityLoader.Load(Object id, Object optionalObject, ISessionImplementor session)
at NHibernate.Event.Default.DefaultLoadEventListener.LoadFromDatasource(LoadEvent event, IEntityPersister persister, EntityKey keyToLoad, LoadType options)
at NHibernate.Event.Default.DefaultLoadEventListener.Load(LoadEvent event, IEntityPersister persister, EntityKey keyToLoad, LoadType options)
at NHibernate.Event.Default.DefaultLoadEventListener.OnLoad(LoadEvent event, LoadType loadType)
at NHibernate.Impl.SessionImpl.FireLoad(LoadEvent event, LoadType loadType)
at NHibernate.Impl.SessionImpl.Get(String entityName, Object id)
at NHibernate.Impl.SessionImpl.Get(Type entityClass, Object id)
at CommerceBuilder.DomainModel.RepositoryWithTypedId`2.Load(TId id)
at CommerceBuilder.DomainModel.DataSourceWithTypedId`3.Load(TId id)
at AbleCommerce.WebpagePage.Page_PreInit(Object sender, EventArgs e) in c:\SourceCode\1.DEV-SW.Team\SW\PublicRelations\Web\AlumniStore\Webpage.aspx.cs:line 16
at System.EventHandler.Invoke(Object sender, EventArgs e)
at System.Web.UI.Page.PerformPreInit()
at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)

Invalid column name 'Title'.
Invalid column name 'HtmlHead'.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
at System.Data.SqlClient.SqlDataReader.TryConsumeMetaData()
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, Int32 timeout, Task& task, Boolean asyncWrite, SqlDataReader ds)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite)
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)
at NHibernate.Loader.Loader.GetResultSet(IDbCommand st, Boolean autoDiscoverTypes, Boolean callable, RowSelection selection, ISessionImplementor session)
at NHibernate.Loader.Loader.DoQuery(ISessionImplementor session, QueryParameters queryParameters, Boolean returnProxies)
at NHibernate.Loader.Loader.DoQueryAndInitializeNonLazyCollections(ISessionImplementor session, QueryParameters queryParameters, Boolean returnProxies)
at NHibernate.Loader.Loader.LoadEntity(ISessionImplementor session, Object id, IType identifierType, Object optionalObject, String optionalEntityName, Object optionalIdentifier, IEntityPersister persister)



Request information:
Request URL: http://local.alumnistore.com/webpage.aspx?webpageid=9
Request path: /webpage.aspx
User host address: 127.0.0.1
User:
Is authenticated: False
Authentication Type:
Thread account name: IIS APPPOOL\local.alumnistore.com

Thread information:
Thread ID: 31
Thread account name: IIS APPPOOL\local.alumnistore.com
Is impersonating: False
Stack trace: at NHibernate.Loader.Loader.LoadEntity(ISessionImplementor session, Object id, IType identifierType, Object optionalObject, String optionalEntityName, Object optionalIdentifier, IEntityPersister persister)
at NHibernate.Loader.Entity.AbstractEntityLoader.Load(ISessionImplementor session, Object id, Object optionalObject, Object optionalId)
at NHibernate.Loader.Entity.AbstractEntityLoader.Load(Object id, Object optionalObject, ISessionImplementor session)
at NHibernate.Event.Default.DefaultLoadEventListener.LoadFromDatasource(LoadEvent event, IEntityPersister persister, EntityKey keyToLoad, LoadType options)
at NHibernate.Event.Default.DefaultLoadEventListener.Load(LoadEvent event, IEntityPersister persister, EntityKey keyToLoad, LoadType options)
at NHibernate.Event.Default.DefaultLoadEventListener.OnLoad(LoadEvent event, LoadType loadType)
at NHibernate.Impl.SessionImpl.FireLoad(LoadEvent event, LoadType loadType)
at NHibernate.Impl.SessionImpl.Get(String entityName, Object id)
at NHibernate.Impl.SessionImpl.Get(Type entityClass, Object id)
at CommerceBuilder.DomainModel.RepositoryWithTypedId`2.Load(TId id)
at CommerceBuilder.DomainModel.DataSourceWithTypedId`3.Load(TId id)
at AbleCommerce.WebpagePage.Page_PreInit(Object sender, EventArgs e) in c:\SourceCode\1.DEV-SW.Team\SW\PublicRelations\Web\AlumniStore\Webpage.aspx.cs:line 16
at System.EventHandler.Invoke(Object sender, EventArgs e)
at System.Web.UI.Page.PerformPreInit()
at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)


Custom event details:

[KenPalmer]

Can you please clarify what is necessary to invoke the database upgrade. Is there some specific page that I need to navigate to, besides the Default.aspx page in root? Or is there some SQL script in the AbleCommerceGold-GoldR7-b7118-WAP.zip file that we can manually invoke?

We'd rather not resort to using some database comparison tool. Thanks.

[Katie]

Well, it should upgrade automatically when you access the admin...

If it were me, I would install a clean R7 build first. Then, from the Configure > Security > Database page, you can point to your R2 database. Re-access the admin and it should upgrade.

By doing it this way, you can eliminate any missing or customized files as being the culprit. Once you have the db upgraded, then start moving your custom files, images, and theme folder in place.

[KenPalmer]

Katie, thanks for the feedback. I had not tried navigating to the Login.aspx page. That page will render successfully from my solution. But upon logging in, the browser is directed to an error screen.

We are sorry, but the page you are trying to access has experienced an error.
Please contact us to report this problem.

The Application log reports a long GenericADOException, with this slice of information:
Invalid column name 'IsSubscription'.
Invalid column name 'Frequency'.
Invalid column name 'FrequencyUnitId'.

From the web application side, we have AbleCommerce Gold R7 building successfully in Visual Studio 2012. I've added it to TFS, and can launch it. Additionally, I can launch it to the Login.aspx page in root and it won't throw any errors. Navigating to any other page (besides Login.aspx) directs the browser to an error page, whereby Application Log reveals these missing columns:
Invalid column name 'Title'.
Invalid column name 'HtmlHead'.

From the database side, I've tried the following:
1. Restore database to Able Commerce Gold R2 from a backup that I made yesterday.
2. Verify that the development instance of our site (Able Commerce Gold R2) continues to work from the backup. It indeed runs successfully.
3. Launch the new R7 version from my workstation in Visual Studio, and attempt to log in via the Login.aspx page. This threw the italicized error above.

Prior to that, on the old instance of our R2 database, I had attempted to manually apply the upgrade scripts from the upgrade zip files. These failed, which prompted me to restore the database from backup so we have a clean baseline R2 database. Those script files were both named Upgrade_AC7_AC708.sql, and were from the following zips:
UpgradeGold-R3b5078-to-R4b5410-WSP
UpgradeGold-R4b5410-to-R5b5731-WSP

Again, that direct intervention of manually executing those scripts against the R2 database failed. So I restored the database from backup today.

Last week I created a clean R7 database instance from this script:
AbleCommerceGold-GoldR7-b7118-WAP\Website\Install\AbleCommerce.sql

Using the Red Gate SQL Compare Wizard, I reviewed some of the differences between the R2 and R7 versions of the database. Glancing at the output, there are 5 or 6 new tables, some additional fields, field definition changes, adjustments to foreign keys, and other differences. We did not apply the Red Gate tool changes to the database.

We'd prefer to apply a solution that comes directly from AbleCommerce. If there is a script that will upgrade the R2 database structure to R7, or a script that will accurately transfer the data from R2 to R7, either would be helpful. Thanks.

[ForumsAdmin]

The upgrade routine runs only once at the application startup. If you are getting invalid column errors it indicates that the upgrade routine did not run for some reason. It could be because of the sequence of steps taken for upgrade. But the solution is pretty simple. Just restart your application or IIS. The upgrade routines will run when the application restarts and you should be albe to proceed.

[jmestep]

Ken, what the ForumsAdmin is saying works to upgrade the database. I still have trouble remembering that I don't need to go to a file in the install folder to upgrade, I only need to browse to the site.

[KenPalmer]

Thanks for responding @Katie, @ForumsAdmin, and @jmestep. I'll try the upgrade again, using a solution from one of the zips.

Also, I performed some analysis on the database differences between R2 and R7. My findings are below. This is a simple table and field compare, which doesn't include things like field definition changes, keys, or constraints.

Tables in the R7 database that aren't in R2 database.
ac_DigitalGoodGroups
ac_GatewayPaymentProfiles
ac_ProductGroups
ac_ReviewReminders
ac_SearchHistory
ac_SubscriptionOrders

Fields in the R7 database that aren't in the R2 database.
ac_BasketItems: IsSubscription, Frequency, FrequencyUnitId
ac_Categories: Title, HtmlHead
ac_Links: HtmlHead
ac_OptionChoices: Selected
ac_OrderItems: IsSubscription, Frequency, FrequencyUnitId
ac_Orders: IsSubscriptionGenerated
ac_PaymentMethods: AllowSubscriptions
ac_Payments: IsSubscriptionFollowup
ac_Products: AvailabilityDate, HandlingCharges, EnableGroups, Title, HtmlHead, SearchKeywords, ExcludedDestination, PublishFeedAsVariants
ac_ProductVariantsP: GTIN, AvailabilityDate, ImageUrl, ThumbnailUrl, IconUrl
ac_ShipMethods: MaxPurchase, SurchargeModeId
ac_SubscriptionPlans: RecurringChargeModeId, IsOptional, Description, OneTimeCharge, OneTimeChargeModeId, OptionalPaymentFrequencies, PaymentFrequencyTypeId, RepeatDiscounts, OneTimeChargeTaxCodeId

ac_Subscriptions: Name, Quantity, NumberOfPayments, ExpirationAlertDate, ExpiredAlertDate, NextOrderDueDate, LastOrderDueDate, PaymentFrequency, PaymentFrequencyUnitId, BasePrice, BaseTaxCodeId, RecurringCharge, RecurringChargeModeId, RecurringChargeSpecified, RecurringTaxCodeId, RepeatDiscounts, IsLegacy, PaymentProcessingTypeId, PaymentMethodId, GatewayPaymentProfileId, ProcessingStatusId, ProcessingStatusMessage, BillToFirstName, BillToLastName, BillToCompany, BillToAddress1, BillToAddress2, BillToCity, BillToProvince, BillToPostalCode, BillToCountryCode, BillToPhone, BillToFax, BillToEmail, BillToResidence, ShipToFirstName, ShipToLastName, ShipToCompany, ShipToAddress1, ShipToAddress2, ShipToCity, ShipToProvince, ShipToPostalCode, ShipToCountryCode, ShipToPhone, ShipToFax, ShipToEmail, ShipToResidence

ac_Webpages: Title, HtmlHead

[KenPalmer]

This is an update on what I've done so far. At this point, the automated update isn't working.

Initially I Downloaded UpgradeGold-R6b6169-to-R7b7118-WAP.zip. After unzipping the file, I opened the AbleCommerce.csproj in VS 2012. This resulted in seeing a migration script from VS 2010 to VS 2012. So I closed VS 2012, deleted the unzipped folder, and unzipped the file again to start over.

This time, I did the following with the files from UpgradeGold-R6b6169-to-R7b7118-WAP.zip:
1. Opened the AbleCommerce.csproj in VS 2010.
2. Attempted to build: Project would not build due to about a dozen missing references.
3. Added references to AjaxControlToolkit, AntiXSSLbrary, Castle.Core, Castle.Windsor, HtmlSanitationLibrary, Lucene.Net, NHibernate, and more.
4. Attempted to build: Project would not build due to over 1000 messages similar to this: "Source file 'C:\Downloads\AbleCommerce\Upgrades\UpgradeGold-R6b6169-to-R7b7118-WAP\Website\Admin\Catalog\AddCategory.aspx.cs' could not be opened ('Unspecified error )".
5. Turned off "Read Only" status on all files in my UpgradeGold-R6b6169-to-R7b7118-WAP directory.
6. Attempted to build: Project would not build, with same errors shown at step 4.

So I'm unable to successfully build the project in UpgradeGold-R6b6169-to-R7b7118-WAP.zip.

Consequently I closed that attempt and tried the Full Install version of AC Gold R7 (AbleCommerceGold-GoldR7-b7118-WAP). After unzipping the contents, this is what I did:
1. Opened the AbleCommerce_WAP.sln file in VS 2010.
2. Built successfully.
3. Launched, and was presented with the license agreement at localhost:53012/Install/Default.aspx.
4. Checked the "I have read..." and selected "Continue".
5. On the localhost:53012/Install/Configure1.aspx page, selected:
a. Enter License key, and entered our key.
b. Specify database, and entered connection information.
c. Selected "This is an existing AC7 database to be upgraded."
d. Checked the PCI Compliance box, and selected Continue.
6. Saw a configuring database message, followed by this, "The specified database is not a valid database version. The upgrade only works on AC7.0.6 or higher databases."
7. Changed the URL in the browser to localhost:53012/Default.aspx
8. Was redirected to local.alumnistore.com:53012/Default.aspx and saw a message "This webpage has a redirect loop." An error in the App Log showed missing columns:
Invalid column name 'Title'.
Invalid column name 'HtmlHead'.
9. Changed the URL in the browser to localhost:53012/Login.aspx. But was redirected to local.alumnistore.com:53012/Default.aspx and saw a message "This webpage has a redirect loop."

Re-reading the suggestions from @ForumsAdmin and @jestep, I tried something simpler.
1. Stop and restart IIS on my workstation.
2. Browse to the site, which we have set up as local.alumnistore.com. This is a successfully building instance of the full WAP for AbleCommerce R7 (AbleCommerceGold-GoldR7-b7118-WAP.zip).
3. The error page appeared, "We are sorry, but the page you are trying to access has experienced an error. Please contact us to report this problem." Yep, been doing that.
4. Windows App Log shows missing column names as previously (Title, HtmlHead).
5. Navigated to local.alumnistore.com/Login.aspx, which successfully shows the login screen.
6. Selected some links (Product Finder, Advanced Search, Contact Us, Wishlist) but got the same error shown in step 3.
7. Went back to local.alumnistore.com/Login.aspx and logged in. But got the same error page from step 3.

As @ForumsAdmin pointed out, this is a scenario where "upgrade routine did not run for some reason." To get the DB to upgrade, it would seem that we first need to get an upgrade solution to successfully build.

One more thing here. Looking at the files in the solution, there is an Install/Upgrade.aspx page. So I did this:
1. Manually navigated to localhost:53012/Install/Upgrade.aspx. The page displayed "You are about to upgrade your database to AC Gold". The message seems to indicate that this is for use if you go from AC 7 to AC Gold, instead of from AC Gold R2 to AC Gold R7. My DB is already backed up, so at this point I figure that I have nothing to lose.
2. Entered "BACKUP" and clicked the Upgrade button. I briefly saw a message that the database was being upgraded, then was quickly directed to an errors page.
Apparently this is not the way to do this.

My next attempt will be to restore our R2 database from backup, and try opening one of the R2 to R3 upgrade zips. Hopefully that will successfully build on the first attempt.

[jmestep]

I haven't done any using WAP or trying to run the site in VS. All my sites are set up in IIS. I looked at help.ablecommerce.com and saw this info under upgrade to R7

For WAP versions:

Recompile the application.

Republish to the target server.

I re-read some of your posts and noticed that you can get to store pages but not admin. That is usually a license key problem. Try setting <item key="UseDemoMode" value="True" /> in the App_Data/ablecommerce.config file. Also make sure the settings in your ac_StoreSettings table are correct
Store_StoreUrl and one for SSl- I'm not seeing that one in my dev sites since I never have SSL turned on there.

[KenPalmer]

Thanks Judy. We threw in the towel on the approaches that I took earlier, reverted the site back to the old R2 version of AbleCommerce, and plan to use file-compare tools to upgrade the web instance incrementally to R7. Hopefully when we get it there, it will in some automated fashion upgrade the database.

[ForumsAdmin]

It shouldn't be so difficult. Upgrades within GOLD are supposed to be as simple as updating old files with new files. Rest is supposed to happen automatically.

When we release a version we do test extensively for upgrades from previous versions. Normally we test at least 2 prior versions in great detail. For example we tested in great detail upgrades from R5 to R7 and R6 to R7. Because upgrades from previous versions are already tested for their next releases we do not go all the way to test from R1 - R7, R2 - R7, R3 - R7 and so on.

However after this report of yours we went ahead and tested direct upgrade from R2 - R7. It worked falwlessly using both approaches to the upgrade.
The two approaches to the upgrade are very simple and already discussed in this thread
Approach 1: Starting from existing R2 install : Stop IIS, Copy all files from R7 build to R2 install (overwriting existing files), Re-start IIS, Access the store.
Approach 2: Starting from a fresh R7 install : Create a fresh R7 install, In Configure -> Database section change the connection string to point to R2 database, Restart IIS, Access the store.

I am not sure why you are having difficulty getting this to work. If it is possible for you to privately share your database with us we can try upgrading it ourselves and see what goes wrong.

[KenPalmer]

Thanks @ForumsAdmin. I'll be happy to privately share a copy of our database. Feel free to contact me via private message, or email me at the address from the account settings of my message board profile with instructions for forwarding it to you. Thanks.

[jguengerich]

Ken,

Just thought I would mention that the reason you can't build the site from the Upgrade zips is that they only contain the site files that are different between the two versions given in the file name. For example, UpgradeGold-R6b6169-to-R7b7118-WAP.zip only contains the web site files that have changed between R6 and R7. You would need to copy these files over an existing full set of R6 web site files, then build it.

[ForumsAdmin]

Ken,

Just thought I would mention that the reason you can't build the site from the Upgrade zips is that they only contain the site files that are different between the two versions given in the file name. For example, UpgradeGold-R6b6169-to-R7b7118-WAP.zip only contains the web site files that have changed between R6 and R7. You would need to copy these files over an existing full set of R6 web site files, then build it.Jay

Exactly.

Ken, if you have been trying to upgrade using UpgradeGold-XXX-to-XXX files you will see that these files are provided only as a diff between two consecutive versions. So if you are trying to upgrade from R2 to R7 you should use the R7 full build not the UpgradeGold-R6b6169-to-R7b7118 zip file becauase this only contains new/updated files between R6 build 6169 and R7 build 7118.