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

HomeHomeDevelopment and...Development and...SQL and SQL Ser...SQL and SQL Ser...SQL ExceptionSQL Exception
Previous
 
Next
New Post
4/2/2013 5:42 PM
 

When logging into our website, it comes up with:

SQL Exception

Error Details

 

File
Error   Index #: 0
Source: .Net SqlClient Data Provider
Class: 17
Number: 1105
Procedure: als_AddEventLog
Message: System.Data.SqlClient.SqlException: Could not allocate space for object 'dbo.als_EventLog'.'PK_als_EventLogMaster' in database 'databaseshelter' 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.SqlInternalConnection. (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.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.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(SqlConnection connection, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String connectionString, String spName, Object[] parameterValues) at DotNetNuke.Services.Log.EventLog.DBLoggingProvider.Data.SqlDataProvider.AddLog(String LogGUID, String LogTypeKey, Int32 LogUserID, String LogUserName, Int32 LogPortalID, String LogPortalName, DateTime LogCreateDate, String LogServerName, String LogProperties, Int32 LogConfigID) at DotNetNuke.Services.Log.EventLog.DBLoggingProvider.DBLoggingProvider.WriteLog(LogQueueItem objLogQueueItem)

We are a homeless shelter and our website was designed years back as a student project.  I've called our web hosts and they say it is a problem within DotNetNuke.  ANY help is GREATLY appreciated!  We are on a tight deadline to get something uploaded onto our site and I have NO experience dealing with this.

 
New Post
4/2/2013 7:41 PM
 
Basically what this is saying is that your web site database is FULL. It has no more room to store anything.

Technically its really lazy of your host to say its not their problem - it is they who decide how much storage space your website database is given.

But that aside - dnn stores an event log which is a record of things that happen on your web site - if the site has been running unattended for some time - this event like will most likely never have been cleared - and has just kept on growing and growing.

This is actually something that should be done on a regular basis. The event log is in your Admin menu - and should be cleared a least once a month.

What needs to happen is that the contents of the event log table in your database - in this case dbo.als_EventLog needs to be emptied.

If you are able to login to your web site as admin - then just go to the Admin -> Event Viewer - and click on the Clear Log button.

If you cant login - then you need to access the database directly or ask your host to -- and run the MS SQL command:

TRUNCATE TABLE dbo.als_EventLog

This will force the contents of the table to be wiped completely.

Westa
 
New Post
4/3/2013 11:12 AM
 
Thank you so much for your help!  Since we can't log in to our site because of this issue, I contacted our hosts like you suggested.  Thanks to you, I was able to tell them exactly what they needed to do to fix it on their side.  Now, they haven't done it yet, but I at least have hope.  THANK YOU!!!!!!!
 
New Post
4/4/2013 7:21 AM
 
That may be the table that logs events. If so, you may want to turn off some of the logging DNN does. I had that problem a while back and that solved the issue from repeating.

Mark
 
New Post
1/2/2014 8:57 AM
 
I also had this problem.
Was solved ....
thank you very much for help you.
 
Previous
 
Next
HomeHomeDevelopment and...Development and...SQL and SQL Ser...SQL and SQL Ser...SQL ExceptionSQL Exception


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