Dynamics Community Forum Thread Details

GP Database Server Temp Files

The directory "C:\Users\MSSQLSERVER\AppData\Local\Temp" on our GP SQL server is storing attachments such as invoices and W9's which are attached to vendors in the GP app. MSSQLSERVER is the user which the SQL server service is running. The files are stored with GUID names such as "0a2b657c-4c61-4da5-9776-725400f85433.pdf". These are obviously not the names of the files the user is attaching in the GP app. These files are not being cleaned up and continue to fill up the disk, there are now over 40,000 of them in my case.

I would like to understand how these files get here and if it is safe to delete them. It seems odd to me that this is normal functionality of the application. Is anyone aware of what might be causing these files to accumulate and not be cleaned up?

Thanks

Categories:

Microsoft Dynamics GP

Looking at the TEMP directory for my SQL Server service account, I see ini files beginning with TNT, DAT files, text files, TMP files, and XML. This is without Dynamics GP being open and even after restarting the SQL Server service.

Dynamics GP uses SQL, C-Tree and Memory temp tables with the C-Tree being the most common.

SQL Server cleans their temp tables and Dynamics GP does clean most, but not all of its temp tables, so you're correct in that you'll need to periodically remove them as they can eventually start causing issues with the GP application.

GP temp tables all begin with the 'TNT' prefix and have a .dat, .tmp or .idx extension.

My experience is, if all users are logged out of Dynamics GP and no other users or applications are actively using SQL Server, you should be able to manually delete the files, as the system won't allow you to delete any folders or files that are actually being used by an application.

On my test server, I had 62 folders, 339 files in the TEMP directory, I manually deleted all, then still was able to open SQL Server Mgmt Studio, run queries, as well as login to Dynamics GP without any issues.

Once I got logged into GP and the application was fully loaded, a new folder got written to the SQL account's TEMP directory, and in it were the TMP and INI files for GP, such as GP_LoginErrors.log.

Thanks

Quick Links

Leaderboard