i tried to move from DNN 6.2.3 to DNN 6.2.7. During the upgrade process I got the following message in the 06.02.04.log.resources file.

System.Data.SqlClient.SqlException (0x80131904): Invalid column name 'Level'.
Invalid column name 'TabPath'.
Invalid column name 'Level'.
Invalid column name 'TabPath'.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout)
at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL)
at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions)
ClientConnectionId:221909a5-d881-44af-b75f-663a72244d63



CREATE PROCEDURE dbo.[BuildTabLevelAndPath](@TabId INT, @IncludeChild BIT = 0)
AS
BEGIN
DECLARE @ParentId INT, @Level INT, @TabPath NVARCHAR(255), @TabName NVARCHAR(50)
SELECT @ParentId = ParentId, @TabName = TabName FROM dbo.[Tabs] WHERE TabID = @TabId
IF @ParentId > 0
BEGIN
SELECT
@Level = [Level] + 1,
@TabPath = TabPath + '//' + dbo.[RemoveStringCharacters](@TabName, '&? ./''-#:*')
FROM dbo.[Tabs] WHERE TabID = @ParentId
END
ELSE
BEGIN
SELECT @Level = 0, @TabPath = '//' + dbo.[RemoveStringCharacters](@TabName, '&? ./''-#:*')
END

UPDATE dbo.[Tabs] SET [Level] = @Level, TabPath = @TabPath WHERE TabID = @TabId

IF @IncludeChild = 1
BEGIN
DECLARE @ChildTabs TABLE(TabID INT)
DECLARE @ChildID INT
INSERT INTO @ChildTabs SELECT TabID FROM dbo.[Tabs] WHERE ParentId = @TabId
WHILE EXISTS (SELECT TOP 1 TabID FROM @ChildTabs)
BEGIN
SET @ChildID = (SELECT TOP 1 TabID FROM @ChildTabs)
EXEC dbo.[BuildTabLevelAndPath] @ChildID, @IncludeChild
DELETE FROM @ChildTabs WHERE TabID = @ChildID
END
END
END



After investigation i realized that during one of my previous upgrades the following file 01.00.05.SqlDataProvider was not executed. The site is working fine but i am not sure if there are any other script that is not executed and how to check that.

Is there anybody that had the same issue and what are the possible consequences. Is it possible somehow to check what else is missing in the DNN installation.
Now i plan to upgrade to DNN v7. is it possible to have more serious problems if the DB is not complete.