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!

 

 

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.)

---

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.

---