We recently upgraded from 5.5 to 6.3 and we are now having problems creating portals from templates. When we do, we get the error below and it doesn't create the entire site. The admin link isn't even displayed. This happens if I try to create the template on either of 2 different servers and if the portal is created on the same server the template was made or on the other server.
I've tried creating the portal with a template that does and doesn't have the data as well as with creating a new account for the portal or just using the existing one. These are sites I've created templates from in 5.5
I've seen some links on the forums about this but they seem to be old versions of DNN and say it's a bug that is fixed in version 5.x or the only solution they list is deleting modules to find the problem. We have a lot of modules and a lot of pages. Any help resolving this would be much appriciated
Error parsing Portal TemplateViolation of UNIQUE KEY constraint 'IX_ModulePermission'. Cannot insert duplicate key in object 'dbo.ModulePermission'. The statement has been terminated. at System.Data.SqlClient.SqlConnection. (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.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(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteScalar(String connectionString, String spName, Object[] parameterValues) at DotNetNuke.Data.SqlDataProvider.AddModulePermission(Int32 moduleID, Int32 PermissionID, Int32 roleID, Boolean AllowAccess, Int32 UserID, Int32 createdByUserID) at DotNetNuke.Security.Permissions.PermissionProvider.SaveModulePermissions(ModuleInfo objModule) at DotNetNuke.Security.Permissions.ModulePermissionController.SaveModulePermissions(ModuleInfo objModule) 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 tabNode, TabInfo tab, Hashtable tabs, Int32 portalId, Boolean isAdminTemplate, PortalTemplateModuleAction mergeTabs, Hashtable modules) 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 adminUser, String description, String keyWords, String templatePath, String templateFile, String homeDirectory, String portalAlias, String serverPath, String childPath, Boolean isChildPortal)