You are attempting to update your Sage ACT! database and receive the following error:
"Exceptions occurred while executing the database Schema Update Script."
Checking the schema update log, you find the following message:
“System.Data.SqlClient.SqlException: There is insufficient system memory in resource pool 'internal' to run this query.”
Product Family: Sage ACT!
Product: Sage ACT! Pro, Sage ACT! Premium
This can occur when insufficient system resources are available during the update. Use the following steps to try and resolve this issue:
- Ensure the system has 2 gb or more of RAM (memory).
- If the computer has over 2gb of memory, try Selective Startup.
For information on restarting the computer in Selective Startup, review the following article:
Title: How To Restart in Windows Selective Startup Mode
Answer ID: How To Restart in Windows Selective Startup Mode