Hi,

I'm having some issues upgrading to dnn 2.0.2/2.0.3 (I've tried both). First off I need to mention that what I did for the upgrade was duplicate the working production database (of version 1.0.10) to a testing database before uploading any 2.0.2 files. I uploaded all of the 1.0.10 files to a testing directory I use and had the duplicate copy of 1.0.10 working fine for each of my portals (I have something like 6 - 7 portals). I then uploaded the 2.0.2 files to this directory. When went to testing.codekai.com I received this error "An error has occurred writing to the exception log. The directory was not found". I then noticed that the beta 3 has been released so I uploaded those files and still received this error. I would greatly appreciate any help.

Thanks so much,
Travis

Do you have the log folder under /portals/_default ?



Bruce

Well I got that resolved. The /Portals/_default/Logs" was missing. However, no I just get an error message that is not detailed. Custom errors is set to off. Is this because of a database issue? Sorry, I'm new to asp.net and dnn. Any ideas on what I could do?

Thanks in advance,
Travis Bennington

Setting custom errors to off won't have any affect because we aren't relying on the ASP.NET custom errors...we have added an exception handling mechanism to DNN which displays custom error messages.

If you are logged in as HOST, you will see the details of the stack trace if the error happens within a module or if the error is non-critical. Critical errors, often in the skin design or something else, result in a more basic error message that will be displayed at the top of the screen. If you are not logged in as HOST, your error messages will be basic and not too informative...this is by design for security reasons and for a better end-user experience.

If you can get into your site, you can click on "Exceptions Viewer" on the "Host" tab and view it through the new module/tab. Or, as long as your /portals/_default/logs directory is there now, you should be able to look at the Exceptions.Resource file to view the details of the exception. The Exceptions.Resource file is an XML file...so to view it directly, try copying it to another directory and renaming the extension to .xml...it will probably open up in Internet Explorer.

Dan

Hi,

Thanks I can use the exceptions.resource file to view logs. Now that I can I have no idea what the problem is. Here is what I'm getting.

<ExceptionInformation><AdditionalInformationProperty ExceptionManager.MachineName="DEDI319" ExceptionManager.TimeStamp="3/12/2004 5:49:23 AM" ExceptionManager.FullName="Microsoft.ApplicationBlocks.ExceptionManagement, Version=1.0.1515.12425, Culture=neutral, PublicKeyToken=null" ExceptionManager.AppDomainName="/LM/w3svc/122/ROOT-20-127235627816763750" ExceptionManager.ThreadIdentity="" ExceptionManager.WindowsIdentity="NT AUTHORITY\NETWORK SERVICE" /><Exception ExceptionType="Microsoft.ApplicationBlocks.ExceptionManagement.BaseApplicationException" MachineName="DEDI319" CreatedDateTime="3/12/2004 5:49:23 AM" AppDomainName="/LM/w3svc/122/ROOT-20-127235627816763750" ThreadIdentityName="" WindowsIdentityName="NT AUTHORITY\NETWORK SERVICE" Message="Unhandled Error: "><Exception ExceptionType="System.InvalidOperationException" Message="The stored procedure 'dbo.VerifyPortalTab' doesn't exist." TargetSite="Void DeriveParameters()" Source="System.Data"><StackTrace> at System.Data.SqlClient.SqlCommand.DeriveParameters()
at System.Data.SqlClient.SqlCommandBuilder.DeriveParameters(SqlCommand command)
at Microsoft.ApplicationBlocks.Data.SqlHelperParameterCache.DiscoverSpParameterSet(SqlConnection connection, String spName, Boolean includeReturnValueParameter, Object[] parameterValues)
at Microsoft.ApplicationBlocks.Data.SqlHelperParameterCache.GetSpParameterSetInternal(SqlConnection connection, String spName, Boolean includeReturnValueParameter)
at Microsoft.ApplicationBlocks.Data.SqlHelperParameterCache.GetSpParameterSet(String connectionString, String spName, Boolean includeReturnValueParameter)
at Microsoft.ApplicationBlocks.Data.SqlHelperParameterCache.GetSpParameterSet(String connectionString, String spName)
at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteReader(String connectionString, String spName, Object[] parameterValues)
at DotNetNuke.Data.SqlDataProvider.VerifyPortalTab(Int32 PortalId, Int32 TabId)
at DotNetNuke.PortalSettings.VerifyPortalTab(Int32 PortalId, Int32 TabId, Int32 HomeTabId)
at DotNetNuke.PortalSettings.GetPortalSettings(Int32 TabId, Int32 PortalId, String ApplicationPath)
at DotNetNuke.PortalSettings..ctor(Int32 tabId, Int32 PortalId, String ApplicationPath)
at DotNetNuke.Global.Application_BeginRequest(Object sender, EventArgs e)
at System.Web.SyncEventExecutionStep.System.Web.HttpApplication+IExecutionStep.Execute()
at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean&amp; completedSynchronously)</StackTrace></Exception></Exception></ExceptionInformation>
</exceptions>

Ok, the one thing that jumps out at me is "The stored procedure 'dbo.VerifyPortalTab' doesn't exist". It looks like the install didn't complete, perhaps. Can you look at your Version table and see what the values in the last row are? As the upgrade completes, it updates the Version table to show the last SQL file that was run.

Also, are you using MS Access or SQL Server?

Dan

Hi,

Here are the values in the last row of the version table. Also, I'm using SQL Server.

VersionId: 14
Major: 2
Minor: 0
Build: 2
CreateDate: 3/11/2004 6:10:11 PM

Thank you so much,
Travis Bennington

Ok, can you look in this directory for error logs relating to the SQL Server Data Provider:

/Providers/DataProviders/SqlDataProvider

Open up the files with the .Log extension. These file represent any errors that may have occured during the SQL Database upgrades. Specifically look for any of these files that have a file size greater than 1Kb and that will indicate the existence of errors.

Reply back with anything interesting in these files.

Dan

Hi Dan,

There are three logs in sqlprovider directory. Two of them, 02.00.00.log and 02.00.01.log, are greater than 1 kb. The other 02.00.02.log is empty. Anyway here is what each contains:

02.00.00.log
System.Data.SqlClient.SqlException: Ambiguous column name 'Description'.
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.ExecuteScript(String Script, Boolean UseTransactions)


create procedure dbo.GetPortalTabModules

@PortalId int,
@TabId int

as

select Modules.*,
FriendlyName,
DesktopSrc,
MobileSrc,
AdminOrder,
EditSrc,
Secure,
Description,
AdminTabIcon,
EditModuleIcon,
IsPremium
from Modules
inner join ModuleDefinitions on Modules.ModuleDefId = ModuleDefinitions.ModuleDefId
inner join Tabs on Modules.TabId = Tabs.TabId
where Modules.TabId = @TabId
or (Modules.AllTabs = 1 and Tabs.PortalId = @PortalId)
order by ModuleOrder


System.Data.SqlClient.SqlException: Column names in each table must be unique. Column name 'Description' in table 'dbo.Tabs' is specified more than once.
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.ExecuteScript(String Script, Boolean UseTransactions)


ALTER TABLE dbo.Tabs ADD
Title nvarchar(200) NULL,
Description nvarchar(500) NULL,
KeyWords nvarchar(500) NULL,
IsDeleted bit NOT NULL CONSTRAINT DF_Tabs_IsDeleted DEFAULT 0


System.Data.SqlClient.SqlException: Invalid column name 'Title'.
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.ExecuteScript(String Script, Boolean UseTransactions)


create procedure dbo.AddTab

@PortalId int,
@TabName nvarchar(50),
@AuthorizedRoles nvarchar(256),
@IsVisible bit,
@DisableLink bit,
@ParentId int,
@IconFile nvarchar(100),
@AdministratorRoles nvarchar(256),
@Title nvarchar(200),
@Description nvarchar(500),
@KeyWords nvarchar(500)

as

insert into Tabs (
PortalId,
TabName,
AuthorizedRoles,
IsVisible,
DisableLink,
ParentId,
IconFile,
AdministratorRoles,
Title,
Description,
KeyWords,
IsDeleted
)
values (
@PortalId,
@TabName,
@AuthorizedRoles,
@IsVisible,
@DisableLink,
@ParentId,
@IconFile,
@AdministratorRoles,
@Title,
@Description,
@KeyWords,
0
)

select SCOPE_IDENTITY()



System.Data.SqlClient.SqlException: Invalid column name 'Title'.
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.ExecuteScript(String Script, Boolean UseTransactions)


create procedure dbo.UpdateTab

@TabId int,
@TabName nvarchar(50),
@AuthorizedRoles nvarchar(256),
@IsVisible bit,
@DisableLink bit,
@ParentId int,
@IconFile nvarchar(100),
@AdministratorRoles nvarchar(256),
@Title nvarchar(200),
@Description nvarchar(500),
@KeyWords nvarchar(500),
@IsDeleted bit

as

update Tabs
set TabName = @TabName,
AuthorizedRoles = @AuthorizedRoles,
IsVisible = @IsVisible,
DisableLink = @DisableLink,
ParentId = @ParentId,
IconFile = @IconFile,
AdministratorRoles = @AdministratorRoles,
Title = @Title,
Description = @Description,
KeyWords = @KeyWords,
IsDeleted = @IsDeleted
where TabId = @TabId


System.Data.SqlClient.SqlException: Cannot drop the procedure 'dbo.GetPortalTabModules', because it does not exist in the system catalog.
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.ExecuteScript(String Script, Boolean UseTransactions)


drop procedure dbo.GetPortalTabModules


System.Data.SqlClient.SqlException: Invalid column name 'Title'.
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.ExecuteScript(String Script, Boolean UseTransactions)


declare @DesktopModuleID int

insert into DesktopModules (
FriendlyName,
Description,
Version,
IsPremium,
IsAdmin
)
values (
'Recycle Bin',
'The Recycle Bin provides an interface for restoring or permanently deleting Tabs and Modules.',
null,
0,
1
)

SET @DesktopModuleID = @@IDENTITY

DECLARE @ModuleDefID int

insert into ModuleDefinitions (
FriendlyName,
DesktopModuleID
)
values (
'Recycle Bin',
@DesktopModuleID
)

SET @ModuleDefID = @@IDENTITY

insert into ModuleControls (
ControlKey,
ControlTitle,
ModuleDefID,
ControlSrc,
IconFile,
ControlType,
ViewOrder
)
values (
null,
null,
@ModuleDefID ,
'Admin/Tabs/RecycleBin.ascx',
null,
1,
null
)

declare @TabId int
declare @ModuleOrder int
declare @PortalId int
declare @Roles nvarchar(256)
declare @TabOrder int
declare @NewTabId int

select @TabId = min(TabId)
from Tabs
where TabName = 'Admin'
while @TabId is not null
begin
select @PortalId = PortalId,
@Roles = AuthorizedRoles
from Tabs
where TabId = @TabId

select @TabOrder = max(TabOrder) + 2
from Tabs
where PortalId = @PortalId

insert into Tabs (
PortalId,
TabOrder,
TabName,
AuthorizedRoles,
IsVisible,
DisableLink,
ParentId,
Level,
IconFile,
AdministratorRoles,
Title,
Description,
KeyWords,
IsDeleted
)
values (
@PortalId,
@TabOrder,
'Recycle Bin',
@Roles,
1,
0,
@TabId,
1,
'icon_recyclebin_16px.gif',
null,
'',
'',
'',
0
)

select @NewTabId = @@IDENTITY

insert into Modules (
TabId,
ModuleDefId,
ModuleOrder,
PaneName,
ModuleTitle,
AuthorizedEditRoles,
CacheTime,
ShowMobile,
AuthorizedViewRoles,
Alignment,
Color,
Border,
IconFile,
AllTabs,
ShowTitle,
Personalize,
Container
)
values (
@NewTabId,
@ModuleDefId,
1,
'ContentPane',
'Recycle Bin',
@Roles,
0,
0,
null,
null,
null,
null,
'icon_recyclebin_32px.gif',
0,
1,
0,
null
)

select @TabId = min(TabId)
from Tabs
where TabName = 'Admin'
and TabId > @TabId
end


System.Data.SqlClient.SqlException: Invalid column name 'IsDeleted'.
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.ExecuteScript(String Script, Boolean UseTransactions)


declare @DesktopModuleID int

insert into DesktopModules (
FriendlyName,
Description,
Version,
IsPremium,
IsAdmin
)
values (
'Exception Viewer',
'The Exception Viewer provides an interface for viewing portal exceptions.',
null,
0,
1
)

SET @DesktopModuleID = @@IDENTITY

DECLARE @ModuleDefID int

insert into ModuleDefinitions (
FriendlyName,
DesktopModuleID
)
values (
'Exception Viewer',
@DesktopModuleID
)

SET @ModuleDefID = @@IDENTITY

insert into ModuleControls (
ControlKey,
ControlTitle,
ModuleDefID,
ControlSrc,
IconFile,
ControlType,
ViewOrder
)
values (
null,
null,
@ModuleDefID ,
'Admin/Portal/ExceptionViewer.ascx',
null,
0,
null
)

declare @TabOrder int
declare @ParentId int
declare @TabID int

select @TabOrder = max(TabOrder) + 2
from Tabs
where PortalID is null

select @ParentId = TabId
from Tabs
where TabName = 'Host'

insert into Tabs (
TabOrder,
PortalId,
TabName,
AuthorizedRoles,
IsVisible,
ParentId,
Level,
IconFile,
AdministratorRoles,
DisableLink,
IsDeleted
)
values (
@TabOrder,
null,
'Exception Viewer',
'-2;',
1,
@ParentId,
1,
'icon_exceptionviewer_16px.gif',
null,
0,
0
)

select @TabID = @@IDENTITY

insert into Modules (
TabId,
ModuleDefId,
ModuleOrder,
PaneName,
ModuleTitle,
AuthorizedEditRoles,
CacheTime,
ShowMobile,
AuthorizedViewRoles,
Alignment,
Color,
Border,
IconFile,
AllTabs,
ShowTitle,
Personalize,
Container
)
values
(
@TabID,
@ModuleDefID,
1,
'ContentPane',
'Exception Viewer',
'-2;',
0,
0,
null,
null,
null,
null,
null,
0,
1,
0,
null
)


02.00.00.log
System.Data.SqlClient.SqlException: Invalid column name 'IsDeleted'.
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.ExecuteScript(String Script, Boolean UseTransactions)


create procedure dbo.VerifyPortalTab

@PortalId int,
@TabId int

as

select Tabs.TabId
from Tabs
left outer join Portals on Tabs.PortalId = Portals.PortalId
where TabId = @TabId
and ( Portals.PortalId = @PortalId or Tabs.PortalId is null )
and IsDeleted = 0


sorry that I had to include everything but I have no idea where the problem could be. I hope this helps.

Thanks a lot Dan. I appreciate your help,
Travis Bennington

Travis,

1. Have you customized any of the tables from 1.0.10 or earlier?
2. Did you try the upgrade more than once?

Dan

Dan,

I have not customized any of the tables. However, it's possible that my friend, who also works on the sites, may have. I have tried the upgrade more than once. I'll try doing it again.

Thanks,
Travis

Before you try again, start off with fresh tables from your 1.0.10 install....rather than trying to upgrade on your "half-upgraded" tables.

Dan

Dan,

Restored the database again with the back up of the production database. No luck. Do you think it would be easier to install DNN 2.0.3 on a blank database? Then import the necessary database tables from the production database. Is this a problem though since this db is using DNN 1.0.10. I don't know what else to do. The only thing I need from this database is the content and the portals. I can reinstall any modules. What do you think? Do have any other ideas? I just want to have the testing database to have a copy of all the portals and content, while the other production database is still running DNN 1.0.10.

Thank you so much for your help Dan,
Travis

You should be able to upgrade from 1.0.10 to 2.x...this might be a bug.

So the end result was exactly the same? Same errors generated in those sql .log files?

If this is the case, I will try the upgrade from 1.0.10 to 2.0.3 locally and see if I run into the same problem. Let me know if you had the exact same errors before I try this.

Dan

Yup, I got the same errors.

Travis