Forum


HomeHomePremiumPremiumAdministrationAdministrationDNN Server ErrorDNN Server Error
Previous
 
Next
New Post
11/11/2014 10:03 AM
 

Hi Aderson

I've got a site that is throwing a server error that's knocking the site out.  I'm wondering if you've seen this and have any ideas on how to fix it.

Exception message: Could not allocate space for object 'dbo.EventLog'.'PK_EventLogMaster' in database 'E:\HOSTEDSITES\HANOVERECONOMICDEVELOPMENT.COM\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.

Thank.

Chris

 
New Post
11/11/2014 10:25 AM
 

Hi Chris,

Yes. The database log has grown too big. You need to trim that down.

I have a step by step video on how to clean up your DNN database.

You can ignore the part that I'm using the Sharp Scheduler and just use the script I provide during the video.

One note though: It seems that you are using a local MDF file for your database. The scripts I provide assume you are using SQL express. Not sure if all will work out the same, but I think it is worth a try.

Cheers,

Aderson

 
New Post
11/11/2014 11:50 AM
 

Here's the error I got...

 

System.Data.SqlClient.SqlException (0x80131904): Incorrect syntax near 'SI'. Incorrect syntax near 'FU'. DBCC execution completed. If DBCC printed error messages, contact your system administrator. DBCC execution completed. If DBCC printed error messages, contact your system administrator. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteScriptInternal(String connectionString, String script) ClientConnectionId:a8e5c68c-0906-4d66-adcb-d946f2340330 exec dnnHeroCleanUp

 
New Post
11/12/2014 4:02 AM
 

Hi Chris,

Please post the script so I can have a look.

Thanks,

Aderson

 
New Post
11/12/2014 4:20 AM
 

I just used the scripts mentioned in your video.  The one that creates the cleanup and then the one that runs it.

 
Previous
 
Next
HomeHomePremiumPremiumAdministrationAdministrationDNN Server ErrorDNN Server Error



Try FREE
30 days money back guaranteed