Hi,

When I did an upgrade the DNN 4.0.4 step generated errors that generated the following output in the logfile. Since then users have problems to log in and some user management functions do not work correctely. Does anyone have an idea how I could fix this? Is it possible to run these scripts again? Are these errors fixed when I run an later upgrade? Will the system work well so I can import the users from other source (I ran a backup for the user accounts before doing the upgrade of DNN).

Thanks for any help!
Benno

Error log upgrade step 4.0.4:

System.Data.SqlClient.SqlException: Speicherplatz für das dnn_UserProfile-Objekt in der D14457_euroski-Datenbank konnte nicht reserviert werden, da die PRIMARY-Dateigruppe voll ist.
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)


/* Transfer Profile */
/*********************/

If (SELECT D14457_euroski.dnn_fn_GetVersion(3,2,3)) = 0
BEGIN
--Create Temp Table
CREATE TABLE D14457_euroski.dnn_FlatProfile (
[UserID] [int] ,
[PortalID] [int],
[Username] [nvarchar] (256) NULL ,
[FirstName] [nvarchar] (256) NULL ,
[LastName] [nvarchar] (256) NULL ,
[Street] [nvarchar] (256) NULL ,
[Unit] [nvarchar] (128) NULL ,
[City] [nvarchar] (256) NULL ,
[Country] [nvarchar] (256) NULL ,
[Region] [nvarchar] (256) NULL ,
[PostalCode] [nvarchar] (128) NULL ,
[Telephone] [nvarchar] (128) NULL ,
[Cell] [nvarchar] (128) NULL ,
[Fax] [nvarchar] (128) NULL ,
[Website] [nvarchar] (256) NULL ,
[IM] [nvarchar] (256) NULL,
[PreferredLocale] [nvarchar] (128) NULL ,
[TimeZone] [nvarchar] (256) NULL,
[LastUpdatedDate] [datetime]

)

--Extract from Profile Blob to Temp Table
INSERT INTO dnn_FlatProfile
SELECT
dnn_users.userid,
dnn_userportals.portalid,
dnn_users.username,
dnn_users.firstname,
dnn_users.lastname,
D14457_euroski.dnn_GetProfileElement('Street',PropertyNames,PropertyValuesString) Street,
D14457_euroski.dnn_GetProfileElement('Unit',PropertyNames,PropertyValuesString) Unit,
D14457_euroski.dnn_GetProfileElement('City',PropertyNames,PropertyValuesString) City,
D14457_euroski.dnn_GetProfileElement('Country',PropertyNames,PropertyValuesString) Country,
D14457_euroski.dnn_GetProfileElement('Region',PropertyNames,PropertyValuesString) Region,
D14457_euroski.dnn_GetProfileElement('PostalCode',PropertyNames,PropertyValuesString) PostalCode,
D14457_euroski.dnn_GetProfileElement('Telephone',PropertyNames,PropertyValuesString) Telephone,
D14457_euroski.dnn_GetProfileElement('Cell',PropertyNames,PropertyValuesString) Cell,
D14457_euroski.dnn_GetProfileElement('Fax',PropertyNames,PropertyValuesString) Fax,
D14457_euroski.dnn_GetProfileElement('Website',PropertyNames,PropertyValuesString) Website,
D14457_euroski.dnn_GetProfileElement('IM',PropertyNames,PropertyValuesString) IM,
D14457_euroski.dnn_GetProfileElement('PreferredLocale',PropertyNames,PropertyValuesString) PreferredLocale,
D14457_euroski.dnn_GetProfileElement('TimeZone',PropertyNames,PropertyValuesString) TimeZone,
aspnet_profile.LastUpdatedDate

FROM dnn_Users
inner join dnn_userportals on dnn_users.userid = dnn_userportals.userid
inner join aspnet_users on dnn_users.username = aspnet_users.username
inner join aspnet_profile on aspnet_profile.userid = aspnet_users.userid
where dnn_userportals.portalid = PortalID

--Move to UserProfile Table
EXECUTE dnn_TransferUsersFromFlatProfile N'FirstName'
EXECUTE dnn_TransferUsersFromFlatProfile N'LastName'
EXECUTE dnn_TransferUsersFromFlatProfile N'Unit'
EXECUTE dnn_TransferUsersFromFlatProfile N'Street'
EXECUTE dnn_TransferUsersFromFlatProfile N'City'
EXECUTE dnn_TransferUsersFromFlatProfile N'Region'
EXECUTE dnn_TransferUsersFromFlatProfile N'PostalCode'
EXECUTE dnn_TransferUsersFromFlatProfile N'Country'
EXECUTE dnn_TransferUsersFromFlatProfile N'Telephone'
EXECUTE dnn_TransferUsersFromFlatProfile N'Fax'
EXECUTE dnn_TransferUsersFromFlatProfile N'Cell'
EXECUTE dnn_TransferUsersFromFlatProfile N'Website'
EXECUTE dnn_TransferUsersFromFlatProfile N'IM'
EXECUTE dnn_TransferUsersFromFlatProfile N'TimeZone'
EXECUTE dnn_TransferUsersFromFlatProfile N'PreferredLocale'

--Drop temp objects
DROP TABLE D14457_euroski.dnn_FlatProfile
DROP PROCEDURE D14457_euroski.dnn_TransferUsersFromFlatProfile
END



System.Data.SqlClient.SqlException: Eine neue Seite für die D14457_euroski-Datenbank konnte nicht reserviert werden. In der Dateigruppe PRIMARY sind keine Seiten mehr verfügbar. Speicherplatz kann durch Löschen von Objekten, Hinzufügen von Dateien oder Zulassen der Dateivergrößerung gewonnen werden.
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)


/* Transfer Users */
/*******************/

If (SELECT D14457_euroski.dnn_fn_GetVersion(3,2,3)) = 0
BEGIN
--Create Temp Table to hold users
CREATE TABLE D14457_euroski.dnn_TransferredUsers (
[TransferredAppId] [uniqueidentifier] ,
[Username] [nvarchar] (256) NULL
)

--Declare Variables
DECLARE @PortalID int

-- Transfer Super Users
EXECUTE dnn_TransferUsersToSameContext N'DotNetNuke', NULL

--Iterate through Portals to transfer users
SELECT @PortalID = min(PortalID)
FROM D14457_euroski.dnn_Portals
WHILE @PortalID IS NOT NULL
BEGIN

-- Transfer Portal Users
EXECUTE dnn_TransferUsersToSameContext N'DotNetNuke', @PortalID

SELECT @PortalID = min(PortalID)
FROM D14457_euroski.dnn_Portals
WHERE PortalID > @PortalID
END

--Drop temp objects
DROP TABLE D14457_euroski.dnn_TransferredUsers
DROP PROCEDURE D14457_euroski.dnn_TransferUsersToSameContext
END


System.Data.SqlClient.SqlException: Speicherplatz für das dnn_EventLogTypes-Objekt in der D14457_euroski-Datenbank konnte nicht reserviert werden, da die PRIMARY-Dateigruppe voll ist.
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)


/* Add New LogTypes */
/*********************/

If (SELECT D14457_euroski.dnn_fn_GetVersion(3,2,3)) = 0
BEGIN
INSERT INTO D14457_euroski.dnn_EventLogTypes (
LogTypeKey,
LogTypeFriendlyName,
LogTypeDescription,
LogTypeOwner,
LogTypeCSSClass)
VALUES (
'LOGIN_USERLOCKEDOUT',
'User Locked Out',
'',
'DotNetNuke.Logging.EventLogType',
'OperationFailure'
)

INSERT INTO D14457_euroski.dnn_EventLogTypes (
LogTypeKey,
LogTypeFriendlyName,
LogTypeDescription,
LogTypeOwner,
LogTypeCSSClass)
VALUES (
'LOGIN_USERNOTAPPROVED',
'User Not Approved',
'',
'DotNetNuke.Logging.EventLogType',
'OperationFailure'
)
END

Thanks for the hint. Meanwihle I found out the problem caused by database sice too - thanks anyway. If I don't restore the database, do you think I run in much problems later on? I ask this question because it's quite difficult to get a backup of the whole database from my hoster. Further I have backuped the rest of the site, the users etc. separately an it's easier to restore the users.

I'm a real sql novice but as I understand the errors, only the transfer of the users faild and the log file upgrad - So if I delete users and restore them, there is only the log format. Would it be possible to upgarde the log again?

Benno