Products

Solutions

Resources

Partners

Community

Blog

About

QA

Ideas Test

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 5.0 Upgrade SqlDataProvider ErrorDNN 5.0 Upgrade SqlDataProvider Error
Previous
 
Next
New Post
1/23/2009 2:28 AM
 

 Hi,

I'm having trouble upgrading from 04.09.01 to 05.00.00.

I keep getting the error: 00:00:00.999 -   Executing Script: 05.00.00.SqlDataProvider Error! (see 05.00.00.log for more information)

And here's the log file:

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.

 

I'm running Windows Server 2003 ent with SQL 2000 Ent.

What could I try to resolve this issue?

 
New Post
1/23/2009 3:40 AM
 

please validate, that table dbo.Packages exist in your database and post here the columns it contains. you will need to fix the structure and rerun the affected part of the upgrade script.


Cheers from Germany,
Sebastian Leupold

dnnWerk - The DotNetNuke Experts   German Spoken DotNetNuke User Group

Speed up your DNN Websites with TurboDNN
 
New Post
1/23/2009 3:49 AM
 

The table exists and contains the following columns:

Name,Data Type,Size

PackageID,int,4     (id&key)
Name,nvarchar,50
FriendlyName,nvarchar,250
Description,,nvarchar,2000
PackageType,nvarchar,50
version,nvarchar,50
Licence,ntext,16
Manifest,ntext,16
msrepl_tran_version,uniqueidentifier,16
rowguid,uniqueidentifier,16

hope this nfo helps

 
New Post
1/23/2009 9:55 AM
 

I've copied the db and did some testing.

I've manualy run the 05.00.00.SqlDataOrivider.

Here on in Query Analyzer, parse Query gives the following error:

Server: Msg 159, Level 15, State 1, Line 41
For DROP INDEX, you must give both the table and the index name, in the form tablename.indexname.

Line that failes:
DROP INDEX IX_Packages ON dbo.Packages

If I change the line to:

DROP INDEX dbo.IX_Packages ON dbo.Packages

I get:

Server: Msg 156, Level 15, State 1, Line 41
Incorrect syntax near the keyword 'ON'.

So I just commented it out. 

When I run the script I get error 1:

Server: Msg 4928, Level 16, State 1, Line 17
Cannot alter column 'License' because it is 'ntext'
.

Line that failes:

ALTER TABLE dbo.Packages
 ALTER COLUMN License ntext NULL

Error 2:

Server: Msg 207, Level 16, State 1, Procedure AddPackage, Line 18
Invalid column name 'ReleaseNotes'

Line that failes:

INSERT INTO dbo.Packages
 (
  PortalID,
  [Name],
  FriendlyName,
  [Description],
  PackageType,
  Version,
  License,
  Manifest,
  ReleaseNotes,
  [Owner],
  Organization,
  Url,
  Email,
  IsSystemPackage
 )

Error 3:

Server: Msg 207, Level 16, State 1, Procedure UpdatePackage, Line 18
Invalid column name 'Owner'.

Line that Failes:

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

After the script the Packages table contains the folloing columns:

3 PackageID int 4 0
0 Name nvarchar 50 0
0 FriendlyName nvarchar 250 0
0 Description nvarchar 2000 1
0 PackageType nvarchar 50 0
0 Version nvarchar 50 0
0 License ntext 16 0
0 Manifest ntext 16 0
0 msrepl_tran_version uniqueidentifier 16 0
0 rowguid uniqueidentifier 16 0
0 PortalID int 4 -1
 

 
New Post
1/26/2009 9:00 AM
 

Any idea what I could do to resolve this issue? Or should I wat for the next release of dnn?
 

 
Previous
 
Next
HomeHomeGetting StartedGetting StartedInstalling DNN ...Installing DNN ...DNN 5.0 Upgrade SqlDataProvider ErrorDNN 5.0 Upgrade SqlDataProvider Error


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