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 “ProjTrans” Table 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 😉