Welcome to MSSQL Forum!
MSSQL Forum - Discussions about Microsoft SQL Server

You are currently viewing our community forums as a guest user. Sign up or
Having an account grants you additional privileges, such as creating and participating in discussions.

Dynamics NAV error - "There is not enough memory to complete the current activity"

Discussion in 'Products running on SQL Server' started by Peter Schmitz, Oct 17, 2012.

  1. Peter Schmitz

    Peter Schmitz Administrator Staff Member

    Should you ever attempt to run an upgrade from a native Navision (CSIDE) database to a SQL Server database, and end up seeing an error "There is not enough memory to complete the current activity", chances are that prior to the upgrade, you ran the Microsoft Upgrade Tool from PartnerSource. Using this tool is meant to check all data fields, to ensure that all the data in the database can be exported into the SQL Server table schema for the Dynamics NAV database.

    Apparently, when you run the actual upgrade process (creating a new SQL Server Dynamics database first, and then restoring the backup of the native database into this new DB), these custom objects will cause the error to appear.

    The solution is to first remove the objects from the database (start by deleting the data in the tables), then creating a new database, and then restoring to a fresh database.

Share This Page