We upgraded an installation from 5.6 to 6.0.2 this weekend.  We ran into a few snags mostly dealing with one skin, so no big deal, the skin was just really old and has been upgraded a few times. Today we realized that when we try to add a new portal to the installation we get the following error:
Error parsing Portal TemplateError converting data type nvarchar to int. The statement has been terminated. at System.Data.SqlClient.SqlConnection. (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.SqlDataReader.ConsumeMetaData() at System.Data.SqlClient.SqlDataReader.get_MetaData() at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) at System.Data.SqlClient.SqlCommand.ExecuteScalar() at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteScalar(SqlConnection connection, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteScalar(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteScalar(String connectionString, String spName, Object[] parameterValues) at DotNetNuke.Data.SqlDataProvider.AddModule(Int32 ContentItemID, Int32 PortalID, Int32 ModuleDefID, Boolean AllTabs, DateTime StartDate, DateTime EndDate, Boolean InheritViewPermissions, Boolean IsDeleted, Int32 createdByUserID) at DotNetNuke.Entities.Modules.ModuleController.AddModuleInternal(ModuleInfo module) at DotNetNuke.Entities.Modules.ModuleController.AddModule(ModuleInfo module) at DotNetNuke.Entities.Modules.ModuleController.DeserializeModule(XmlNode nodeModule, XmlNode nodePane, Int32 portalId, Int32 tabId, PortalTemplateModuleAction mergeTabs, Hashtable hModules) at DotNetNuke.Entities.Tabs.TabController.DeserializePanes(XmlNode nodePanes, Int32 PortalId, Int32 TabId, PortalTemplateModuleAction mergeTabs, Hashtable hModules) at DotNetNuke.Entities.Tabs.TabController.DeserializeTab(XmlNode nodeTab, TabInfo objTab, Hashtable hTabs, Int32 PortalId, Boolean IsAdminTemplate, PortalTemplateModuleAction mergeTabs, Hashtable hModules) at DotNetNuke.Entities.Portals.PortalController.ParseTab(XmlNode nodeTab, Int32 PortalId, Boolean IsAdminTemplate, PortalTemplateModuleAction mergeTabs, Hashtable& hModules, Hashtable& hTabs, Boolean IsNewPortal) at DotNetNuke.Entities.Portals.PortalController.ParseTabs(XmlNode nodeTabs, Int32 PortalId, Boolean IsAdminTemplate, PortalTemplateModuleAction mergeTabs, Boolean IsNewPortal) at DotNetNuke.Entities.Portals.PortalController.ParseTemplate(Int32 PortalId, String TemplatePath, String TemplateFile, Int32 AdministratorId, PortalTemplateModuleAction mergeTabs, Boolean IsNewPortal) at DotNetNuke.Entities.Portals.PortalController.CreatePortal(String PortalName, UserInfo objAdminUser, String Description, String KeyWords, String TemplatePath, String TemplateFile, String HomeDirectory, String PortalAlias, String ServerPath, String ChildPath, Boolean IsChildPortal)

Now the behavior is, it seemed to have written data to the portals table but failed before the portal alias record was written.

I have tried copying the templates from the install package as i found in another post (

http://www.dotnetnuke.com/Resources/F... ) but that did not work.

Since it looks like it may be a problem with the table structure (or atleast that LOOKS like what the error is to me), i checked the table structure for portal and portalalias, comparing them with a Fresh DNN 6 installation, we have they are identically.  Also confirmed the parameters in addportalalias are the same.  Looked at the code behind the stored procedure, but it looks pretty lite, it is basically just an insert, and the params line up so i dont think the problem is there.

I posted a bump earlier on this forum thread http://www.dotnetnuke.com/Resources/F..., but that thread seems to be dead, just a statement of the problem and a few bumps (one being mine).

If anyone has any suggestions on how i can go about troubleshooting this I really would appreciate.  

Again the upgrade was from DNN community version 6.0.2 from DNN 5.6

Thanks so much.  We have tried both custom and the standard, same problem.  I will check the logs!

Thought i posted this earlier but i did not see it when i came back to check...

Hi Glynis, I wonder if the key here was i went from 5.6 to 6.0. Any rate I am really confused now.

I did some more research and testing and have found that the Even though the error is raised, we do get the record in the portals table. No record in the portalalias record either.

Also found that the portalsettings record defautlportalalias is not created either. Not really sure if this is important, however i looked a clean install that works and it has the row in portalsettings for each portal. The upgrade does have the row but the propertyvalue is empty (blank).

I have compared the database structures between the clean DNN 6.0.2 that works and the Upgrade that doesnt and pretty much the databases are the same. I did see the upgraded one had some different indexes and some of the stored procedures/views were written differently, my assumption is they were rewritten (cleaned up) and since they did not change functionally, they were not replaced by the upgrade.

All this seems to lead me to 2 possible leads,

1) a table being used by a view may have changed and the view was not recreated (sometimes, i have seen that when a table changes (column order specifically) and it is used by a SQL View, and the view is not recompiled, problems like this occur (I have seen this in the past on older versions of sql anyway), or 2 some of my data is just wrong. If this is the case, i really can not think of a good way to find it. Any suggestions?