“Memory” full error while Synchronizing AOT and Compiling single table _ Dynamics AX 2012

MS Dynamics AX 2012 R3 CU10, has been implemented internally in our organization. Today, one of our Finance manager called me up to share an issue that he was receiving while running Trial balance.

The error was referring to the project objects “ProjTransTable and the Form.

Hence, I did a complete AOT Synchronization. System completed the synchronization with one error stating that “MSDynamicsAX_model TmpDB” memory is full linking it back to the ProjTrans Table.

I decided to compile ProjTrans table individually and system stopped with the same warning stating that “MSDynamicsAX_model TmpDB” memory is full.

I opened the SQL and took the properties of MSDynamicsAX_model database to check the actual path of the file. In my case the file location was:

“C:\Program Files\Microsoft SQL Server\MSSQL12.MSSQLSERVER\MSSQL\DATA”

I realized that our infrastructure team assigned less space to drive “C” and mistakenly assigned the free space to a different drive and because of having 0 space AX was throwing error. So, I enhanced space of C drive and eventually the error walked away after this activity.

  • We were able to successfully synchronize AOT
  • We were able to successfully compile ProjTrans table
  • we were able to successfully run trail balance and relevant reports

Finally, for us ……mystery was resolved 😉

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s