There is not enough space on server database

Description

This happens when customers have eWay-CRM on their own server with Microsoft SQL Server Express. This version of SQL has a limit of 10 GB for the database size.

There is similar error in the log:

System.Data.SqlClient.SqlException: Could not allocate space for object 'dbo.EWD_AuthTokens'.'PK_EWD_AuthTokens' in database 'eWay' 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.

Version

All versions of eWay-CRM

Difficulty

High

Resolution

For these cases, eWay-CRM allows to save documents and emails on the server disk, not to the database: Save Documents and Emails to Server Folder.

If the space of the database is so full that you cannot even log into eWay-CRM, you need to erase some data right in the database. You can do it by the command below. It erases items in EWD_ItemChanges that are used for the synchronization of changes. This action will perform one time synchronization of folders on eWay-CRM Desktop for all users.

EXEC eWaySP_TruncateItemChanges