7.0.1 to 7.02 upgrade failed - install

[ksolito]

We have a store that's still under development but out of the 30 day free support.

Per the instructions, I backed up the database, uploaded the new fileset over the old and ran the install script. I did not stop the service before uploading the files which may have caused a lot of my problems.

The database upgrade had many errors but said it was complete.

Running upgrade scriptso o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o x o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o x x o o x x x x x x x o o o o o o o o o o

Errors occurred during database upgrade.

SQL: IF EXISTS (SELECT * FROM INFORMATION_SCHEMA.TABLE_CONSTRAINTS WHERE TABLE_NAME = 'ac_TaxRuleGroups' AND CONSTRAINT_NAME = 'ac_TaxRuleGroups_PK') BEGIN alter table "ac_TaxRuleGroups" add constraint "ac_TaxRuleGroups_PK" primary key ("GroupId", "TaxRuleId") END

Error: Table 'ac_TaxRuleGroups' already has a primary key defined on it. Could not create constraint. See previous errors.

SQL: ALTER TABLE ac_Orders ADD CONSTRAINT ac_Orders_PK PRIMARY KEY CLUSTERED ( OrderId ) WITH( STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]

Error: Line 7: Incorrect syntax near '('.

SQL: ALTER TABLE ac_Orders ADD CONSTRAINT ac_Affiliates_ac_Orders_FK1 FOREIGN KEY ( AffiliateId ) REFERENCES ac_Affiliates ( AffiliateId ) ON UPDATE NO ACTION ON DELETE SET NULL

Error: Incorrect syntax near the keyword 'SET'.

SQL: ALTER TABLE ac_Orders ADD CONSTRAINT ac_Users_ac_Orders_FK1 FOREIGN KEY ( UserId ) REFERENCES ac_Users ( UserId ) ON UPDATE NO ACTION ON DELETE SET NULL

Error: Incorrect syntax near the keyword 'SET'.

SQL: ALTER TABLE ac_OrderCoupons ADD CONSTRAINT ac_Orders_ac_OrderCoupons_FK1 FOREIGN KEY ( OrderId ) REFERENCES ac_Orders ( OrderId ) ON UPDATE NO ACTION ON DELETE CASCADE

Error: There are no primary or candidate keys in the referenced table 'ac_Orders' that match the referencing column list in the foreign key 'ac_Orders_ac_OrderCoupons_FK1'. Could not create constraint. See previous errors.

SQL: ALTER TABLE ac_OrderItems ADD CONSTRAINT ac_Orders_ac_OrderItems_FK1 FOREIGN KEY ( OrderId ) REFERENCES ac_Orders ( OrderId ) ON UPDATE NO ACTION ON DELETE CASCADE

Error: There are no primary or candidate keys in the referenced table 'ac_Orders' that match the referencing column list in the foreign key 'ac_Orders_ac_OrderItems_FK1'. Could not create constraint. See previous errors.

SQL: ALTER TABLE ac_OrderNotes ADD CONSTRAINT ac_Orders_ac_OrderNotes_FK1 FOREIGN KEY ( OrderId ) REFERENCES ac_Orders ( OrderId ) ON UPDATE NO ACTION ON DELETE CASCADE

Error: There are no primary or candidate keys in the referenced table 'ac_Orders' that match the referencing column list in the foreign key 'ac_Orders_ac_OrderNotes_FK1'. Could not create constraint. See previous errors.

SQL: ALTER TABLE ac_OrderShipments ADD CONSTRAINT ac_Orders_ac_Shipments_FK1 FOREIGN KEY ( OrderId ) REFERENCES ac_Orders ( OrderId ) ON UPDATE NO ACTION ON DELETE CASCADE

Error: There are no primary or candidate keys in the referenced table 'ac_Orders' that match the referencing column list in the foreign key 'ac_Orders_ac_Shipments_FK1'. Could not create constraint. See previous errors.

SQL: ALTER TABLE ac_Payments ADD CONSTRAINT ac_Orders_ac_Payments_FK1 FOREIGN KEY ( OrderId ) REFERENCES ac_Orders ( OrderId ) ON UPDATE NO ACTION ON DELETE CASCADE

Error: There are no primary or candidate keys in the referenced table 'ac_Orders' that match the referencing column list in the foreign key 'ac_Orders_ac_Payments_FK1'. Could not create constraint. See previous errors. Warning: The table 'ac_Payments' has been created but its maximum row size (8892) exceeds the maximum number of bytes per row (8060). INSERT or UPDATE of a row in this table will fail if the resulting row length exceeds 8060 bytes.

SQL: ALTER TABLE ac_GiftCertificateTransactions ADD CONSTRAINT ac_Orders_ac_GiftCertificateTransactions_FK1 FOREIGN KEY ( OrderId ) REFERENCES ac_Orders ( OrderId ) ON UPDATE NO ACTION ON DELETE SET NULL

Error: Incorrect syntax near the keyword 'SET'.

Upgrade complete.
Continue to Admin

I was particularly concerned about the 'scripting errors' which of course could cause all the others. I continued on though. I restarted the script but it said the database did not need the upgrade.

At Step 5

STEP 5) - Category and Search page error with SQL 2000 database
When using 'Category Grid' or 'Category Grid with Add to Basket' content scriptlets with a category page, advanced search, or product finder, and you have an SQL 2000 database, you will see this error after upgrading to version 7.0.2

[[ConLib:SearchPage]] The text, ntext, and image data types cannot be compared or sorted, except when using IS NULL or LIKE operator.

TO FIX: download patch which includes a new CommerceBuilder.DLL version 7.2.11679.0. Copy this over the existing one located in the \BIN\ folder. It may be necessary to temporarily stop the web service.

I did get the SQL 2000 error, downloaded and uploaded the CommerceBuilder.DLL. The overwrite failed and I was unable to stop the service from my host's control panel. I contacted tech support and they had to stop it. After I uploaded the new DLL, neither the cart nor the admin would run. This was the output:

Server Error in '/' Application.
--------------------------------------------------------------------------------

Could not load file or assembly 'CommerceBuilder.Data, Version=7.2.11602.0, Culture=neutral, PublicKeyToken=null' or one of its dependencies. The system cannot find the file specified.
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.IO.FileNotFoundException: Could not load file or assembly 'CommerceBuilder.Data, Version=7.2.11602.0, Culture=neutral, PublicKeyToken=null' or one of its dependencies. The system cannot find the file specified.

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.

Assembly Load Trace: The following information can be helpful to determine why the assembly 'CommerceBuilder.Data, Version=7.2.11602.0, Culture=neutral, PublicKeyToken=null' could not be loaded.


WRN: Assembly binding logging is turned OFF.
To enable assembly bind failure logging, set the registry value [HKLM\Software\Microsoft\Fusion!EnableLog] (DWORD) to 1.
Note: There is some performance penalty associated with assembly bind failure logging.
To turn this feature off, remove the registry value [HKLM\Software\Microsoft\Fusion!EnableLog].



Stack Trace:


[FileNotFoundException: Could not load file or assembly 'CommerceBuilder.Data, Version=7.2.11602.0, Culture=neutral, PublicKeyToken=null' or one of its dependencies. The system cannot find the file specified.]
CommerceBuilder.Stores.BannedIPDataSource.IsBanned(String ip) +0
CommerceBuilder.Services.c.c(Object A_0, EventArgs A_1) +563
System.Web.SyncEventExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() +68
System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) +75

After reinstalling the older dll, I admin and cart ran but I got a different area. At this point the tech at the hosting company deleted the entire install except for the database and had me reupload all files and AC will not run with either the old or new DLL.

Server Error in '/' Application.
--------------------------------------------------------------------------------

Runtime Error
Description: An application error occurred on the server. The current custom error settings for this application prevent the details of the application error from being viewed remotely (for security reasons). It could, however, be viewed by browsers running on the local server machine.

Details: To enable the details of this specific error message to be viewable on remote machines, please create a <customErrors> tag within a "web.config" configuration file located in the root directory of the current web application. This <customErrors> tag should then have its "mode" attribute set to "Off".


<!-- Web.Config Configuration File -->

<configuration>
<system.web>
<customErrors mode="Off"/>
</system.web>
</configuration>


Notes: The current error page you are seeing can be replaced by a custom error page by modifying the "defaultRedirect" attribute of the application's <customErrors> configuration tag to point to a custom error page URL.


<!-- Web.Config Configuration File -->

<configuration>
<system.web>
<customErrors mode="RemoteOnly" defaultRedirect="mycustompage.htm"/>
</system.web>
</configuration>

I short, I have a database that contains many hours of provisioning work and code install that won't run. I suspect I had some files that either failed to download or were corrupted when I made the backup before starting the upgrade process. I am open to reinstalling from scratch if I can do so without losing all the data entry that has been done.

Anybody have any suggestions? (bridge + jump not an option)
Thanks

[chuckdvc]

No response yet? Not surprised.

[jmestep]

Yes, it's been 25 minutes between posts. Everyone must have been out to lunch.
Are both of these posts about the same store?
I have received the errors like in the first post when I ran an upgrade over and existing site. The install continued fine but generated the errors because the changes were already made in the database.
It's a little hard to follow all you have done, but you might want to try an upgrade on a dev install so that you can have more control without having the hoster involved. Then upload the database and the files to the hoster and tweak settings like the license and database connection. There are more details about how to move the site on help.ablecommerce.com.

[AbleMods]

After reinstalling the older dll, I admin and cart ran but I got a different area. At this point the tech at the hosting company deleted the entire install except for the database and had me reupload all files and AC will not run with either the old or new DLL.

If the upgrade of the SQL database was where the failure occured, why wasn't the database restored when the site files were reuploaded?

Any time a major upgrade fails, especially when SQL scripts are involved, putting everything back the way it was and starting over is the cleanest way to restart.

[chuckdvc]

Sorry I read the time on his join time and thought it had been done at least the day before. I am just frustrated with trying to get the Able store up and some of the issues I have had and no response to issues posted here. I did jump the gun on this one though.

[AbleMods]

I am just frustrated with trying to get the Able store up and some of the issues I have had and no response to issues posted here.

In doing a search of the forums, I see only two issues posted by you. This one and another one regarding USPS shipping insurance. Both have been answered, so I'm curious as to why you feel the response of the forums has been less than satisfactory?

Please let us know what other issues you are having so we can help you towards a resolution. A separate thread for each one would be the most helpful and organized approach if you have several items on your list.

[chuckdvc]

Really? Guess you missed this one. Its about the USPS insurance and no it was never answered. I was told to post it outside the request forum and I did, no response. I find it hard to believe it isn't there and we are just missing something so we asked for help on it.

viewtopic.php?f=42&t=10639


My webmaster is also on here and so is one of my employees that has been entering the products. I ask both of them if issues they posted were answered on this forum as I was told when i purchased Able that the forums were watched and questions answered in a timely manner. They have told me several times that they received no answer. I have seen other issues go unanswered as well. They arent hard to find.

[AbleMods]

Chuck, the only way anyone can help you is if you let them. Telling me to go hunt for your co-workers unanswered posts is not the way to get your posts answered. How am I to know they are your employees? How am I to know they pertain to you and your situation?

In the case of the USPS insurance question, that was answered in the feature requests thread. The functionality does not exist. However unbelievable that may seem, it doesn't exist. There, you question is now answered

Might I suggest you rephrase your questions in the forum. For example: Asking "Has this been added yet?" in the main forums isn't going to result in the perception of technical support. People are going to interpret that as a feature request because that's what it is: you're asking for functionality that doesn't exist already and requires modification to support. While that type of forum post does merit a response, it isn't considered a high priority.

In your case, creating a new thread "How do I add insurance to a USPS shipment?" is going to get a better chance at a technical response. Is it guaranteed a response? Of course not. Mazhar could miss the post. Others could be busy with their full time jobs and not able to surf the forums. It's possible that people are not familiar enough with the subject matter to offer any response at all. A gentle *bump* after a day or so should be enough to get someones attention. If not, well then nobody knows the answer to your question.

Able forums are operated by a primary forum moderator, Mazhar. Able development staff do moderate threads from time-to-time, however the majority of forum work comes from Mazhar. The rest of the forum activity is from members helping members. We will help the best we can.

[afm]

...lots of detail about multiple problems...

In short, I have a database that contains many hours of provisioning work and code install that won't run. I suspect I had some files that either failed to download or were corrupted when I made the backup before starting the upgrade process. I am open to reinstalling from scratch if I can do so without losing all the data entry that has been done.

Anybody have any suggestions? (bridge + jump not an option)
Thanks

I think you are right about the root cause. After you finished your clean (except for the database) install, did you run the install script? Did it display any errors?

As an aside, this is a very complicated set of problems. It is very likely you are and will be the only person on earth that has the particular combination of issues. I'm not surprised there are no easy answers or quick suggestions. Frankly, I think the most likely outcome is that you will need to start over with a clean database.

I'm sure you know this, but for all those lurkers out there reading: please use a separate staging server to test upgrades and customizations; and make a backup of both your web site files *and* your database before you install or upgrade anything on your production web site. If there was a backup of this site and database, the original poster could have been back up and running (albeit without the update) in a matter of minutes.