I am having a problem upgrading my DNN installation from 04.09.02 to 05.00.01.  I have tried this several times and I get the same result each time.

My database hosting my DNN installation is SQL Server 2000 on a Windows 2003 Standard edition box seperate from the IIS Webserver.

My Webserver is Windows 2003 Standard Edition.

My routine in upgrading my DNN installation is as follows:

#1.  Shut down router access to website to the outside world so that no interference can occur during upgrade.

#2.  Backup DB and website.

#3.  Restart DB to clear any locks.

#4.  Shutdown IIS

#5.  Copy DNN 05.00.01 upgrade into current DNN directory.

#6.  Reapply directory permissions to the DNN directory to ensure that the Local network service and the ASP.NET local accounts have full access to those directories and all subdirectories.

#7.  Rename web.config to web.old and release.config to web.config

#8.  Copy Connection string info, Machine Code, and additional code subdirectory info into new web.config to match the old web.config file.

#9.  Start IIS

#10.  Try to go to the site to initiate the upgrade routine.

This is the same procedure I have been using for every version of DNN up to this version without fail.  However, when I try to upgrade to 05.00.01 I get the following results everytime forcing me to do a restore and try again.  I have no idea where to go from here.  Any help would be appreciated!

Upgrading DotNetNuke

Current Assembly Version: 05.00.01

Current Database Version: 04.09.02

Upgrade Status Report

00:00:00.015 - Upgrading to Version: 5.0.1

00:00:00.234 -   Executing Script: 05.00.00.SqlDataProvider 

Error! (see 05.00.00.log for more information)

00:00:09.406 -   Executing Script: 05.00.01.SqlDataProvider 

Success

00:00:10.484 - Performing General Upgrades

00:00:11.015 - Installing Optional Modules:

00:00:11.015 - Installing Optional Skins:

00:00:11.015 -   Installing Package File DNN-MinimalExtropySkin_01.00.02_Install:  

Success

00:00:11.437 - Installing Optional Containers:

00:00:11.437 -   Installing Package File DNN-MinimalExtropyContainer_01.00.02_Install:  

Success

00:00:11.515 - Installing Optional Languages:

00:00:11.515 - Installing Optional Providers:

00:00:11.515 -   Installing Package File AspNetMembershipProvider_05.00.01_Install:

Server Error in '/' Application.

---

The stored procedure 'dbo.GetPackageByName' doesn't exist.

[InvalidOperationException: The stored procedure 'dbo.GetPackageByName' doesn't exist.]
   System.Data.SqlClient.SqlCommand.DeriveParameters() +947206
   System.Data.SqlClient.SqlCommandBuilder.DeriveParameters(SqlCommand command) +88
   Microsoft.ApplicationBlocks.Data.SqlHelperParameterCache.DiscoverSpParameterSet(SqlConnection connection, String spName, Boolean includeReturnValueParameter, Object[] parameterValues) +212
   Microsoft.ApplicationBlocks.Data.SqlHelperParameterCache.GetSpParameterSetInternal(SqlConnection connection, String spName, Boolean includeReturnValueParameter) +303
   Microsoft.ApplicationBlocks.Data.SqlHelperParameterCache.GetSpParameterSet(String connectionString, String spName, Boolean includeReturnValueParameter) +154
   Microsoft.ApplicationBlocks.Data.SqlHelperParameterCache.GetSpParameterSet(String connectionString, String spName) +36
   Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteReader(String connectionString, String spName, Object[] parameterValues) +200
   DotNetNuke.Data.SqlDataProvider.GetPackageByName(Int32 portalID, String name) +145
   DotNetNuke.Services.Installer.Installers.PackageInstaller.ReadManifest(XPathNavigator manifestNav) +361
   DotNetNuke.Services.Installer.Installers.PackageInstaller..ctor(String packageManifest, InstallerInfo info) +195
   DotNetNuke.Services.Installer.Installer.ProcessPackages(XPathNavigator rootNav) +196
   DotNetNuke.Services.Installer.Installer.ReadManifest(Stream stream) +424
   DotNetNuke.Services.Installer.Installer.ReadManifest(Boolean deleteTemp) +126
   DotNetNuke.Services.Installer.Installer..ctor(Stream inputStream, String physicalSitePath, Boolean loadManifest, Boolean deleteTemp) +102
   DotNetNuke.Services.Upgrade.Upgrade.InstallPackage(String strFile, String packageType, Boolean writeFeedback) +201
   DotNetNuke.Services.Upgrade.Upgrade.InstallPackages(String packageType, Boolean writeFeedback) +225
   DotNetNuke.Services.Install.Install.UpgradeApplication() +1007
   DotNetNuke.Services.Install.Install.Page_Load(Object sender, EventArgs e) +292
   System.Web.UI.Control.OnLoad(EventArgs e) +99
   System.Web.UI.Control.LoadRecursive() +47
   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1436

Here is the Log Dump.

System.Data.SqlClient.SqlException: For DROP INDEX, you must give both the table and the index name, in the form tablename.indexname.
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
   at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
   at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
   at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
   at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL)
   at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions)





/***********************************************************/
/* End Update Admin Modules to conform to Module Standards */
/***********************************************************/

/* Update Packages */
/*******************/

ALTER TABLE dbo.Packages
    ADD PortalID int NULL

ALTER TABLE dbo.Packages
    ALTER COLUMN Description nvarchar(2000) NULL

ALTER TABLE dbo.Packages
    ALTER COLUMN License ntext NULL

ALTER TABLE dbo.Packages
    ALTER COLUMN Manifest ntext NULL

ALTER TABLE dbo.Packages
    ADD Owner nvarchar(100) NULL

ALTER TABLE dbo.Packages
    ADD Organization nvarchar(100) NULL

ALTER TABLE dbo.Packages
    ADD Url nvarchar(250) NULL

ALTER TABLE dbo.Packages
    ADD Email nvarchar(100) NULL

ALTER TABLE dbo.Packages
    ADD ReleaseNotes ntext NULL

ALTER TABLE dbo.Packages
    ADD IsSystemPackage bit NOT NULL CONSTRAINT DF_Packages_IsSystemPackage DEFAULT 0
   
DROP INDEX IX_Packages ON dbo.Packages

CREATE UNIQUE NONCLUSTERED INDEX IX_Packages ON dbo.Packages ( Owner, Name, PortalID )



System.Data.SqlClient.SqlException: Invalid column name 'PortalID'.
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
   at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
   at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
   at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
   at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL)
   at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions)



CREATE PROCEDURE dbo.[AddPackage]
    @PortalID            int,
    @Name                nvarchar(50),
    @FriendlyName        nvarchar(250),
    @Description        nvarchar(2000),
    @PackageType        nvarchar(50),
    @Version            nvarchar(50),
    @License            ntext,
    @Manifest            ntext,
    @Owner                nvarchar(100),
    @Organization        nvarchar(100),
    @Url                nvarchar(250),
    @Email                nvarchar(100),
    @ReleaseNotes        ntext,
    @IsSystemPackage    bit
AS
    INSERT INTO dbo.Packages
    (
        PortalID,
        [Name],
        FriendlyName,
        [Description],
        PackageType,
        Version,
        License,
        Manifest,
        ReleaseNotes,
        [Owner],
        Organization,
        Url,
        Email,
        IsSystemPackage
    )
    VALUES (
        @PortalID,
        @Name,
        @FriendlyName,
        @Description,
        @PackageType,
        @Version,
        @License,
        @Manifest,
        @ReleaseNotes,
        @Owner,
        @Organization,
        @Url,
        @Email,
        @IsSystemPackage
    )
    SELECT SCOPE_IDENTITY()


System.Data.SqlClient.SqlException: Invalid column name 'PortalID'.
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
   at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
   at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
   at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
   at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL)
   at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions)



CREATE PROCEDURE dbo.[UpdatePackage]
    @PortalID            int,
    @Name                nvarchar(50),
    @FriendlyName        nvarchar(250),
    @Description        nvarchar(2000),
    @PackageType        nvarchar(50),
    @Version            nvarchar(50),
    @License            ntext,
    @Manifest            ntext,
    @Owner                nvarchar(100),
    @Organization        nvarchar(100),
    @Url                nvarchar(250),
    @Email                nvarchar(100),
    @ReleaseNotes        ntext,
    @IsSystemPackage    bit
AS
    UPDATE dbo.Packages
        SET   
            PortalID = @PortalID,
            FriendlyName = @FriendlyName,
            [Description] = @Description,
            PackageType = @PackageType,
            Version = @Version,
            License = @License,
            Manifest = @Manifest,
            [Owner] = @Owner,
            Organization = @Organization,
            Url = @Url,
            Email = @Email,
            ReleaseNotes = @ReleaseNotes,
            IsSystemPackage = @IsSystemPackage
        WHERE  [Name] = @Name



System.Data.SqlClient.SqlException: Invalid column name 'PortalID'.
Invalid column name 'PortalID'.
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
   at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
   at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
   at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
   at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL)
   at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions)



CREATE PROCEDURE dbo.[GetPackages]
    @PortalID    int
AS
    SELECT *
        FROM   dbo.Packages
        WHERE (PortalID = @PortalID OR @PortalID IS NULL OR PortalID IS NULL)
        ORDER BY PackageType ASC, [FriendlyName] ASC


System.Data.SqlClient.SqlException: Invalid column name 'PortalID'.
Invalid column name 'PortalID'.
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
   at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
   at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
   at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
   at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL)
   at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions)



CREATE PROCEDURE dbo.[GetPackagesByType]
    @PortalID            int,
    @PackageType        nvarchar(50)
AS
    SELECT *
        FROM   dbo.Packages
        WHERE (PortalID = @PortalID OR @PortalID IS NULL OR PortalID IS NULL)
            AND  PackageType = @PackageType
        ORDER BY [FriendlyName] ASC


System.Data.SqlClient.SqlException: Invalid column name 'PortalID'.
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
   at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
   at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
   at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
   at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL)
   at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions)



CREATE PROCEDURE dbo.GetPackageByName
    @PortalID   int,
    @Name        nvarchar(250)
AS
    SELECT *
        FROM   dbo.Packages
        WHERE  [Name] = @Name
            AND (PortalID = @PortalID OR @PortalID IS NULL)


Error: The stored procedure 'dbo.AddPackage' doesn't exist.

-

Thanks,

Adam

I appreciate your response to my problem.  I did in fact read that thread prior to posting a new thread and although the situation is similar to mine, it is not exact nor did it have any sort of resolution.  I decided to make my post by posting as much information as possible, including upgrade procedures, system setup and logs in an effort to possibly get some new insight into my problem or maybe someone with a similar setup has encountered this problem.  I had this problem with 05.00.00 but all the posts I read said to wait for version 05.00.01 and that the new version will fix the 5.0 problems.  However, the problems I had with 5.0 still persisted into 5.01, so I upgraded to 4.92 instead. 

From what I can see, if I can not find resolution here, is to either stay with the 4.x versions, or to run a DB trace on installation and try to find out where in the SQL install script things might be breaking or conflicting with my setup, which could be quite time consuming.

I will continue to monitor both threads and hopefully I can either get resolution to my problem or I will post my findings after I do an intensive investigation into the problem.  I am hoping that someone has already had this issue and resolved it so I can refrain from the latter.

Thanks,

Adam

Understood. Not sure if this is a known issue... If the issue can be located then it can be fixed for the next version of DNN one hopes. You might want to consult the road map in support.dotnetnuke.com

Can you log in afterwards? Does the error persist? If so how does it get triggered? Or (as you imply) it's a yellow screen right whatever you do

Did you follow my advise in the other thread (even though the issue might seem different)... I'm just need some feedback as to whether this works or not, just keen to rule this out.

It does appear a stored procedure is missing, you might want to attach dbo.GetPackageByName Sproc manually to the database afterwards.

Just some shots in the dark. Maybe other people here have better suggestions.

Thanks.