Products

Solutions

Resources

Partners

Community

About

New Community Website

Ordinarily, you'd be at the right spot, but we've recently launched a brand new community website... For the community, by the community.

Yay... Take Me to the Community!

Welcome to the DNN Community Forums, your preferred source of online community support for all things related to DNN.
In order to participate you must be a registered DNNizen

HomeHomeGetting StartedGetting StartedInstalling DNN ...Installing DNN ...Problem upgrading from 7.4.2 to 8.0.x - views not droppingProblem upgrading from 7.4.2 to 8.0.x - views not dropping
Previous
 
Next
New Post
5/31/2016 7:05 AM
 

I am having trouble upgrading one of my DNN sites from 7.4.2 to 8.0.x. I have successfully upgraded 11 of my sites to 8.0.3 (although one required some manual SQL tweaking to get it to work!), but this one has stumped me so far. The reason I mention the 11 previously successful upgrades is that all the sites are on the same cloud-based server, so I know that the environment is correct (e.g. .NET version, full trust, etc.) otherwise the other upgrades would have failed.

The basic problem is that it is this one site gets to 25% on the upgrade and then throws an error because a view can't be dropped. Here is the first SQL exception:

Cannot DROP VIEW 'dbo.vw_Portals' because it is being referenced by object 'vw_PortalsDefaultLanguage'.

Both of these views are in the other DNN sites that I've upgraded successfully, and they were obviously able to drop the view in spite of the object reference, so why has this one failed?

If I reload the page, it goes past this error, but comes up with more of the same type, such as:

Cannot DROP VIEW 'dbo.vw_UserRoles' because it is being referenced by object 'Journal_PermittedJournalIDs'.

Cannot DROP VIEW 'dbo.vw_Files' because it is being referenced by object 'vw_PublishedFiles'.

Of course, because these views cannot be dropped, and then the new views created in their place, they are having a knock-on effect, generating more errors like:

Invalid column name 'HasBeenPublished'.

I have tried manually dropping the objects that are referencing the views that the upgrade script wants to drop, but this has (so far) failed to work for me. I still have this nagging feeling that there is something else wrong though because why were these views able to be dropped and recreated for every other upgrade I've done?  The only thing I can think of that makes this one site different to the others that I've upgraded is a secure server certificate.  However, the upgrade doesn't run as https anyway, so I can't see that being a problem, and besides, it's a database issue, not a site issue.

Has anyone come across this, and can offer a solution?

 
New Post
5/31/2016 9:12 AM
 
did you apply TurboDNN to this site?
In this case you'll need to run TurboUnschema first.
(Please use latest version from http://dnnscript.codeplex.com)

Cheers from Germany,
Sebastian Leupold

dnnWerk - The DotNetNuke Experts   German Spoken DotNetNuke User Group

Speed up your DNN Websites with TurboDNN
 
New Post
5/31/2016 10:05 AM
 
Doh! I didn't think about that! Of course, THAT is what was different about this site to the others that I upgraded. Thanks Sebastian - applied TurboUnschema and the upgrade went through flawlessly. I should apply TurboDNN to ALL my sites, then I won't forget the one or two :)
 
New Post
5/31/2016 11:24 AM
 
thanks for the feedback - and don't forget to re-apply TurboDNN and TurboSchema after the upgrade.

Cheers from Germany,
Sebastian Leupold

dnnWerk - The DotNetNuke Experts   German Spoken DotNetNuke User Group

Speed up your DNN Websites with TurboDNN
 
New Post
5/31/2016 11:35 AM
 
Have just tried to re-apply TurboDNN, and it came back with an error. Tried to apply to another site (previously upgraded to 8.0.3) and the same error occurs: System.Data.SqlClient.SqlException (0x80131904): Incorrect syntax near 'EventLogKeepForDays'. Looks like the ' need to be '' in both places where EventLogKeepForDays appears! Made that change and it worked fine.
 
Previous
 
Next
HomeHomeGetting StartedGetting StartedInstalling DNN ...Installing DNN ...Problem upgrading from 7.4.2 to 8.0.x - views not droppingProblem upgrading from 7.4.2 to 8.0.x - views not dropping


These Forums are dedicated to discussion of DNN Platform and Evoq Solutions.

For the benefit of the community and to protect the integrity of the ecosystem, please observe the following posting guidelines:

  1. No Advertising. This includes promotion of commercial and non-commercial products or services which are not directly related to DNN.
  2. No vendor trolling / poaching. If someone posts about a vendor issue, allow the vendor or other customers to respond. Any post that looks like trolling / poaching will be removed.
  3. Discussion or promotion of DNN Platform product releases under a different brand name are strictly prohibited.
  4. No Flaming or Trolling.
  5. No Profanity, Racism, or Prejudice.
  6. Site Moderators have the final word on approving / removing a thread or post or comment.
  7. English language posting only, please.
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out