ElevateDB Error 407

This error message is displayed when a table exceeds the maximum default file size.
 
In Atrex 17 and older, the database engine defaults allow for a maximum file size of 4GB for any one single file within the database. Most Atrex installations will never hit this limit, but for installations with a large number of inventory items, a large number of product images, or high transaction volume, additional space within the tables may be required.
 
To allow for larger tables, the ElevateDB database engine can be configured in the Atrex Database Server Administrator to allow for large file support.  With large file support enabled, the maximum file size for any single file in the database is increased to 128GB.  Please note that Large File Support is only available with a client/server configuration of Atrex.
 
Enabling Large File Support:
  1. Close Atrex on all workstations. 
  2. Open the Atrex Database Server Administrator and log into the application..
  3. Select "Tasks - Modify Server Settings" from the main menu.
  4. Click on the "Configuration" tab.
  5. Check (enable) the check box that says "Enable Large File Support".
  6. Click the OK button.
  7. Click Yes when prompted to confirm the restart of the database server.
 
In Atrex 18 and newer, the database engine defaults to Large File Support being enabled.  If you are experiencing this error in Atrex 18, you will need to determine which table is full and reduce the amount of data in that table.  In most cases, this will be the code images table being full because the images are high resolution.  Using the image resize function inside of Atrex and setting a default maximum image size can resolve this issue.