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 when attempting to add new PortalError when attempting to add new Portal
Previous
 
Next
New Post
3/6/2013 3:41 PM
 

I am receiving the following error message when I attempt to add a new Portal to DNN 6.2.5. Not really sure where to go from here. Does anyone have any thoughts regarding this?

Error parsing Website TemplateCould not allocate space for object 'dbo.Tabs'.'PK_Tabs' in database 'C:\INETPUB\WWWROOT\DOTNETNUKE\APP_DATA\DATABASE.MDF' because the 'PRIMARY' filegroup is full. Create disk space by deleting unneeded files, dropping objects in the filegroup, adding additional files to the filegroup, or setting autogrowth on for existing files in the filegroup. 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.ExecuteScalar(String ProcedureName, Object[] commandParameters) at DotNetNuke.Data.SqlDataProvider.ExecuteScalar[T](String ProcedureName, Object[] commandParameters) at DotNetNuke.Data.SqlDataProvider.AddTabToEnd(TabInfo tab, Int32 createdByUserID) at DotNetNuke.Entities.Tabs.TabController.AddTabInternal(TabInfo tab, Int32 afterTabId, Int32 beforeTabId, Boolean includeAllTabsModules) at DotNetNuke.Entities.Tabs.TabController.AddTab(TabInfo objTab) 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, PortalTemplateInfo template, String homeDirectory, String portalAlias, String serverPath, String childPath, Boolean isChildPortal)

 

 
New Post
3/6/2013 4:48 PM
 
I wanted to add more to this to see if it helps

The first problem is I hit the 4GB database limit on SQL and now all commands (Host->SQL) fail, even simple ones like use and select so I have no way to truncate/delete/recover, etc

How does one small site with no traffic could grow a database to 4GB so quickly? I am not talking about the database log here (that is only a few MB). The actual database itself is 4GB already! What the hell could it be storing that is 4GB? I need to know why or it’s just going to keep growing to unmanageable size.

This DNN instance has one active portal, two additional portals created with nothing in either. This one active portal has maxed out 4GB in roughly 6 weeks.

Thoughts?
 
New Post
3/7/2013 8:47 AM
 
Rick,

using the SQL Server Management Studio (SSMS), you could try to shrink the database.

Anyway: I think you are NOT using SQL Server, but the file based stuff called SQL Server Compact. You should change to SQL Server (if you can't afford anything else, take the Express edition).

Let me know when you need help.

Best wishes
Michael

Michael Tobisch
DNN★MVP

dnn-Connect.org - The most vibrant community around the DNN-platform
 
New Post
3/7/2013 8:59 AM
 
We are using Sql Express with this DNN instance. I am really confused by this, as mentioned, there is only one portal and we have maxed out 4GB. I have another instance of DNN 6.2.5 running on different server with 13 portals and Sql has 89MB stored.

Not sure where to turn on this one

Thanks for your assistance Michael
 
New Post
3/7/2013 9:51 AM
 

Rick,

the error message says:

"database 'C:\INETPUB\WWWROOT\DOTNETNUKE\APP_DATA\DATABASE.MDF'"

so I think you're using the file based thing. If I am not correct, can you try to shrink the database using SSMS? Or enter the following command under Host :: SQL (Replace XXX by your database's Name and check the "Run as Script" Checkbox):

DBCC SHRINKDATABASE(N'XXX')
GO

Best wishes
Michael


Michael Tobisch
DNN★MVP

dnn-Connect.org - The most vibrant community around the DNN-platform
 
Previous
 
Next
HomeHomeUsing DNN Platf...Using DNN Platf...Administration ...Administration ...Error when attempting to add new PortalError when attempting to add new Portal


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