Error ocorre in the CheckUpgrade create SP

Upgrading DotNetNuke

Current Assembly Version: 04.08.01

Current Database Version: 03.02.02

00:00:00.124 -   Executing Script: Upgrade.SqlDataProvider Error! (see Upgrade.log for more information)

Warning:

Could not find stored procedure 'porta4br2.DNN3_CheckUpgrade'.

More than 1000 Users

This DotNetNuke Database has 15318 users. As the users and their profiles are transferred to a new format, it is estimated that the script will take ~1.41 minutes to execute.

Click Here To Proceed With The Upgrade.

The upgrade.log file

System.Data.SqlClient.SqlException: Cannot resolve collation conflict for equal to operation.
   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 porta4br2.[DNN3_CheckUpgrade]

AS

 -- Declare a local table variable to hold the duplicate users we are going to transfer
 DECLARE @DuplicateUsers TABLE (
  UserName nvarchar(200) NULL,
  Duplicates int
 )

 INSERT INTO @DuplicateUsers
  SELECT username, 'Duplicates' = count(*)
  FROM aspnet_Users
  GROUP BY username
  HAVING count(*)   > 1
  ORDER BY Duplicates DESC

 SELECT
  U.UserID,
  U.Username,
  U.FirstName,
  U.LastName,
  U.Email,
  D.Duplicates
 FROM porta4br2.DNN3_Users U
  INNER JOIN @DuplicateUsers D ON U.UserName = D.UserName
 WHERE U.IsSuperUser = 1

 SELECT
  U.UserID,
  U.Username,
  U.FirstName,
  U.LastName,
  U.Email,
  D.Duplicates
 FROM porta4br2.DNN3_Users U
  INNER JOIN @DuplicateUsers D ON U.UserName = D.UserName
 WHERE U.IsSuperUser = 0

System.Data.SqlClient.SqlException: Grantor does not have GRANT permission.
Grantor does not have GRANT permission.
Grantor does not have GRANT permission.
Grantor does not have GRANT permission.
Grantor does not have GRANT permission.
Grantor does not have GRANT permission.
Grantor does not have GRANT permission.
Grantor does not have GRANT permission.
Grantor does not have GRANT permission.
Grantor does not have GRANT permission.
Grantor does not have GRANT permission.
Grantor does not have GRANT permission.
Grantor does not have GRANT permission.
Grantor does not have GRANT permission.
Grantor does not have GRANT permission.
Grantor does not have GRANT permission.
Grantor does not have GRANT permission.
Grantor does not have GRANT permission.
Grantor does not have GRANT permission.
Grantor does not have GRANT permission.
Grantor does not have GRANT permission.
Grantor does not have GRANT permission.
Grantor does not have GRANT permission.
Grantor does not have GRANT permission.
Grantor does not have GRANT permission.
Grantor does not have GRANT permission.
Grantor does not have GRANT permission.
Grantor does not have GRANT permission.
Grantor does not have GRANT permission.
Grantor does not have GRANT permission.
Grantor does not have GRANT permission.
Grantor does not have GRANT permission.
Grantor does not have GRANT permission.
Grantor does not have GRANT permission.
Grantor does not have GRANT permission.
Grantor does not have GRANT permission.
Grantor does not have GRANT permission.
Grantor does not have GRANT permission.
Grantor does not have GRANT permission.
Grantor does not have GRANT permission.
Grantor does not have GRANT permission.
Grantor does not have GRANT permission.
   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 Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(SqlConnection connection, CommandType commandType, String commandText, SqlParameter[] commandParameters)
   at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters)
   at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String connectionString, CommandType commandType, String commandText)
   at DotNetNuke.Data.SqlDataProvider.GrantStoredProceduresPermission(String Permission, String LoginOrRole)

declare @exec nvarchar(2000) declare @name varchar(150) declare sp_cursor cursor for select o.name as name from dbo.sysobjects o where ( OBJECTPROPERTY(o.id, N'IsProcedure') = 1 or OBJECTPROPERTY(o.id, N'IsExtendedProc') = 1 or OBJECTPROPERTY(o.id, N'IsReplProc') = 1 ) and OBJECTPROPERTY(o.id, N'IsMSShipped') = 0 and o.name not like N'#%%' and (left(o.name,len('DNN3_')) = 'DNN3_' or left(o.name,7) = 'aspnet_') open sp_cursor fetch sp_cursor into @name while @@fetch_status >= 0 begin  select @exec = 'grant EXECUTE on ' +  @name  + ' to [porta4br2]'  execute (@exec)  fetch sp_cursor into @name end deallocate sp_cursor

System.Data.SqlClient.SqlException: Grantor does not have GRANT permission.
   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 Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(SqlConnection connection, CommandType commandType, String commandText, SqlParameter[] commandParameters)
   at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters)
   at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String connectionString, CommandType commandType, String commandText)
   at DotNetNuke.Data.SqlDataProvider.GrantUserDefinedFunctionsPermission(String ScalarPermission, String TablePermission, String LoginOrRole)

declare @exec nvarchar(2000) declare @name varchar(150) declare @isscalarfunction int declare @istablefunction int declare sp_cursor cursor for select o.name as name, OBJECTPROPERTY(o.id, N'IsScalarFunction') as IsScalarFunction from dbo.sysobjects o where ( OBJECTPROPERTY(o.id, N'IsScalarFunction') = 1 OR OBJECTPROPERTY(o.id, N'IsTableFunction') = 1 ) and OBJECTPROPERTY(o.id, N'IsMSShipped') = 0 and o.name not like N'#%%' and (left(o.name,len('DNN3_')) = 'DNN3_' or left(o.name,7) = 'aspnet_') open sp_cursor fetch sp_cursor into @name, @isscalarfunction while @@fetch_status >= 0 begin if @IsScalarFunction = 1 begin  select @exec = 'grant EXECUTE on ' +  @name  + ' to [porta4br2]'  execute (@exec)  fetch sp_cursor into @name, @isscalarfunction  end else begin  select @exec = 'grant SELECT on ' +  @name  + ' to [porta4br2]'  execute (@exec)  fetch sp_cursor into @name, @isscalarfunction  end end deallocate sp_cursor

Josauro,

I hope you backed up your database and filesystem and are familiar with rolling back to your previous DNN 3.2.2 installation.

There have been some changes in the database which is making a compariosn (by way of "equals") of a value in one database to a value in the other database not possible with out adding a reference to default colation on each side of the equals sign. Essentially, the databases are no longer directly compatible.

I recently upgraded from DNN 3.1.1. I recommend that you upgrade from 3.2.2 like this:

3.2.2 to 3.7

3.7 to 4.2

4.2 to 4.8.2

I believe those are the stepping-stone upgrades that would be best; someone please correct me if I'm off ...

In the DNN download dont have the all older verison :-(