Hello,
I have been trying to upgrade from 07.00.04 to 07.00.05. while i call instrucion after copying upgrade files all the upgrade successfully except i see an error in red; (00:00:00.717 - Executing Script:07.00.05.SqlDataProvider Error! (see 07.00.05.log.resources for more information))
here is the upgrade page results:
________________________________
Current Database Version: 07.00.04
Upgrade Status Report
00:00:00.436 - Upgrading to Version: 07.00.05
00:00:00.717 - Executing Script:07.00.05.SqlDataProvider Error! (see 07.00.05.log.resources for more information)
00:00:05.739 - Application Upgrades : 07.00.05 Success
00:00:05.754 - Cleaning Up Files: 07.00.05 Success
00:00:05.754 - Updating Config Files: 07.00.05 Success
00:00:05.848 - Performing General Upgrades
00:00:06.487 - Installing Optional Modules:
00:00:06.519 - Installing Package File DDRMenu_02.00.03_Install: Success
00:00:14.597 - Installing Package File DNNCE_CoreMessaging_07.00.05_Install: Success
00:00:18.512 - Installing Package File DNNCE_HTML_07.00.05_Install: Success
00:00:22.208 - Installing Package File DNNCE_Journal_07.00.05_Install: Success
00:00:25.327 - Installing Package File DNNCE_MemberDirectory_07.00.05_Install: Success
00:00:29.585 - Installing Package File DNNCE_MobileManagement_07.00.05_Install: Success
00:00:32.111 - Installing Package File DNNCE_PreviewProfileManagement_07.00.05_Install: Success
00:00:35.309 - Installing Package File DNNCE_RazorHost_07.00.05_Install: Success
00:00:40.642 - Installing Package File DNNCE_SocialGroups_07.00.05_Install: Success
00:00:47.505 - Installing Package File DNNCE_Taxonomy_07.00.05_Install: Success
00:00:51.076 - Installing Package File Telerik_07.00.05_Install: Success
00:01:19.492 - Installing Optional Skins:
00:01:19.507 - Installing Optional Containers:
00:01:19.523 - Installing Optional Languages:
00:01:19.523 - Installing Optional Providers:
00:01:19.601 - Installing Package File DNNMenuNavigationProvider_07.00.05_Install: Success
00:01:22.034 - Installing Package File FiftyOneClientCapabilityProvider_07.00.05_Install: Success
00:01:25.668 - Installing Package File RadEditorProvider_07.00.05_Install: Success
00:01:31.064 - Installing Optional AuthSystems:
00:01:31.095 - Installing Optional Packages:
Upgrade Complete
_____________________________________________________________________________
and here is the log file results for that error: (00:00:00.717 - Executing Script:07.00.05.SqlDataProvider Error! (see 07.00.05.log.resources for more information)):
______________________________________________________________________________
System.Data.SqlClient.SqlException (0x80131904): Could not allocate space for object 'sys.sysobjvalues'.'clst' in database '5251_dnnapitcodb' because the 'PRIMARY' filegroup is full. Create disk space by deleting unneeded files, dropping objects in the filegroup, adding additional files to the filegroup, or setting autogrowth on for existing files in the filegroup.
at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.SqlInternalConnection. (SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning()
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.ExecuteScriptInternal(String connectionString, String script)
CREATE PROCEDURE dbo.[GetFoldersByPermissions]
@PortalID int,
@Permissions nvarchar(300),
@UserID int,
@FolderID int,
@FolderPath nvarchar(300)
AS
DECLARE @IsSuperUser BIT
DECLARE @Admin BIT
DECLARE @Read INT
DECLARE @Write INT
DECLARE @Browse INT
DECLARE @Add INT
--Determine Admin or SuperUser
IF @UserId IN (SELECT UserId FROM dbo.UserRoles WHERE RoleId IN (SELECT RoleId FROM dbo.Roles WHERE PortalId = @PortalId AND RoleName = 'Administrators')) BEGIN SET @Admin = 1 END;
SELECT @IsSuperUser = IsSuperUser FROM dbo.Users WHERE UserId = @UserId;
--Retrieve Permission Ids
IF @Permissions LIKE '%READ%' BEGIN SELECT TOP 1 @Read = PermissionID FROM dbo.Permission WHERE PermissionCode = 'SYSTEM_FOLDER' AND PermissionKey = 'READ' END;
IF @Permissions LIKE '%WRITE%' BEGIN SELECT TOP 1 @Write = PermissionID FROM dbo.Permission WHERE PermissionCode = 'SYSTEM_FOLDER' AND PermissionKey = 'WRITE' END;
IF @Permissions LIKE '%BROWSE%' BEGIN SELECT TOP 1 @Browse = PermissionID FROM dbo.Permission WHERE PermissionCode = 'SYSTEM_FOLDER' AND PermissionKey = 'BROWSE' END;
IF @Permissions LIKE '%ADD%' BEGIN SELECT TOP 1 @Add = PermissionID FROM dbo.Permission WHERE PermissionCode = 'SYSTEM_FOLDER' AND PermissionKey = 'ADD' END;
IF @PortalID IS NULL
BEGIN
SELECT DISTINCT F.*
FROM dbo.Folders F
WHERE F.PortalID IS NULL
AND (F.FolderID = @FolderID OR @FolderID = -1)
AND (F.FolderPath = @FolderPath OR @FolderPath = '')
ORDER BY F.FolderPath
END
ELSE
BEGIN
CREATE TABLE #Skip_Folders(folderid INT PRIMARY KEY(folderid))
INSERT INTO #Skip_Folders
SELECT DISTINCT folderid FROM dbo.FolderPermission FP
JOIN dbo.Permission P ON FP.PermissionID = P.PermissionID
WHERE
((P.PermissionKey = 'WRITE' OR @IsSuperUser=1 OR @Admin=1) OR
FP.PermissionID = CASE WHEN @Read > 0 THEN @Read END OR
FP.PermissionID = CASE WHEN @Write > 0 THEN @Write END OR
FP.PermissionID = CASE WHEN @Browse > 0 THEN @Browse END OR
FP.PermissionID = CASE WHEN @Add > 0 THEN @Add END)
AND FP.FolderID NOT IN (SELECT DISTINCT folderid FROM dbo.FolderPermission WHERE allowaccess=0 AND (userid=@UserId OR roleid=-1 OR roleid IN (SELECT roleid FROM dbo.UserRoles WHERE UserID=@UserId)))
SELECT DISTINCT F.*
FROM dbo.Folders F
JOIN dbo.FolderPermission FP ON F.FolderId = FP.FolderID
JOIN dbo.Permission P ON FP.PermissionID = P.PermissionID
JOIN dbo.UserRoles UR ON UR.RoleID = FP.RoleID
JOIN dbo.Users U ON U.UserId = UR.UserId
JOIN #Skip_Folders sf ON sf.folderid=f.folderid
WHERE ((F.PortalID = @PortalID) OR (F.PortalID IS NULL AND @PortalID IS NULL))
AND (F.FolderID = @FolderID OR @FolderID = -1)
AND (F.FolderPath = @FolderPath OR @FolderPath = '')
AND
((P.PermissionKey = 'WRITE' OR @IsSuperUser=1 OR @Admin=1) OR
FP.PermissionID = CASE WHEN @Read > 0 THEN @Read END OR
FP.PermissionID = CASE WHEN @Write > 0 THEN @Write END OR
FP.PermissionID = CASE WHEN @Browse > 0 THEN @Browse END OR
FP.PermissionID = CASE WHEN @Add > 0 THEN @Add END)
AND FP.AllowAccess = 1
ORDER BY F.FolderPath
DROP TABLE #Skip_Folders
END
__________________________________________________________________________________________
anyway once i saw this error i tried to roll back from begging but unfortunately i face other error related to Telerik.(
Could not load file or assembly 'Telerik.Web.UI' or one of its dependencies. The located assembly's manifest definition does not match the assembly reference. (Exception from HRESULT: 0x80131040)
)
then I forget about rolling back and return the last web.confing file and my website is running now.
please let me know whether above error during upgrading could have bring other problems or not. if it could how could i prevent it happening by checking the 07.00.05.log.resources file content.
Best regards,
Moslem