Error: "42. All the pages in the database are in use. You need to expand the file"

This support note applies to:

AE Practice Manager (AU)
Profiles (AU)
AE Tax Series 6 & 8 (AU)

These instructions require technical expertise

Make sure you know what you're doing and are using one of the products listed. If you're not sure, ask your IT professional or MYOB.

Article ID: 26630

In MYOB Accountants Enterprise (AE) you may see the error "Environment error 42. All the pages in the database are in use. You need to expand the file".

This message can also be followed by "Environment error 4011. Failed to insert a database record; a record already exists.".

The most common occurrence of these errors is when entering timesheets.

To clear the error message, exit from AE and run the Database Maintenance utility as described below.

To run the Database Maintenance utility

Perform the following instructions from the database server and ensure that you have a current backup.

Run the Application Finder utility to ensure that all users have exited from AE. For details see Running Application Finder.
Ensure the Integrity.exe process is not running. To start and stop Integrity.exe see Stopping and starting Integrity. The Integrity.exe process is stopped.
As per the previously mentioned Running Application Finder the Application Finder will locate where Integrity.exe is running.
Run the Database Maintenance utility. For details see Running Database Maintenance in MYOB Accountants Enterprise.