Products

Solutions

Resources

Partners

Community

Blog

About

QA

Ideas Test

New Community Website

Ordinarily, you'd be at the right spot, but we've recently launched a brand new community website... For the community, by the community.

Yay... Take Me to the Community!

Welcome to the DNN Community Forums, your preferred source of online community support for all things related to DNN.
In order to participate you must be a registered DNNizen

HomeHomeUsing DNN Platf...Using DNN Platf...Administration ...Administration ...Error parsing Portal Template Violation of UNIQUE KEY ERRORError parsing Portal Template Violation of UNIQUE KEY ERROR
Previous
 
Next
New Post
9/25/2009 5:14 AM
 

Any idea what happened and should I be concerned with this error which occured when trying to build a new parent portal from a previously created portal template? The new portal is accessible.

Thanks

Error parsing Portal Template Violation of UNIQUE KEY constraint 'IX_ModulePermission'. Cannot insert duplicate key in object 'dbo.ModulePermission'. The statement has been terminated. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(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.AddModulePermission(Int32 moduleID, Int32 PermissionID, Int32 roleID, Boolean AllowAccess, Int32 UserID) at DotNetNuke.Security.Permissions.ModulePermissionController.AddModulePermission(ModulePermissionInfo objModulePermission) at DotNetNuke.Entities.Modules.ModuleController.DeserializeModulePermissions(XmlNodeList nodeModulePermissions, Int32 PortalId, Int32 ModuleID) 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(String tabName, XmlNode nodeTab, TabInfo objTab, Hashtable hTabs, Int32 PortalId, Boolean IsAdminTemplate, 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, String FirstName, String LastName, String Username, String Password, String Email, String Description, String KeyWords, String TemplatePath, String TemplateFile, String HomeDirectory, String PortalAlias, String ServerPath, String ChildPath, Boolean IsChildPortal)

 
New Post
9/25/2009 6:23 AM
 

Actually only few pages get created, everything else is missing...

 
New Post
10/11/2009 9:16 AM
 

Since I was dealing with the module instances trough the database, the problem was that when DNN came across a module with a already existing ID in the template the process broke...so I had to manually delete this modules from the template in order to build the new portal and than later on i added the needed modules manually...

Thanks

 
New Post
10/11/2009 11:46 AM
 

What do you mean by it coming across a module with an already existing id? Does that mean in your template you have a copy of the same module on 2 different pages in the template? How did you find these duplicates in the template?

 
New Post
10/11/2009 12:52 PM
 

Sorry to be unclear, I was manually inserting a module which originates from Portal/0 trough the DB into the Portal/1 so that when you change the module content in Portal/0 the content will change also in the Portal/1. After creating the portal export from Portal/0 and than applying it to create Portal/1 the portal creation process would brake when it came on the page with that module by saying something like: "Hey module with this ID already exists so I will end this" :) So after deleting the section concerning that module ID from the template the portal was created till the end.

 

 
Previous
 
Next
HomeHomeUsing DNN Platf...Using DNN Platf...Administration ...Administration ...Error parsing Portal Template Violation of UNIQUE KEY ERRORError parsing Portal Template Violation of UNIQUE KEY ERROR


These Forums are dedicated to discussion of DNN Platform and Evoq Solutions.

For the benefit of the community and to protect the integrity of the ecosystem, please observe the following posting guidelines:

  1. No Advertising. This includes promotion of commercial and non-commercial products or services which are not directly related to DNN.
  2. No vendor trolling / poaching. If someone posts about a vendor issue, allow the vendor or other customers to respond. Any post that looks like trolling / poaching will be removed.
  3. Discussion or promotion of DNN Platform product releases under a different brand name are strictly prohibited.
  4. No Flaming or Trolling.
  5. No Profanity, Racism, or Prejudice.
  6. Site Moderators have the final word on approving / removing a thread or post or comment.
  7. English language posting only, please.
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out