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

Home All Forums

Home

Getting Started

Installing DNN ...

Upgrade from 4.9.4 to 5.1.0 unsuccessful

7/1/2009 6:09 PM

veena v

Joined: 4/2/2003

Posts: 45

Upgrade from 4.9.4 to 5.1.0 unsuccessful

I have been trying to upgrade from version 4.9.4 to 5.1.0 but have been unsuccessful. I have tried using the both the Upgrade package and Source package. I get the same error both times. Any help appreciated. Below is the error:

Upgrading DotNetNuke

Current Assembly Version: 05.01.00

Current Database Version: 04.09.04

Upgrade Status Report

00:00:00.625 - Upgrading to Version: 05.01.00
00:00:01.203 -   Executing Script: 05.00.00.SqlDataProvider Error! (see 05.00.00.log for more information)
00:00:32.218 -   Executing Script: 05.00.01.SqlDataProvider Success
00:00:36.765 -   Executing Script: 05.01.00.SqlDataProvider Error! (see 05.01.00.log for more information)
00:00:57.594 -   Executing Application Upgrades: 05.00.00 Error!
00:02:04.375 -   Executing Application Upgrades: 05.00.01 Success
00:02:04.578 -   Executing Application Upgrades: 05.01.00 Error!
00:02:04.907 -   Cleaning Up Files: 05.00.00 Success
00:02:04.907 -   Cleaning Up Files: 05.00.01 Success
00:02:04.907 -   Cleaning Up Files: 05.01.00 Success
00:02:04.907 -   Updating Config Files: 05.00.00 Success
00:02:04.907 -   Updating Config Files: 05.00.01 Success
00:02:04.907 -   Updating Config Files: 05.01.00 Success
00:02:04.907 - Performing General Upgrades
00:02:06.688 - Installing Optional Modules:
00:02:06.688 -   Installing Package File HTML_Community_05.01.00_Install:

Server Error in '/' Application.

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

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.InvalidOperationException: The stored procedure 'dbo.GetPackageByName' doesn't exist.

Source Error:

The source code that generated this unhandled exception can only be shown when compiled in debug mode. To enable this, please follow one of the below steps, then request the URL:

            

            1. Add a "Debug=true" directive at the top of the file that generated the error. Example:

            

              <%@ Page Language="C#" Debug="true" %>

            

            or:

            

            2) Add the following section to the configuration file of your application:

            

            <configuration>

               <system.web>

                   <compilation debug="true"/>

               </system.web>

            </configuration>

            

            Note that this second technique will cause all files within a given application to be compiled in debug mode. The first technique will cause only that particular file to be compiled in debug mode.

            

            Important: Running applications in debug mode does incur a memory/performance overhead. You should make sure that an application has debugging disabled before deploying into production scenario.

Stack Trace:


            [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) +298
   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) +98
   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() +988
   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

Version Information: Microsoft .NET Framework Version:2.0.50727.1433; ASP.NET Version:2.0.50727.1433

7/2/2009 8:56 AM

veena v

Joined: 4/2/2003

Posts: 45

Re: Upgrade from 4.9.4 to 5.1.0 unsuccessful

Any Ideas anybody? What script or file am i missing in the upgrade package to get this error?

These are the steps that I followed:

1) backup web.config file and database

2) Unzip the Upgrade package and extracted to the DNN installation folder

3) Browse to my website

Also I tried:

1)renaming the release.config to web.config and copied my SQL server settings, machine key and other custom settings to web.config from the web.config backup file and

2)browsed to the website.

That also fails and gives the above error.

Thanks in advance for your help!!

7/2/2009 1:01 PM

Sebastian Leupold

www.dnnwerk.de
Joined: 3/8/2004

Posts: 46212

Re: Upgrade from 4.9.4 to 5.1.0 unsuccessful

please post the content of the error logs mentioned above, which reside inside /providers/dataproviders/sqldataprovider folder.

Cheers from Germany,
Sebastian Leupold

Speed up your DNN Websites with TurboDNN

7/6/2009 4:42 PM

veena v

Joined: 4/2/2003

Posts: 45

Re: Upgrade from 4.9.4 to 5.1.0 unsuccessful

here is the content from 05.00.00.log

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

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

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

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

Here is the content from 05.01.00.log

CREATE PROCEDURE dbo.[AddPackage]
@PortalID   int,
@Name       nvarchar(128),
@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,
@CreatedByUserID int
AS
INSERT INTO dbo.Packages
(
  PortalID,
  [Name],
  FriendlyName,
  [Description],
  PackageType,
  Version,
  License,
  Manifest,
  ReleaseNotes,
  [Owner],
  Organization,
  Url,
  Email,
  IsSystemPackage,
  [CreatedByUserID],
  [CreatedOnDate],
  [LastModifiedByUserID],
  [LastModifiedOnDate]
)
VALUES (
  @PortalID,
  @Name,
  @FriendlyName,
  @Description,
  @PackageType,
  @Version,
  @License,
  @Manifest,
  @ReleaseNotes,
  @Owner,
  @Organization,
  @Url,
  @Email,
  @IsSystemPackage,
  @CreatedByUserID,
  getdate(),
  @CreatedByUserID,
  getdate()
)
SELECT SCOPE_IDENTITY()

CREATE PROCEDURE dbo.[UpdatePackage]
@PortalID   int,
@Name       nvarchar(128),
@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,
@LastModifiedByUserID int
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,
   [LastModifiedByUserID] = @LastModifiedByUserID, [LastModifiedOnDate] = getdate()
  WHERE [Name] = @Name

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

System.Data.SqlClient.SqlException: Table 'EventLog' already has a primary key defined on it.
Could not create constraint. See previous errors.
   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)

/* Change primary key of EventLog Table */
/****************************************/

IF NOT EXISTS (SELECT 1 FROM INformATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'dbo.EventLog' AND COLUMN_NAME = 'LogEventID')
BEGIN
  --Note this name does NOT have an object qualifier in 4.x upgrades
  IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = object_id(N'PK_EventLogMaster'))
   ALTER TABLE dbo.EventLog
    DROP CONSTRAINT PK_EventLogMaster

  --Note this name does have an object qualifier in 5.x installs
  IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = object_id(N'PK_EventLogMaster'))
   ALTER TABLE dbo.EventLog
    DROP CONSTRAINT PK_EventLogMaster

  ALTER TABLE dbo.EventLog
   ADD LogEventID bigint NOT NULL IDENTITY (1, 1)

  ALTER TABLE dbo.EventLog
   ADD CONSTRAINT PK_EventLogMaster PRIMARY KEY CLUSTERED ( LogEventID )
END

Thanks

7/8/2009 4:21 PM

veena v

Joined: 4/2/2003

Posts: 45

Re: Upgrade from 4.9.4 to 5.1.0 unsuccessful

Any ideas anyone? My setup is Win 2003, SQL 2000. Does this error have anything to do with running on SQL 2000?

Thanks!

Page 1 of 4

Home

Getting Started

Installing DNN ...

Upgrade from 4.9.4 to 5.1.0 unsuccessful

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:

No Advertising. This includes promotion of commercial and non-commercial products or services which are not directly related to DNN.
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.
Discussion or promotion of DNN Platform product releases under a different brand name are strictly prohibited.
No Flaming or Trolling.
No Profanity, Racism, or Prejudice.
Site Moderators have the final word on approving / removing a thread or post or comment.
English language posting only, please.

Products

Solutions

Resources

Partners

Community

Blog

About

QA

Ideas Test

New Community Website

Upgrading DotNetNuke

Current Assembly Version: 05.01.00

Current Database Version: 04.09.04

Upgrade Status Report

Server Error in '/' Application.

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

DNN Corp. (DotNetNuke)