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 ...DNN 8 upgrade - Database migrationDNN 8 upgrade - Database migration
Previous
 
Next
New Post
5/17/2016 10:36 AM
 

Hi,

Hoping someone can help!  I attempted an upgrade this morning from 7.03.04.  When I first ran the upgradewizard, the upgrade stalled at 25% (during database upgrade) with the following message.

 

25% ERROR occured - System.Data.SqlClient.SqlException (0x80131904): Cannot DROP VIEW 'dbo.vw_Portals' because it is being referenced by object 'vw_PortalsDefaultLanguage'. at System.Data.SqlClient.SqlConnection. (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.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteScriptInternal(String connectionString, String script) ClientConnectionId:91661fc7-da13-4b63-aea1-aa560917cb23 IF OBJECT_ID(N'dbo.[vw_Portals]', N'V') IS NOT NULL DROP VIEW dbo.[vw_Portals] System.Data.SqlClient.SqlException (0x80131904): There is already an object named 'vw_Portals' in the database. at System.Data.SqlClient.SqlConnection. (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.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteScriptInternal(String connectionString, String script) ClientConnectionId:91661fc7-da13-4b63-aea1-aa560917cb23 CREATE VIEW dbo.[vw_Portals] AS SELECT P.PortalID, P.PortalGroupID, PL.PortalName, Case when PL.LogoFile LIKE 'fileid=%' then (SELECT IsNull(Folder, '') + [FileName] FROM dbo.[vw_Files] WHERE fileid = CAST(SUBSTRING(PL.LogoFile, 8, 10) AS Int)) else Coalesce(PL.LogoFile,'') end as LogoFile, PL.FooterText, P.ExpiryDate, P.UserRegistration, P.BannerAdvertising, P.AdministratorId, P.Currency, P.HostFee, P.HostSpace, P.PageQuota, P.UserQuota, P.AdministratorRoleId, P.RegisteredRoleId, PL.Description, PL.KeyWords, Case when PL.BackgroundFile LIKE 'fileid=%' then (SELECT IsNull(Folder, '') + [FileName] FROM dbo.[vw_Files] WHERE fileid = CAST(SUBSTRING(PL.BackgroundFile, 8, 10) AS Int)) else Coalesce(PL.BackgroundFile,'') end as BackgroundFile , P.GUID, P.PaymentProcessor, P.ProcessorUserId, P.ProcessorPassword, P.SiteLogHistory, U.Email, P.DefaultLanguage, P.TimezoneOffset, PL.AdminTabId, P.HomeDirectory, PL.SplashTabId, PL.HomeTabId, PL.LoginTabId, PL.RegisterTabId, PL.UserTabId, PL.SearchTabId, PL.Custom404TabId, PL.Custom500TabId, dbo.SuperUserTabID() ****truncated for space but have complete error if needed ***

 

 

I checked a few things and restarted the upgrade which "appeared" to run fine except it immediately jumped past database upgrade and started at 41% and I could watch each of the modules upgrade.  It completes with 100%

 

 

After the upgrade wizard closes, I can see my generic dnndev.me site with the DNN template but when I browse to my production site I get the following error:

 

 

Could not find stored procedure 'dbo.GetFile'. 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: Could not find stored procedure 'dbo.GetFile'.

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): Could not find stored procedure 'dbo.GetFile'.] System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) +392 System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) +815 System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) +4515 System.Data.SqlClient.SqlDataReader.TryConsumeMetaData() +61 System.Data.SqlClient.SqlDataReader.get_MetaData() +138 System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) +6738869 System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, SqlDataReader ds) +6741487 System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite) +586 System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) +107 System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) +288 System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior) +180 System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior) +21 DotNetNuke.Data.PetaPoco.PetaPocoExt.ExecuteReader(Database database, String sql, Object[] args) +326 DotNetNuke.Data.PetaPoco.PetaPocoHelper.ExecuteReader(String connectionString, CommandType type, String sql, Object[] args) +23 DotNetNuke.Data.DataProvider.GetFile(String fileName, Int32 folderId, Boolean retrieveUnpublishedFiles) +171 DotNetNuke.Services.FileSystem.FileManager.GetFile(IFolderInfo folder, String fileName, Boolean retrieveUnpublishedFiles) +194 DotNetNuke.Services.Exceptions.ErrorPage. (EventArgs e) +185 System.Web.UI.Control.LoadRecursive() +116 System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +2910 


Version Information: Microsoft .NET Framework Version:4.0.3

 

Is this due to the SQL scripts not running?  I've tried reverting back to 7 which brings other problems so I would like to resolve this if at all possible.  If it is SQL related, can I manually run the upgrade scripts?  If so, where are they in the download package.

 

 

Thanks so much for any help!

 

 

 
New Post
5/17/2016 12:17 PM
 
You need .Net 4.5 as a minimum. I would restore from backup, upgrade .Net and try again

www.server-essentials.com is a community for IT Consultants and Business Owners who, themselves, take care of the IT infrastructure and Employees who do that little extra in the company to keep things running. Our forum is for discussing all things ‘IT’ and more. Our documentation is top notch and written by and for the community. Join now at https://www.server-essentials.com/secure-registration
 
New Post
6/3/2016 2:17 PM
 
As I came across the same error message as Wendy when upgrading to DNN 8.0.3 my google search led me to this thread.

According to
- http://stackoverflow.com/questions/12...
and
- https://blogs.msdn.microsoft.com/rodn...

Version Information: Microsoft .NET Framework Version:4.0.3 can stand for .NET 4.0 or 4.6

As I have my local IIS server on Windows 10 it is most likely .NET 4.6.1 but am getting the same upgrade error.

Anyone in the know is welcome to suggest a solution here.

(What happened to the normal HTML editor on DNN Forum here? I can't get it to open. Had to write this in a simple TextBox. Pity.)

English-Polish translations, one-to-one English/Polish tutoring, Windows server management, website development - HTML/JS/CSS/Razor
 
New Post
6/4/2016 9:56 AM
 
if you have multiple Versions of .net Framework 4 installed, you might Need to re-apply the correct one for your IIS app pool using aspnet -regiis.

Cheers from Germany,
Sebastian Leupold

dnnWerk - The DotNetNuke Experts   German Spoken DotNetNuke User Group

Speed up your DNN Websites with TurboDNN
 
New Post
6/4/2016 4:39 PM
 
Wendy, I just happened to solve the problem you probably came across as the error is the same as yours. Just forgot I had applied Sebastian's TurboSchema SQL scripts and should have run the TurboUnSchema script before upgrading to DNN 8.0.3.

When I did, my test site on the local server of

Web Server Version: Microsoft-IIS/10.0
.NET Framework Version: 4.0.30319.42000 (which really is 4.6)

runs smoothly and without any hitch.

If you remember running the TurboSchema scripts before be sure to apply the TurboUnSchema script prior to upgrading. Don't forget to back-up first, of course.

English-Polish translations, one-to-one English/Polish tutoring, Windows server management, website development - HTML/JS/CSS/Razor
 
Previous
 
Next
HomeHomeGetting StartedGetting StartedInstalling DNN ...Installing DNN ...DNN 8 upgrade - Database migrationDNN 8 upgrade - Database migration


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