I have a Site Template I created an Export template file  -  i then applied it and it failed giving this error message:

Error parsing Portal TemplateFailed to convert parameter value from a String to a Int32. at System.Data.SqlClient.SqlParameter.CoerceValue(Object value, MetaType destinationType) at System.Data.SqlClient.SqlParameter.GetCoercedValue() at System.Data.SqlClient.SqlParameter.Validate(Int32 index, Boolean isCommandProc) at System.Data.SqlClient.SqlCommand.SetUpRPCParameters(_SqlRPC rpc, Int32 startCount, Boolean inSchema, SqlParameterCollection parameters) at System.Data.SqlClient.SqlCommand.BuildRPC(Boolean inSchema, SqlParameterCollection parameters, _SqlRPC& rpc) 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.ExecuteReader(CommandBehavior behavior, String method) at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteReader(SqlConnection connection, SqlTransaction transaction, CommandType commandType, String commandText, SqlParameter[] commandParameters, SqlConnectionOwnership connectionOwnership) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteReader(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteReader(String connectionString, String spName, Object[] parameterValues) at DotNetNuke.Security.Membership.Data.SqlDataProvider.GetRoleGroupByName(Int32 PortalID, String RoleGroupName) at DotNetNuke.Security.Membership.DNNRoleProvider.GetRoleGroupByName(Int32 PortalID, String RoleGroupName) at DotNetNuke.Entities.Portals.PortalController.CreateRoleGroup(RoleGroupInfo roleGroup) at DotNetNuke.Entities.Portals.PortalController.ParseRoleGroups(XPathNavigator nav, Int32 portalID, Int32 administratorId) 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)

Any Idea what I need to change to fix this?

Are you applying this template to a new DNN installation / portal?

Make sure that the modules and skins that are used in the template have been installed to your DotNetNuke portal before you apply the template.

Hi Lee,

I have a site at http://we-lead.com/default.aspx and trying to create a "clone" of it at http://we-lead.com/helpbuild
All modules are installed in the HOST - but the skin was installed in ADMIN extensions - I installed that for this child site portal - but I'm still getting the same error. Any other ideas?

Hello,

All I can think of is are you using the latest version of DNN? What version are you currently using?

I am experiencing the same problem with the same error message. I followed the Portal Templates Video to the letter and have tried multiple times.

Itcetera or Lee, did you ever find a fix for this? I'm on DNN 05.01.02 (51).

Can you describe the exact error, or copy it here? 

Also, can you describe how you installed DotNetNuke.  Did you use the 5.1.2 install package, the upgrade from another version, or something else?

Hi Joseph,

Thanks for getting back to me.

The error is exactly the same as Itcetera's: "Error parsing Portal TemplateFailed to convert parameter value from a String to a Int32". I've pasted the entire error message and stacktrace again at the bottom of this post.

The current DNN installation is an upgrade from a previous version. The actual DNN install is one we've had for a number of years so it includes a number of plugins and the rest of the baggage that comes with a 4 or 5 year old site. Not sure if it's of any relevance, but the tempate files are 11mb (for .template) and 48mb (for .template.resources).

I'm currently working on a localhost copy of the livesite. I set up the local copy following your Live Site to Localhost migration videos (great vids by the way, thanks). But I've tried to create a portal from template on both the local and live installations, with the same error message. I've also tried applying the template using the site wizard, it gives an ominous "Critical Error" message.

Finally, I have also tried "turning it off an on again" - re-exporting template, re-creating portal etc. but to no avail.

Please let me know if you have any ideas or there is anything else I can provide.

Full error message/stacktrace:

Error parsing Portal TemplateFailed to convert parameter value from a String to a Int32. at System.Data.SqlClient.SqlParameter.CoerceValue(Object value, MetaType destinationType) at System.Data.SqlClient.SqlParameter.GetCoercedValue() at System.Data.SqlClient.SqlParameter.Validate(Int32 index, Boolean isCommandProc) at System.Data.SqlClient.SqlCommand.SetUpRPCParameters(_SqlRPC rpc, Int32 startCount, Boolean inSchema, SqlParameterCollection parameters) at System.Data.SqlClient.SqlCommand.BuildRPC(Boolean inSchema, SqlParameterCollection parameters, _SqlRPC& rpc) 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.ExecuteReader(CommandBehavior behavior, String method) at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteReader(SqlConnection connection, SqlTransaction transaction, CommandType commandType, String commandText, SqlParameter[] commandParameters, SqlConnectionOwnership connectionOwnership) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteReader(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteReader(String connectionString, String spName, Object[] parameterValues) at DotNetNuke.Security.Membership.Data.SqlDataProvider.GetRoleGroupByName(Int32 PortalID, String RoleGroupName) at DotNetNuke.Security.Membership.DNNRoleProvider.GetRoleGroupByName(Int32 PortalID, String RoleGroupName) at DotNetNuke.En ies.Portals.PortalController.CreateRoleGroup(RoleGroupInfo roleGroup) at DotNetNuke.En ies.Portals.PortalController.ParseRoleGroups(XPathNavigator nav, Int32 portalID, Int32 administratorId) at DotNetNuke.En ies.Portals.PortalController.ParseTemplate(Int32 PortalId, String TemplatePath, String TemplateFile, Int32 AdministratorId, PortalTemplateModuleAction mergeTabs, Boolean IsNewPortal) at DotNetNuke.En ies.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)

This is a tough one.  It would seem that there is something in the template the is being treated as an integer but isn't an integer.  It's hard to tell where, too.

For starters, which version of DotNetNuke was used to create the template?  Into which version of DotNetNuke are you trying to add the template?

Hi again,

It's a doozey all right, particularly with the stack trace not really pointing me to what string should be an integer. Thanks for persisting with me though!

I'm creating and using the template in exactly the same version of DNN (5.1.2). I export the template from the existing portal, then 5 minutes later on the same installation, try to create a tab with the template and get this error.

I've also tried deleting all modules that aren't in use, but that hasn't fixed the error.

Some things you could try:

• Do not include content
• Remove modules one at a time to see if a particular module is causing the problem
• Try with a page that has no modules

You might be able to narrow it down to the page or module that is causing the problem.

I'm going to try a different tactic. I found Inventua's shadow module to share content between portals: http://www.inventua.com/shadow-overview.content

I can't solve the template issue, so I'll just use this module to get around it.

Thanks for all you help Joseph, very much appreciated.