You are here: Home / FAQ / Database / Error: 'PRIMARY' filegroup is full

Error: 'PRIMARY' filegroup is full

Description

Synchronization of eWay-CRM fails with the following error:

2017-08-08 08:31:25,874 [114] ERROR w3wp [(null)] - Request processed with error response 'rcDatabaseStorageFull'
eWay.WebService.Core.Exceptions.WebServiceInternalException: Storage full ---> System.Data.SqlClient.SqlException: Could not allocate space for object 'dbo.EWD_BinaryData' in database 'eWayWS_26446' 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.
The statement has been terminated.
   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.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
   at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, SqlDataReader ds, Boolean describeParameterEncryptionRequest)
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, 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 eWay.Core.Data.SynchronizedSqlCommand.<>c__DisplayClass23_0.<ExecuteNonQuery>b__0()
   at eWay.Core.Data.SqlCommandRepeater.RunSqlCommand(SqlCommand command, SqlCommandDelegate sqlCommand)
   at eWay.Core.Data.SynchronizedSqlCommand.ExecuteNonQuery()
   at eWay.WebService.MSSQLDataInterface.WsSqlCommand.<>c__DisplayClass6_0.<ExecuteNonQuery>b__0()
   at eWay.WebService.MSSQLDataInterface.WsSqlCommand.RunCommand(SqlCommandDelegate method)
   --- End of inner exception stack trace ---
   at eWay.WebService.MSSQLDataInterface.WsSqlCommand.RunCommand(SqlCommandDelegate method)
   at eWay.WebService.MSSQLDataInterface.WsSqlCommand.ExecuteNonQuery()
   at eWay.WebService.ServiceLogic.AttachmentManager.<>c__DisplayClass26_0.<WriteAttachmentIntoStorage>b__0()
   at eWay.Core.Data.TransactionRepeater.RunInTransaction(Func`1 transactionCommands, Boolean allowBulkInsert)
   at eWay.WebService.ServiceLogic.AttachmentManager.WriteAttachmentIntoStorage(Boolean revisionsEnabled, Boolean compressed, ItemAttachment attachment, Guid CreatedByGuid)
   at eWay.WebService.ServiceLogic.AttachmentManager.SaveAttachment(ItemAttachment attachment, Guid createdByGuid, Boolean compressed)
   at eWayWSImpala.eWayWS.SaveItemAttachment(Guid SID, ItemAttachment attachment, Boolean compressed)

Version

All versions of eWay-CRM

Difficulty

Medium

Resolution

Solutions are described for these cases:

Option 1: Client Hosts eWay-CRM on His Server and Uses Paid SQL Server

The database has maximum size of the data file. If you want to change it's setting, you will need Microsoft SQL Management Studio. Follow these steps:

  1. Right-click the name of the database and select Properties.
  2. In the properties window, click Files and then the ... icon in the Autogrowth / Maxsize column in the row for the database file.
  3. In the new window, make sure to mark Enable Autogrowth, for example, on 10. Maximum File Size should be set to Unlimited. Now, your database will grow with your data, but you should first check that your server has capacity for larger files.

Option 2: Client Hosts eWay-CRM on His Server and Uses SQL Server Express

SQL Server has 10 GB limit for the database size. In this case, you can set that your documents and emails will be saved to the server file system - see Save Documents and Emails to Server Folder.

Option 3: Client Uses eWay-CRM Premium Trial

If you need more space for testing of eWay-CRM, please contact your sales manager or use phone number on www.eway-crm.com.

Option 4: Client Uses eWay-CRM Free

You need to update to eWay-CRM Premium. In the eWay-CRM ribbon, you can click Purchase and buy eWay-CRM Premium. Software will be hosted on our Cloud on the basis of monthly payment. For more information about eWay-CRM purchase, please contact your sales manager or use phone number on www.eway-crm.com.