Error: "Error occurred while querying the database ... .NET Framework execution was aborted by escalation policy because of out of memory"
This support note applies to:
- AE Practice Manager (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.
This error can occur during the installation of the Administration Centre in particular its found in RunDbScriptForViz.txt log file after investigating the error "RunDbScriptForViz failed".
The error may also be slightly different and state "The following error occurred while querying the database 'VPMSER' on '(local)' AppDomain VPMSER.dbo[ddl].93 was unloaded by escalation policy to ensure the consistency of your application. Out of memory happened while accessing a critical resource."
There are various methods your IT can use to attempt to fix this issue. There is a Microsoft KB for SQL Server 2008/2008 R2 http://support.microsoft.com/kb/2667742
It is also suggested that you attempt to clear cache by running the following SQL query:
DBCC FREESYSTEMCACHE ('ALL')
You can also attempt to lower the SQL Server maxium server memory:
1. START->All Programs->Microsoft SQL Server 2008 R2->SQL Server Management Studio
2. Connect to correct instance
3. Right click were it states (local) or servername and select properties
4. Click on Memory and lower Maximum server memory and press OK
This should be done either by MYOB technical services if using Express otherwise under the supervision of your IT technical services as reconfiguration may need to be required if a clean instance upgrade needs to be done.